我配置了mysql主从replication不复制是何原因

我配置了mysql主从replication,Slave_IO_Running: Yes Slave_SQL_Running: Yes 都是yes,但就是不复制!在网上查了许多并逐一测试,都没有结果,只有请教前辈了。先贴两信息需要什么我再提供。我是个新手使用咱们的平台不熟,贴的不对请指教。
主master IP:218.195.26.195

root@localhost [mysql]> show master status;
File Position Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set
mysql-bin.000017 194 student,jxbggl,yjsmis,xgmis,wenku,student,jxbggl,yjsmis,xgmis,wenku mysql,performance_schema,sys,mysql,performance_schema,sys 664f7dab-7007-11e7-ba01-000c295759e5:1-614

1 row in set (0.01 sec)
从slave IP:59.74.71.51
root@localhost [mysql]> show slave statusG
1. row **

           Slave_IO_State: Waiting for master to send event
              Master_Host: 218.195.26.195
              Master_User: czj
              Master_Port: 3306
            Connect_Retry: 60
          Master_Log_File: mysql-bin.000017
      Read_Master_Log_Pos: 194
           Relay_Log_File: st66-relay-bin.000015
            Relay_Log_Pos: 320
    Relay_Master_Log_File: mysql-bin.000017
         Slave_IO_Running: Yes
        Slave_SQL_Running: Yes
          Replicate_Do_DB: 
      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: 194
          Relay_Log_Space: 739
          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: 55
              Master_UUID: 664f7dab-7007-11e7-ba01-000c295759e5
         Master_Info_File: mysql.slave_master_info
                SQL_Delay: 0
      SQL_Remaining_Delay: NULL
  Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
       Master_Retry_Count: 86400
              Master_Bind: 
  Last_IO_Error_Timestamp: 
 Last_SQL_Error_Timestamp: 
           Master_SSL_Crl: 
       Master_SSL_Crlpath: 
       Retrieved_Gtid_Set: 
        Executed_Gtid_Set: 664f7dab-7007-11e7-ba01-000c295759e5:1-127:132-614,

664f7dab-7007-11e7-ba01-000c295759e6:1

            Auto_Position: 0
     Replicate_Rewrite_DB: 
             Channel_Name: 
       Master_TLS_Version: 

1 row in set (0.00 sec)

root@localhost [mysql]>

阅读 2.1k
撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
推荐问题