MySQL主从同步出现的问题(1)

               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
                  Master_UUID:
             Master_Info_File: /home/mysql/data/master.info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
           Master_Retry_Count: 86400
                  Master_Bind:
      Last_IO_Error_Timestamp: 160428 21:24:27
     Last_SQL_Error_Timestamp:
               Master_SSL_Crl:
           Master_SSL_Crlpath:
           Retrieved_Gtid_Set:
            Executed_Gtid_Set:
                Auto_Position: 0
1 row in set (0.00 sec)

MySQL服务器的server-id重复了，修改my.cnf即可。

本文出自 “逢场做戏。” 博客，请务必保留此出处http://xiaofengmo.blog.51cto.com/10116365/1768783

MySQL主从同步出现的问题(1)

标签：linux mysql server-id my.cnf