Backup MySQL for Fun and Profit!
So we’ve established how important backups are, RTO, RPO, and how you can be a hero by having backups that align with business objectives. We just need to pick a good backup tool(s) to take backups of your MySQL database. Databases evolve, grow, and business needs change. That’s why it is important to constantly reevaluate your backup strategy, because what worked last year may not be appropriate this year in terms of RPO/RTO, retention, or costs.
Geo-Distributed Galera Clusters
Galera Cluster provides high availability and scalability for MySQL. While this provides high availability in a local region or site, it does not provide any provisions for disaster recovery (DR) or any multi-site deployment in general, so let’s explore how we could extend the functionality of Galera Cluster to deploy at geo-scale.
Geo-Distributed Oracle MySQL InnoDB Clusters
Oracle MySQL InnoDB Cluster provides high availability and scalability for MySQL. An InnoDB Cluster consists of 3 or more MySQL instances in a local network with group replication enabled, MySQL Shell which is used for management of the cluster, and optionally MySQL Router to provide basic routing from applications to the cluster. While this provides high availability in a local region or site, it does not provide any provisions for disaster recovery (DR) or any multi-site deployment in general, so let’s explore how we could extend the functionality of InnoDB Cluster to deploy at geo-scale.
MySQL Disaster Recovery (DR) with InnoDB Cluster - Really?
Doing a search with InnoDB Cluster with DR (Disaster Recovery) yields lots of results, but does it actually work in the enterprise?
DR with InnoDB Cluster - Possible?
Doing a search with InnoDB Cluster with DR (Disaster Recovery) yields lots of results, but does it actually work in the enterprise?
Asynchronous Replication and Data Loss
We often hear that asynchronous replication creates a possible data loss window, thus it is not an acceptable solution for certain types of applications.
Yes, this is true. In theory, that is.
In practice, we have developed the Tungsten Cluster solution to the point that it really does not happen in real life. Please read this blog to understand why not!
Migrate from Galera to Tungsten Clustering without Downtime
Migrating from Galera to Tungsten Clustering is easy with the tools provided by Tungsten Clustering. Because replication happens in the background, applications can stay online with a quick cutover to Tungsten Clustering when ready.
ClusterControl - High Noon with Tungsten Clustering for MySQL High Availability (HA), Disaster Recovery (DR) and Geographic Distribution
This is the next blog in our competitor comparison series in which we look at the main solutions for MySQL high availability, disaster recovery and geographic distribution. Here we focus on highly available, geo-scale, multi-region MySQL for mission-critical sites and apps with ClusterControl as compared to MySQL clusters with Continuent Tungsten, the only complete, fully-integrated clustering solution for MySQL - on-premises, in the cloud, hybrid-cloud or multi-cloud.
Geo-MySQL Reality Check: How Galera Cluster Caused Downtime
A telco company recently came to us looking for an improvement to their Galera deployment. Their two main complaints were the unplanned downtime forced by Galera Cluster [aka MariaDB Cluster or Percona XtraDB Cluster], and the lack of reliable geo-scale deployment.
Continuent showed them how our solution, Tungsten Clustering, provides maximum MySQL uptime and is built for geo-scale (active/passive and active/active) MySQL deployments.
Oracle’s InnoDB Cluster - High Noon with Tungsten Clustering for MySQL High Availability (HA), Disaster Recovery (DR) and Geographic Distribution
This is the fifth blog in our ‘High Noon’ comparison series in which we look at the main solutions for MySQL high availability, disaster recovery and geographic distribution. Here we focus on highly available, geo-scale, multi-region MySQL for mission-critical sites and apps with Oracle’s InnoDB Cluster as compared to MySQL clusters with Continuent Tungsten, the only complete, fully-integrated clustering solution for MySQL - on-premises, in the cloud, hybrid-cloud or multi-cloud.
MS Azure MySQL - High Noon with Tungsten Clustering MySQL High Availability (HA), Disaster Recovery (DR) and Geographic Distribution
This is the next in our ‘High Noon’ comparison series in which we look at the main solutions for MySQL high availability, disaster recovery and geographic distribution. Here we focus on highly available, geo-scale, multi-region MySQL for mission-critical sites and apps with Microsoft Azure Database for MySQL as compared to native MySQL, MariaDB clusters with Continuent Tungsten in the cloud, hybrid-cloud, multi-cloud or on-premises.
Google Cloud (GCP) for MySQL - High Noon with Tungsten Clustering MySQL High Availability (HA), Disaster Recovery (DR) and Geographic Distribution
This is the next blog in our ‘High Noon’ comparison series in which we look at the main solutions for MySQL high availability, disaster recovery and geographic distribution. Here we focus on highly available, geo-scale, multi-region MySQL for mission-critical sites and apps with Google Cloud (GCP) for MySQL as compared to MySQL, MariaDB clusters with Continuent Tungsten, the only complete, fully-integrated clustering solution for MySQL - on-premises, in the cloud, hybrid-cloud or multi-cloud.