MySQL High Availability (HA) & Disaster Recovery (DR)

Doing a search with InnoDB Cluster with DR (Disaster Recovery) yields lots of results, but does it actually work in the enterprise?

For MySQL and MariaDB database clusters, Saas, Fintech and other organizations with business-critical databases typically require what’s called a managed “composite” cluster, or “cluster-of-clusters.” This blog is about active/active versus active/passive composite clusters for MySQL and MariaDB database systems.

This blog is the first blog in a new series about Tungsten’s QA (Quality Assurance). Continuent Tungsten is a clustering and replication solution for MySQL and MariaDB, used by some of the largest MySQL estates to achieve continuous MySQL operations and uptime; why? Besides the stellar support team, and fully-integrated components, customers say: “Stability,” and, “It just works.”

Welcome to the wonderful world of open source! You really are on your own, even if you think you acquire a solution that works. But many of the companies offering solutions based on open source components wrapped with expensive consulting engagements really can’t help you as they are not the original developers of some of the important core components, thus they do not have the necessary skills to fix them either.Welcome to the wonderful world of open source! You really are on your own, even if you think you acquire a solution that works. But many of the companies offering solutions based on open source components wrapped with expensive consulting engagements really can’t help you as they are not the original developers of some of the important core components, thus they do not have the necessary skills to fix them either.

Instead of contributing back to the original project, and in that way benefitting the project as a whole, Percona takes over smaller open-source projects (such as Galera) and larger open source projects (MySQL, MongoDB), then adds some small enhancements (especially when compared to the work done by the original developers), slaps its own name on it and proceeds to make some negative comments against those who have done the hardest work.

There are two key elements (which often separate us from many other open source operators, such as Percona) to our MySQL HA/DR and Continuous Operations solutions. Read this blog, adapted from the June “Word from the CEO” from the Continuent Newsletter to find out what distinguishes Continuent’s Tungsten Clustering solution in the open source MySQL database industry.

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!

This blog is about open source MySQL clustering software, specifically Codership’s Galera Cluster and Percona’s fork of that, XtraDB Cluster. If you are considering using Galera, please use the original version, or please use the version by MariaDB, which is actively supporting the Galera team.

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.

Disasters are waiting to happen. Like OVH data center fire on March 9, 2021. Do you have a solid MySQL Disaster Recovery (DR) plan in place to activate when the time inevitably comes?

If not, Continuent is happy to review your current MySQL HA/DR deployment and to recommend possible changes that might be recommended. Naturally, free of charge.

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.

Customers often ask where they should install their MySQL, MariaDB, or Percona MySQL database proxies for high availability clusters, and how many. What is optimal for you may not be the right configuration for everyone. However there are some best practices we’ll discuss in this basic blog about deploying MySQL database proxies.