How to track replication errors on a slave server?

Discussion in 'MySQL' started by Multiplexor, Jan 31, 2011.

0
  1. #1
    Hello,

    I have configured one server as slave (server-id = 2). Now it receives SQL commands from master-server and executes them, which works fine.

    Let's alter the name of the table "test" to "test1". Now, the command INSERT INTO test ... works fine on the master but does not on the slave. However, I do not see any errors on the slave and no new entries in mysql_error.log and mysql.log on the slave. The "INSERT INTO test ..." command appears in the mysql-relay-bin.0000xy on slave.

    The question is this: how to recognize errors/inconsistencies on slave?
     
    Multiplexor, Jan 31, 2011 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    You can check the status of replication on a slave by typing the following command on MySQL prompt.
    SHOW SLAVE STATUS;
    Code (markup):
     
    mwasif, Jan 31, 2011 IP