Setting Up a MySQL Replication Server

From AgileApps Support Wiki
Revision as of 22:31, 16 April 2014 by imported>Aeric

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:

Thumbsup.gif

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: