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 ...

Get Mastering phpMyAdmin 3.4 for Effective MySQL Management now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.