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

For multi-site, multi-region, or geo-distributed MySQL or MariaDB clusters, Saas, Fintech and other organizations with business-critical MySQL databases typically require what’s called a managed “composite” cluster, or “cluster-of-clusters.” This blog is about active/active and active/passive composite clusters for multi-site 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.

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.

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.

This blog discusses Asynchronous versus Synchronous MySQL replication for MySQL clustering. Synchronous replication is viewed as the ‘holy grail’ of clustering. But unfortunately, when something is too good to be true, it often is. Before the Tungsten cluster solution Continuent built two synchronous replication cluster solutions (m/cluster, uni/cluster), but we abandoned those for good reasons.

What is the difference between MySQL replication and MySQL clustering? While clustering involves a layer of replication, the capabilities, benefits, and reasons for using clustering versus replication are very different. At Continuent, we offer both clustering and replication for your MySQL, MariaDB, and Percona MySQL - in the cloud, on-prem, hybrid-cloud and multi-cloud, with no application changes or downtime necessary.

Disaster Recovery for Continuous MySQL Operations does not have to be hard, but it does have to be WAN: Multi-Site, Hybrid-Cloud, Multi-Cloud. This blog discusses Business Continuity, Disaster Recovery, or “DR,” and an overlooked clustering feature that makes continuous database operations easy, affordable, and manageable.

Do-it-Yourself (DIY), database migration; what other approaches are there to challenges of MySQL availability, reliability, scalability and application performance?

Continuent Tungsten enables greater application availability and performance especially across WAN, it saves tons of manual labor and headache, it’s backed by premium 24/7/365 support, and it enables all sorts of new freedom and possibilities for data infrastructure including multi-cloud, hybrid-cloud, and advanced, real-time analytics.

People approach Continuent for many reasons, including: MySQL Continuous Operations: their business is using MySQL for business-critical applications that require zero downtime, including for maintenance updates MySQL Performance: their application performance and user experience are suffering due to a faltering MySQL backend