Link Details

MySQL replication is fairly easy to set up, but in the real world many obstacles can get in the way of keeping it up and running smoothly. One problem that seems to bog down a lot of DBAs is the slaves getting out of sync with the master. If you're lucky you would be alerted with an error in your slave log file, and can then track down that problem. But sometimes it drifts out of sync silently.