
平臺論壇博客文庫

› 論壇 › 數(shù)據(jù)庫技術(shù) › MySQL › mysql主從從庫無異常單數(shù)據(jù)不能同步

mysql主從從庫無異常單數(shù)據(jù)不能同步 [復制鏈接]

microsoft_fly

白手起家

論壇徽章:: 2

數(shù)據(jù)庫技術(shù)版塊每日發(fā)帖之星
日期:2015-12-05 06:20:00

電梯直達

1樓 [收藏(0)] [報告]

發(fā)表于 2015-04-25 21:07 |只看該作者 |倒序瀏覽

本帖最后由 microsoft_fly 于 2015-04-25 21:08 編輯

備庫：
mysql> show slave status\G
*************************** 1. row ***************************
            Slave_IO_State: Waiting for master to send event
               Master_Host: 192.168.2.158
               Master_User: rep
               Master_Port: 3306
            Connect_Retry: 60
            Master_Log_File: mysql-bin.000035
      Read_Master_Log_Pos: 24534
            Relay_Log_File: slave-relay-bin.000006
            Relay_Log_Pos: 24680
      Relay_Master_Log_File: mysql-bin.000035
         Slave_IO_Running: Yes
         Slave_SQL_Running: Yes
            Replicate_Do_DB: db1,db2
      Replicate_Ignore_DB:
         Replicate_Do_Table:
   Replicate_Ignore_Table:
   Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
               Last_Errno: 0
               Last_Error:
               Skip_Counter: 0
      Exec_Master_Log_Pos: 24534
            Relay_Log_Space: 24982
            Until_Condition: None
            Until_Log_File:
            Until_Log_Pos: 0
         Master_SSL_Allowed: No
         Master_SSL_CA_File:
         Master_SSL_CA_Path:
            Master_SSL_Cert:
         Master_SSL_Cipher:
            Master_SSL_Key:
      Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
            Last_IO_Errno: 0
            Last_IO_Error:
            Last_SQL_Errno: 0
            Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
         Master_Server_Id: 1
1 row in set (0.00 sec)

mysql