MySQL 8 Administrator???s Guide

Adding slaves to replication

It is possible to add a new slave database server to an existing replication configuration. This doesn't require the master database server to be stopped. The approach should be to make a copy of an existing slave database server. Once copied, we have to modify the value for a server-id configuration option.

The following instructions set up a new slave database to an existing replication configuration. First, an existing slave database server should be shut down as follows:

mysql> mysqladmin shutdown

Now, a data directory from the existing slave should be copied to the new slave database server. Along with the data directory, binary logs and relay log files must be copied as well. It is recommended to use the ...