Process Description
- Ensure that the MySQL primary-secondary replication has been deployed and services are running properly. For example, use the Sysbench tool to perform stress tests on the primary database. For details, see the Sysbench 0.5 & 1.0 Test Guide.
- Use the XtraBackup tool to back up the data of the primary database (full backup or incremental backup).
- Restore the backup data of the primary database to the secondary database to be added (full restoration or incremental restoration).
- View the binlog position in the xtrabackup_binlog_info backup file of the primary database.
- Enable primary-secondary replication for the secondary database. The new secondary database will continue to synchronize data at the specified position in the binlog of the primary database.
- Stop client applications, that is, stop operations on the primary database. After replication is complete on all secondary databases, verify the data consistency between the primary and secondary databases.
Parent topic: Adding a Secondary Database