One way to create a snapshot of the data in an existing source database is to use the mysqldump tool to create a dump of all the databases you want to replicate. Once the data dump has been completed, you then import this data into the replica before starting the replication process.
The example shown here dumps all databases to a file named
dbdump.db, and includes the
--master-data option which
automatically appends the
TO statement required on the replica to start the
$> mysqldump --all-databases --master-data > dbdump.db
If you do not use
--master-data, then it is
necessary to lock all tables in a separate session manually
FLUSH TABLES WITH READ
LOCK) prior to running mysqldump,
then exiting or running UNLOCK TABLES from the second session to
release the locks. You must also obtain binary log position
information matching the snapshot, using
SHOW MASTER STATUS, and use this
to issue the appropriate
TO statement when starting the replica.
When choosing databases to include in the dump, remember that you need to filter out databases on each replica that you do not want to include in the replication process.
To import the data, either copy the dump file to the replica, or access the file from the source when connecting remotely to the replica.