Hitchhiker’s Guide to MySQL Replication
This is the third in a series of five abstracts submitted to the O’Reilly MySQL Conference in April 2008.
MySQL has a great facility for creating a read-only failover database. We’ll show you how to setup, start, failover, and monitor it.
Setting up MySQL to have a master + slave failover capability might be intimidating, but it needn’t be.
1. Intro
2. Anatomy of MySQL Replication
3. Initial Master copy
4. Setup + starting the slave
5. Failover from Master
6. Adding another slave
7. Monitoring your slave db
8. Conclusions
