Zero-Downtime Deployments with MySQL

I've been talking a lot about zero-downtime deployments with MySQL as your database backend (including schema changes/migrations!) recently.

I gave a 45 minute presentation called Zero Downtime Deployments with Database Migrations, from a DevOps conference that Vladimir Vuksan and I organized back in November 2012.

Additionally, I contributed a post on the same subject, titled Zero-Downtime MySQL Schema Changes, to this year's SysAdvent.

Feel free to drop me an email if you need help with implementing zero-downtime deployments or schema changes in your own applications.

Finally, here are a few more useful resources:

  1. Etsy: Deployments using Master-Master MySQL
  2. High Performance MySQL, "Replication" (Ch. 10 in 3rd edition, Ch. 8 in 2nd edition)
  3. MySQL Load Balancing with HAProxy

Leave a Reply

Your email address will not be published. Required fields are marked *