Obtaining the Replication Master Binary Log Coordinates-opracowanie

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, follow these steps:
1. Start a session on the master by connecting to it with the command-line client, and flush all tables
and block write statements by executing the FLUSH TABLES WITH READ LOCK statement:
mysql FLUSH TABLES WITH READ LOCK;
For InnoDB tables, note that FLUSH TABLES WITH READ LOCK also blocks COMMIT operations.
... zobacz całą notatkę