Configuring a replication slave, migrating data with a simple SQL dump
In this recipe, we will show how to configure a replication slave while coping with a master that both has data on it and potentially has that data changing, while minimizing the time for which the master must be "locked" from updates.
In the common case of adding a slave to a master that already has data in it, the simplest technique is to use the mysqldump binary provided by MySQL to inject the data from master to slave, and to reset the slave at the same time.
For this one-line command on the master to work, the following requirements must be met:
- Any existing slave process must be stopped on the slave (
STOP SLAVE) - A user account must exist that is able to create databases and ...
Get High Availability MySQL Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
