Easy MySQL Replication Setup and Troubleshooting

Replication and High Availability Strategies
4 April 11:00AM - 11:50AM @ Ballroom G

Experience level: 
50 minutes conference
Do you need to set up replication for MySQL? Afraid that it'll take hours or it's just not worth the trouble? Got it going but seeing weird errors? This presentation plainly describes MySQL replication in just enough depth then shows you how to get it running. Typical replication failures and fixes are discussed also. Replication can seem complicated if you haven't set it up before. This presentation aims to describe how to use and fix replication as plainly as possible, focusing on current MySQL versions. Once one knows the basic mechanism of MySQL replication, it's much easier to set up and to troubleshoot. Aimed at MySQL users who are familiar with the database but new to replication, this presentation begins by describing how data flows from master to replication slave. Config settings and relevant commands are covered, then a walk-through of setting up replication is done. After slightly more advanced replication topics are covered, typical failures and their fixes are described. Prerequisites: Passing familiarity with Linux/Unix shell. Minimal knowledge of MySQL. Slides at: http://www.slideshare.net/BobBurgess2/easy-mysql-replication-setup-and-troubleshooting


Database Operations Engineer, Shopify
Bob has been squeezing every drop out of MySQL for several years, having previously spent several years roaming in the Garden of Oracle. In late 2007, he found himself suddenly (and without warning) responsible for storing and retrieving all the information amassed at Radian6, the original leading social media monitoring company. Now, as an operations engineer for Shopify, the database challenges are bigger than ever.