Nov 05, 2018
 Percona Live Open Source Database Conference Europe 2018
  Alex Poritskiy, Alexander Rubin

Best practices for MySQL High Availability

Everyone wants to have a highly available (HA) database. But which solution do you choose and what should you consider?
In this training session, we will look into a wide set of existing and new HA solutions, including
1. MySQL replication based HA solutions (MHA, Orchestrator) and routing options (ProxySQL, HA Proxy)
2. Clustering solutions (Percona XtraDB Cluster, MySQL NDB Cluster)
3. Cloud-based solutions (AWS RDS/Aurora, Google Cloud SQL)
4. Container-based solutions (Kubernetes/Openshift)

We will discuss the advantages and disadvantages of each solution and show some basic demos.



About the Authors

Alex Poritskiy

Alex is working at Percona as Architect. He has been working with MySQL since 2003 as DBA , Consultant, Architect and Software Engineer. Before joining Percona he was performing MySQL consulting services for over 7 years in various companies. He helped many customers to design and implement, scalable and highly available MySQL based systems as well as performance optimizations.
 

Alexander Rubin

Alexander joined Percona in 2013. Alexander worked with MySQL since 2000 as DBA and Application Developer. Before joining Percona he was doing MySQL consulting as a principal consultant for over 7 years (started with MySQL AB in 2006, then Sun Microsystems and then Oracle). He helped many customers design large, scalable and highly available MySQL systems and optimize MySQL performance. Alexander also helped customers design Big Data stores with Apache Hadoop and related technologies.