论坛徽章:: 1

电梯直达

1楼 [收藏(0)] [报告]

发表于 2015-08-10 10:47 |只看该作者 |倒序浏览

本帖最后由 hover_sky 于 2015-08-10 11:49 编辑

2015-08-10 09:50:40 31502 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2015-08-10 09:50:40 31502 [Warning] Slave I/O: Notifying master by SET @master_binlog_checksum= @@global.binlog_checksum failed with error: Unknown system variable 'binlog_checksum', Error_code: 1193
2015-08-10 09:50:40 31502 [Warning] Slave I/O: Unknown system variable 'SERVER_UUID' on master. A probable cause is that the variable is not supported on the master (version: 5.5.27-log), even though it is on the slave (version: 5.6.24-72.2-log), Error_code: 1193

我用5.6做5.5的从，提示如上？同步一直不动，下面的几个数字都不变。（主数据库的数据是一直有变化的）
            Master_Log_File: mysql-bin.003142
      Read_Master_Log_Pos: 538857114
            Relay_Log_File: mysql-relay-bin.000047
            Relay_Log_Pos: 165139384
      Relay_Master_Log_File: mysql-bin.003142
         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: 538857047
            Relay_Log_Space: 349746820

只要重启，这个behind就是真实的落后的数字。跑不到一分钟，之后就变为0，不动了

如题，谢谢