Documentation
Rate This Document
Findability
Accuracy
Completeness
Readability
SubmitClose

Enabling Primary-Secondary Replication for the Secondary Databases

  1. On the primary database, query the current binlog file name and position.

    Full backup:

    cat /data/xbackup/full/xtrabackup_binlog_info

    Incremental backup (Query the last incremental backup):

    cat /data/xbackup/inc2/xtrabackup_binlog_info
  2. Query the configurations (including the deployment mode, replication mode, and whether parallel replication is enabled) of the secondary database in the current primary-secondary replication.
  3. Ensure that the configurations (including the deployment mode, replication mode, and whether parallel replication is enabled) of the added secondary database are consistent with those of the secondary database in the current primary-secondary replication.
  4. Stop the client application, that is, stop the client's operations on the primary database.
  5. After replication is complete on all secondary databases (for details, see 2), verify data consistency between the primary and secondary databases (for details, see Running the Tool).