Supporting MySQL replication
In the Preparing for replication section, we saw an overview of MySQL replication. In this section, we cover the following topics:
How we can use phpMyAdmin to configure replication
How to prepare a test environment containing one master server and two slave servers
How to send commands to control the servers
How to obtain information on replication for servers, databases, and tables
phpMyAdmin's interface offers a Replication page; however, other pages contain either information about replication or links to control replication actions. We will point to each appropriate location when covering the related subject.
How to use this section depends on how many servers we have at our disposal. If we have at least two servers and want to configure them via phpMyAdmin in a master/slave relationship, we can follow the Configuring replication section. If instead we only have one server to play with, then we should take advice from the Setting up a test environment section...
