How to manage replication failover processes for MySQL, MariaDB, and PostgreSQL

Failover is the process of moving to a healthy standby component, during a failure or maintenance event, in order to preserve uptime. The quicker it can be done, the faster you can be back online. However, failover can be tricky for transactional database systems as we strive to preserve data integrity – especially in asynchronous or semi-synchronous topologies. There are risks associated, from diverging datasets to loss of data. Failing over due to incorrect reasoning, e.g., failed heartbeats in the case of network partitioning, can also cause significant harm.

This webinar replay gives a detailed overview of what failover processes may look like in MySQL, MariaDB and PostgreSQL replication setups. We’ve covered the dangers related to the failover process, and discuss the tradeoffs between failover speed and data integrity. We’ve found out about how to shield applications from database failures with the help of proxies. And we’ve finally had a look at how ClusterControl manages the failover process, and how it can be configured for both assisted and automated failover.

So if you’re looking at minimizing downtime and meet your SLAs through an automated or semi-automated approach, then this webinar replay is for you!

Content of the webinar

• An introduction to failover – what, when, how
  • in MySQL / MariaDB
  • in PostgreSQL
  • To automate or not to automate
• Understanding the failover process
• Orchestrating failover across the whole HA stack
• Difficult problems
  • Network partitioning
  • Missed heartbeats
  • Split brain
  • From assisted to fully automated failover with ClusterControl
    • Demo