Additional languages
MySQL 5.1 Reference Manual :: 6 Replication :: 6.1 Replication Configuration :: 6.1.1 How to Set Up Replication :: 6.1.1.9 Introducing Additional Slaves to an Existing Replication Environment
« 6.1.1.8 Setting up replication with existing data
6.1.1.10 Setting the Master Configuration on the Slave »
Section Navigation      [Toggle]

6.1.1.9. Introducing Additional Slaves to an Existing Replication Environment

If you want to add another slave to the existing replication configuration then you can do so without stopping the master. Instead, you duplicate the settings on the slaves.

To duplicate the slave:

  1. Shutdown the existing slave (slavea): 

    shell> mysqladmin shutdown

  2. Copy the data directory from the existing slave to the new slave. You can do this by creating an archive using tar or WinZip, or by performing a direct copy using a tool such as cp or rsync. Ensure you also copy the log files and relay log files.

  3. Copy the master.info and relay.info files from the existing slave to the new slave. These files hold the current log positions.

  4. Start the existing slave.

  5. On the new slave, edit the configuration and the give the new slave a new unique server-id.

  6. Start the new slave; the master.info file options will be used to start the replication process.