Friday, June 27, 2014

Migrating To XtraDB Cluster In EC2 At PagerDuty

A little over six months ago, PagerDuty switched its production MySQL database to XtraDB Cluster running inside EC2. Here's the story of why and how we made the change.

How The Database Looked Before

PagerDuty's MySQL database was a fairly typical deployment. We had:

  • A pair of Percona Servers writing data to a DRBD-backed volume. 
  • EBS disks for both the primary and secondary servers backing the DRBD volume. 
  • Two synchronous copies of the production database. (In the event of a failure of the primary, we wanted to be able to quickly switch to the secondary server without losing any data.) 
  • A number of asynchronous replication slaves for disaster recovery, backups and accidental modification recovery.
Read more here

Leave a Reply

All Tech News IN © 2011 & Main Blogger .