View Source

To check whether a MySQL dual-master database system is synchronised, follow the instruction below:

In a dual-master system, there are 2 servers, the primary and the secondary server.

1. On the primary server, run command prompt with Administrator's privilege, change to "C:\Program Files\Deepnet DualShield\mysql\bin"

DualShield MFA Platform > How to check the status of a MySQL Dual-Master Replication system [L] > Picture4.png

2. Enter the command below to login into MySQL console. You need your MySQL account which was set up while DualShield was initially installed.

DualShield MFA Platform > How to check the status of a MySQL Dual-Master Replication system [L] > Picture3.png

3. Enter the command SHOW MASTER STATUS;

DualShield MFA Platform > How to check the status of a MySQL Dual-Master Replication system [L] > Picture5.png

4. Enter the command SHOW SLAVE STATUS\G

DualShield MFA Platform > How to check the status of a MySQL Dual-Master Replication system [L] > Picture6.png

Repeat Step 1-4 on the secondary server:

DualShield MFA Platform > How to check the status of a MySQL Dual-Master Replication system [L] > Picture4.png

DualShield MFA Platform > How to check the status of a MySQL Dual-Master Replication system [L] > Picture3.png

DualShield MFA Platform > How to check the status of a MySQL Dual-Master Replication system [L] > Picture7.png

DualShield MFA Platform > How to check the status of a MySQL Dual-Master Replication system [L] > Picture8.png

Now, cross check the results. Match "Exec_Master_Log_Pos" on the primary server against the "log-bin" file "position" on the secondary server, and vise versa.

DualShield MFA Platform > How to check the status of a MySQL Dual-Master Replication system [L] > image2016-8-12 22:15:40.png

If they all match and both "Slave_IO_Running" and "Slave_SQL_Running" status are "Yes", then the dual-master database system is in sync.