Synchronizing Data and Supporting Replication - Mastering phpMyAdmin 3.4 for Effective MySQL Management - page 231

Now we click on the green D icon and see another line of proposed changes show
up, as shown in the following screenshot:
A row in the author table needs to be inserted because there is one less author in the
target database. Altogether four rows need to be updated, because we removed the
phone column in the same table.
We can now click on Apply Selected Changes button. The Would you like to
delete... checkbox does not apply to this operation.
We now see that the upper part of the screen proposes fewer changes to make:
We can go on by selecting structure or data changes and then applying them in the
order we deem appropriate.
This concludes the section describing the synchronization feature. We continue with
coverage of replication support.
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 conigure 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