Documentation
Rate This Document
Findability
Accuracy
Completeness
Readability
SubmitClose

Process Description

  1. Ensure that MySQL primary-secondary replication has been deployed and that services are running properly. For example, the client uses Sysbench to perform pressure tests on the primary database. For details, see Sysbench 0.5 & 1.0 Test Guide.
  2. Use the XtraBackup tool to back up the data of the primary database (full backup or incremental backup).
  3. Restore the backup data of the primary database to the secondary database to be added (full restoration or incremental restoration).
  4. View the binlog position in the xtrabackup_binlog_info backup file of the primary database.
  5. 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.
  6. 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.