Saturday, May 18, 2024

MySQL HA Solutions

This presentation discusses high-availability techniques, sharding fundamentals, third-party technologies, and how to decrease the likelihood of system outages. It covers the following topics:

  • Hardware specifications to consider
  • Functionally sharding your data
  • Why to use various topologies such as a relay slave, master-master replication, or circular replication for high availability
  • Failover mechanisms you should consider with replication, such as keepalived and heartbeat
  • How to safely and reliably replicate over a WAN for disaster recovery
  • Mixing up storage engines (leveraging the Blackhole engine, for instance)
  • Third-party options for sharding your data

Presenter: Chris Schneider