Best practices for MySQL high availability
The MySQL world is full of trade-offs and choosing a High Availability (HA) solution is no exception. This session aims to look at all of the alternatives in an unbiased nature. Preference is of course only given to open source solutions. While the landscape will be covered, including but not limited to MySQL replication, MHA, DRBD, Tungsten Replicator, Galera Cluster, NDB Cluster, etc. the focus of the talk will be what is recommended for today, and what to look out for. Thus, this will include extensive deep-dive coverage of ProxySQ (with comparisons to MariaDB MaxScale and MySQL Router)L, semi-sync replication, Orchestrator, MySQL Router, and Galera Cluster variants like Percona XtraDB Cluster and MariaDB Galera Cluster. Due to the focused nature, there will be some aspects of practicality to it, because there’s no better way to grasp concepts than trying it out yourself.