博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
MySQL主从复制报错及解决方法
阅读量:6603 次
发布时间:2019-06-24

本文共 2626 字,大约阅读时间需要 8 分钟。

mysql> show slave status \G*************************** 1. row ***************************               Slave_IO_State:                   Master_Host: 192.168.33.110                  Master_User: slave                  Master_Port: 3306                Connect_Retry: 60              Master_Log_File: mysql-bin000001          Read_Master_Log_Pos: 315               Relay_Log_File: localhost-relay-bin.000003                Relay_Log_Pos: 4        Relay_Master_Log_File: mysql-bin000001Slave_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: 315              Relay_Log_Space: 120              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: NULLMaster_SSL_Verify_Server_Cert: No                Last_IO_Errno: 1236Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'               Last_SQL_Errno: 0               Last_SQL_Error:   Replicate_Ignore_Server_Ids:              Master_Server_Id: 111                  Master_UUID: 39a19e0a-7957-11e6-aa19-0800272020f4             Master_Info_File: /Data/data/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: 161213 07:06:57     Last_SQL_Error_Timestamp:                Master_SSL_Crl:            Master_SSL_Crlpath:            Retrieved_Gtid_Set:             Executed_Gtid_Set:                 Auto_Position: 01 row in set (0.00 sec)解决办法:mysql> change master to master_log_file='mysql-bin.000001',master_log_pos=315;Query OK, 0 rows affected (0.01 sec)报错:Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work. 解决办法:Mysql/data目录,把auto.cnf文件也拷贝过来了,里面记录了数据库的uuid,每个库的uuid应该是不一样的。[auto]server-uuid=39a19e0a-7957-11e6-aa19-0800272020f5

  

转载于:https://www.cnblogs.com/timothy-lai/p/6514490.html

你可能感兴趣的文章
查看WINXP系统关机时间 so-easy
查看>>
修改mysql数据库编码
查看>>
代码审查RhodeCode试用
查看>>
我的友情链接
查看>>
squid代理服务器的控制功能详细配置
查看>>
MongoDB权威指南——入门
查看>>
mybatis设置一对多映射
查看>>
ubuntu 14.04编译安装openvas 8
查看>>
阳性水草与阴性水草的区分
查看>>
DIV+css命名规则
查看>>
Zookeeper 注册中心安装
查看>>
十一、RDS VDI 标准部署
查看>>
String StringBuffer StringBuilder
查看>>
通过路由器静态PAT访问FTP服务器测试
查看>>
自己需要读的书
查看>>
我的友情链接
查看>>
我的友情链接
查看>>
LVS/DR + keepalived负载均衡高可用实现
查看>>
我的友情链接
查看>>
notification
查看>>