3.1.1 How Do I Provision a Slave? Objectives Example Execution Discussion Permissions Required Tips and Tricks

When working with replication, one of the common tasks is adding a new slave for scale out. Although adding a new slave has been simplified with utilities like mysqlreplicate, provisioning the slave (copying data and getting replication started properly) can be a challenge if done manually.

Fortunately, we have two utilities - mysqldbexport and mysqldbimport - that have been designed to work with replication so that when the export is generated, you can include the proper replication control statements in the output stream.