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.