Run a diagnostic - ACS - Reference Guides

ACS Installation and Administration Guide

Product
ACS
AFS_Version
7.11
Category
Reference Guides
language
English
audience
public

To determine if replication is broken, check that the Master and Slave servers are synchronized:

Check binary log index values between Master and Slave using MySQL console:

On Server 1, run the following commands

As root user

mysql>SHOW master status;

The following lines are displayed:

+------------------+------------------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+------------------+--------------+------------------+
| $FILENAME | $POSITION | | |
+------------------+------------------+--------------+------------------+

Retrieve $FILENAME and $POSITION.

On Server 2, run the following command:

As root user

mysql>SHOW slave status;

The following lines are displayed:

| Slave_IO_State | Master_Host | Master_User | Master_Port | Connect_Retry | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_Do_DB | Replicate_Ignore_DB | Replicate_Do_Table | Replicate_Ignore_Table | Replicate_Wild_Do_Table | Replicate_Wild_Ignore_Table | Last_Errno | Last_Error | Skip_Counter | Exec_Master_Log_Pos | Relay_Log_Space | Until_Condition | Until_Log_File | Until_Log_Pos | Master_SSL_Allowed | Master_SSL_CA_File | Master_SSL_CA_Path | Master_SSL_Cert | Master_SSL_Cipher | Master_SSL_Key | Seconds_Behind_Master |
+----------------------------------+-------------+-------------+-------------+---------------+-------------------+---------------------+-------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+----------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+
| Waiting for master to send event | lnk4c-cks01 | antirepl | 3306 | 60 | $FILENAME | $POSITION | mysqld-relay-bin.000002 | 44069 | mysqld-bin.000141 | Yes | Yes | | | | | | | 0 | | 0 | 368484 | 44069 | None | | 0 | No | | | | | | 0 |

Retrieve $FILENAME and $POSITION.

The servers are not synchronized if:

  • $FILENAME values are different for both servers or
  • $POSITION values are different for both servers.