Pitfall! Replication Hazards: Choosing the right replication strategy for your applications
May 30, 2019
Percona Live Open Source Database Conference 2019
Andrew Garner, Marco Nicosia
Planning to run MySQL, and want to safeguard data via replication? There are two main choices - traditional MySQL replication or Galera clusters. Which should you choose? We can help.
- Come see recorded demos of breaking replication. We'll demonstrate and compare the different ways MySQL's replication technologies can be thwarted, threatened and thrashed. A taste of what you'll see: A single writer stopping all transactions on a Galera cluster. Rendering a slave useless by neglecting primary keys or abusing metadata locks. Creating inconsistent schemas on a Galera cluster, and more!
- Attend this presentation if you need to understand the pitfalls of each replication strategy, and want to best match MySQL's features to your Application developers' needs.
Our demos use PXC-release, a Cloud Foundry project. CF is an OSS Platform as a Service. Our project gives Operators a reliable, automated way to spin up single node, master-slave, and Galera deployments of Percona Server. We'll share what we've learned: what's working, and what we'd do differently next time.
About the Authors
Andrew Garner
Andrew is a software engineer for Cloud Foundry at Pivotal Software working on MySQL. Before Pivotal, Andrew worked as a systems administrator, database consultant and dev-ops engineer with a focus on open-source databases at Rackspace. He has provided support for deploying, optimizing and troubleshooting open-source databases and applications for a variety of environments from start-ups to large-scale enterprises.