Setting Up a MySQL Replication Server

It's a good idea to set up a replication server, for the sake of data safety. That server is also known as a slave server. (The primary database server is also known as the master server.)

A full description of the process is outside the scope of this manual, but here is some information to get you started:

• The Percona backup system makes it relatively painless, and it's fast.
  http://www.percona.com/doc/percona-xtrabackup/2.1/howtos/setting_up_replication.html

• For additional information on replication in general, see the MySQL manual:
  http://dev.mysql.com/doc/refman/5.5/en/replication.html

Best Practice: When you set up MySQL replication, it's a good idea to configure the Quartz scheduler, as well. That process gives you useful timestamps that help you determine if the slave server is lagging behind the master, and by how much. Learn more: Monitoring MySQL Replication#Reviewing the Messages Configuring the Quartz Scheduler