Tech Thought

Recently we’ve been having some problems with our production server. Every now and then it just reboots - for no aparent reason. We’re still looking into the reason this occurs (looks like an overheating CPU) however when the reboot occurs, it causes our Mysql replication slaves to get out-of-sync with the master.

The following is a simple guide to help you setup Mysql replication - a fantastic way to ensure you have an up-to-date backup of your production databases.
This guide only describes a single master-slave relationship, however you can use mysql in various modes which include additional slaves as required.