MySQL复制中因服务器ID重复报错（Last

[mysql@localhost107 ~]$ mysql -uroot -p -P3306 mysql>change master to master_host = '192.168.0.102',master_user = 'repl',master_password ='123456',              master_log_file ='mysql_bin.000009', master_log_pos=342; Query OK, 0 rows affected, 2 warnings (0.35 sec) mysql> start slave; Query OK, 0 rows affected (0.04 sec) mysql> show slave status\G *************************** 1. row ***************************                Slave_IO_State:                    Master_Host: 192.168.0.102                   Master_User: repl                   Master_Port: 3306                 Connect_Retry: 60               Master_Log_File: mysql_bin.000009           Read_Master_Log_Pos: 342                Relay_Log_File: localhost107-relay-bin.000001                 Relay_Log_Pos: 4         Relay_Master_Log_File: mysql_bin.000009              Slave_IO_Running: No             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: 342               Relay_Log_Space: 154               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: NULL Master_SSL_Verify_Server_Cert: No                 Last_IO_Errno: 1593                 Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it).                Last_SQL_Errno: 0                Last_SQL_Error:    Replicate_Ignore_Server_Ids:               Master_Server_Id: 10                   Master_UUID:               Master_Info_File: /opt/mysql/data/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: 170805 06:47:19 报错：服务器ID和复制集群其他的机器重复了。 解决办法：先停机，然后修改server-id，一定不要和其他机器的重复。然后启动服务。 [mysql@localhost107 ~]$ /usr/local/mysql/bin/mysqladmin  -uroot -p -P3306 shutdown [mysql@localhost107 ~]$ vi /etc/my.cnf server_id=6 保存，退出！ [mysql@localhost107 ~]$ /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf  --user=mysql & [mysql@localhost107 ~]$ mysql -uroot -p -P3306 mysql> show slave status\G ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:    5 Current database: *** NONE *** *************************** 1. row ***************************                Slave_IO_State: Waiting for master to send event                   Master_Host: 192.168.0.102                   Master_User: repl                   Master_Port: 3306                 Connect_Retry: 60               Master_Log_File: mysql_bin.000010           Read_Master_Log_Pos: 154                Relay_Log_File: localhost107-relay-bin.000005                 Relay_Log_Pos: 367         Relay_Master_Log_File: mysql_bin.000010              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: 154               Relay_Log_Space: 628               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: 10                   Master_UUID: f78533a4-7751-11e7-9a27-000c29b31319              Master_Info_File: /opt/mysql/data/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:                  Auto_Position: 0          Replicate_Rewrite_DB:                   Channel_Name:             Master_TLS_Version:  1 row in set (0.00 sec) 改机器已经添加到复制集群了。