Jeremy D. Zawodny, Yahoo! Inc.
Date: Friday, July 26
Time: 10:45am - 12:15pm
Location: Grande Ballroom B
Replication provides a great mechanism for scaling MySQL beyond a single machine and even across vast distances. It can also be used to provide a "hot spare" server which can be used in the event that the primary server fails.
In this session, we'll briefly look at how replication work and how to configure it. How is replication in MySQL 4.0 different than in the previous releases?
We'll also cover common problems and solutions. Why does replication fail? How can you monitor and detect when replication fails? What's the best way to add one more new slaves to an existing replication setup?
Finally, we'll discuss hardware and software solutions that can be combined with replication to provide load-balancing and high-availability.
Download presentation file