当前位置：首页 > 运维知识 > 数据库 >内容正文

数据库

mysql 主主忽略错误_MySQL 主主报错： Fatal error: The slave I/O thread stops because master and slave have...

发布时间：2025/3/15 数据库 41 豆豆

生活随笔收集整理的这篇文章主要介绍了 mysql 主主忽略错误_MySQL 主主报错： Fatal error: The slave I/O thread stops because master and slave have... 小编觉得挺不错的,现在分享给大家,帮大家做个参考.

Mysql 主主启动错误处理

error 信息：

Slave_IO_State:

Master_Host: 192.168.6.87

Master_User: replication

Master_Port: 3306

Connect_Retry: 60

Master_Log_File: mysql-bin.000003

Read_Master_Log_Pos: 106

Relay_Log_File: mysqld-relay-bin.000002

Relay_Log_Pos: 4

Relay_Master_Log_File: mysql-bin.000003

Slave_IO_Running: No

Slave_SQL_Running: Yes

Replicate_Do_DB: mysql,cinder,nova,glance,keystone

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: 106

Relay_Log_Space: 106

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:

1 row in set (0.00 sec)

ERROR:

No query specified

解决办法：

server-id = 1 #必须与其他主从服务器保持不一致

log-bin=/var/lib/mysql/logbin/mysql-bin

binlog-ignore-db = test

binlog-ignore-db = information_schema

查询结果：

mysql> show slave status\G;

*************************** 1. row ***************************

Slave_IO_State: Waiting for master to send event