89425

Obtaining the Replication Master Binary Log Coordinates

To configure replication on the slave you must determine the master's current coordinates within its

binary log. You will need this information so that when the slave starts the replication process, it is able

to start Processing events from the binary log at the correct point.

If you have existing data on your master that you want to synchronize on your slaves before starting

the replication process, you must stop processing statements on the master, and then obtain its

current binary log coordinates and dump its data, before permitting the master to continue executing

statements. If you do not stop the execution of statements, the data dump and the master status

information that you use will not match and you will end up with inconsistent or corrupted databases on the slaves.

To obtain the master binary log coordinates, followthese steps:

1. Start a session on the master by connecting to it with the command-line Client, and flush all tables

and błock write statements by executing the FLUSH TABLES WITH READ LOCK statement:

mysql>FLUSH TABLES WITH READ LOCK;

For InnoDB tables, notę that FLUSH TABLES WITH READ LOCK also blocks COMMIT operations.