One way to create a snapshot of the data in an existing master 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 slave 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 slave 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
STATUS, and use this to issue the appropriate
CHANGE MASTER TO statement when
starting the slave.
When choosing databases to include in the dump, remember that you need to filter out databases on each slave that you do not want to include in the replication process.
To import the data, either copy the dump file to the slave, or access the file from the master when connecting remotely to the slave.
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices