Mike is a Technical Account Manager with Percona and specializes in performance tuning and architecture/application design leveraging open source systems. His background is in the web development space, but he has several years of experience as a MySQL DBA and consultant as well. Mike founded the Oklahoma City Open Source Database User Group (h?ttp://okc-osdb.org) ?and loves to expose people to the power of Open Source software. He lives with his family in Oklahoma City. When not working, he enjoys spending time in the outdoors, archery, watching sports, and spending time with the family.
Designing highly available database systems isn't a new topic. On the contrary, with so many options available to architects now, choosing the best fit isn't always trivial. This talk will walk through various options including Standard Multi A/Z MySQL RDS, Aurora for RDS, and Percona XtraDB Cluster in EC2. Comparison points will cover failover processes, accompanying software (primarily ProxySQL), and general use cases.
This is not meant to be a deep dive into any particular design, but rather assist in choosing the proper architecture for a given use case.