Difference between revisions of "Setting Up a MySQL Replication Server"

From LongJump Support Wiki
imported>Aeric
imported>Aeric
 
(One intermediate revision by the same user not shown)
Line 7: Line 7:


:* For additional information on replication in general, see the MySQL manual:<br>http://dev.mysql.com/doc/refman/{{MySqlVersion}}/en/replication.html
:* For additional information on replication in general, see the MySQL manual:<br>http://dev.mysql.com/doc/refman/{{MySqlVersion}}/en/replication.html
{{Best|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 let you determine if the slave server is lagging behind the master, and by how much.<br>''Learn more:'' [[Configuring the Quartz Scheduler]]}}
<noinclude>
<noinclude>


[[Category:Installation]]
[[Category:Installation]]
</noinclude>
</noinclude>

Latest revision as of 22:39, 16 April 2014

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: