12 blog posts in 13 categories
Hybrid replication, i.e. combining Galera and asynchronous MySQL replication in the same setup, became much easier since GTID got introduced in MySQL 5.6. In this blog post, we will show you how to replicate a Galera Cluster to a MySQL server with GTID, and how to failover the replication in case the master node fails.
This blog post covers deployment of replication cluster using ClusterControl. It also discusses in-depth a concept of errant transactions, how to detect them and how to fix issues related to them.
Learn more about MySQL slave promotion in GTID and non-GTID-based MySQL Replication setups.
This post is an addendum on the MariaDB Replication Manager covering the new improved features
This post describes how you can implement automated failover with MariaDB using Maxscale and MHA and compares the two with each other.
This post describes how you can implement automated failover with MariaDB using Maxscale and MariaDB Replication Manager.
This post describes how you can implement automated failover with MariaDB MHA.
Thanks to everyone who joined us for our recent live webinar on ‘Replication Topology Changes for MySQL and MariaDB’ led by Krzysztof Książek, Senior Support Engineer at Severalnines. The replay and slides to the webinar are now available to watch and read online.
There are many many approaches to MySQL high availability - from traditional, loosely-coupled database setups based on asynchronous replication to more modern, tightly-coupled architectures based on synchronous replication. These offer varying degrees of protection, and DBAs almost always have to choose a trade-off between high-availability and cost. In this webinar, we will look at some of the most widely used HA alternatives in the MySQL world and discuss their pros and cons.
This is the fifth installment in the ‘Become a MySQL DBA’ blog series, and discusses one of the most common operations a DBA has to handle - replication topology changes and planned failover. Our previous posts in the DBA series include Schema Changes, High Availability, Backup & Restore, Monitoring & Trending.