3.1.1 How Do I Provision a Slave?

3.1.1.1 Objectives
3.1.1.2 Example Execution
3.1.1.3 Discussion
3.1.1.4 Permissions Required
3.1.1.5 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.