A couple of months ago I started looking at how I could better manage the MySQL databases between the main PID server and our backup server. I found that MySQL has a nice builtin replication feature that allows real-time update to multiple backup servers without the need to do very much wrangling.

MySQL Replication Documentation:
http://dev.mysql.com/doc/refman/4.1/en/replication-howto.html

One thing to note when setting up replication is that you must have the master and the slave on the same version. Other than that, if you follow the steps in the how-to you’ll be golden.