mysql主从复制机制排错过程
来源:互联网 发布:火狐javascript设置 编辑:程序博客网 时间:2024/06/06 07:11
一. 主机器发出一个sql,导致所有的从机同步出错的问题解决流程
a.)进入从机的mysql控制台
b.) 查看复制进程的信息
mysql> show slave status\G
c.) 关注以下3个key及其内容
Master_Host:192.168.1.212
Relay_Master_Log_File:mysql-master-001-bin.000348
Exec_Master_Log_Pos:330637
*************************** 1. row *************************** Slave_IO_State: Master_Host: 192.168.1.212 Master_User: replication Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-master-001-bin.000348 Read_Master_Log_Pos: 330637 Relay_Log_File: mysql-slave-001-bin.000345 Relay_Log_Pos: 4 Relay_Master_Log_File: mysql-master-001-bin.000348 Slave_IO_Running: No Slave_SQL_Running: Yes Replicate_Do_DB: meerkat Replicate_Ignore_DB: mysql,information_schema 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: 330637 Relay_Log_Space: 151 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: 1236 Last_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: 2 Master_UUID: 3d3b9f4f-f74f-11e5-9a30-005056b324c4 Master_Info_File: mysql.slave_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: 160719 14:16:46 Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: Executed_Gtid_Set: 3d3b9f4f-f74f-11e5-9a30-005056b324c4:1-22:26-3944,40844d86-f74f-11e5-9a30-005056b370b3:1-4,73ae7f45-f74c-11e5-9a1e-005056b3294e:1-27485277:27485279-27487144 Auto_Position: 01 row in set (0.00 sec)
d.) 根据上面的3个可以的内容,修复同步
mysql> stop slave ;mysql> CHANGE MASTER TO MASTER_HOST='192.168.1.212', MASTER_LOG_FILE='mysql-master-001-bin.000348', MASTER_LOG_POS=330637 , MASTER_AUTO_POSITION = 0 ;mysql> start slave ;mysql> show slave status\G
阅读全文
0 0
- mysql主从复制机制排错过程
- mmm 主从复制机制排错过程
- Mysql主从复制/读写分离/proxy机制
- Redis主从复制机制
- 【mysql 主从复制】掌握MySQL主从复制
- 关于mysql主从复制的过滤机制的测试
- mysql 主从复制 主从配置
- DB2的排错过程
- DB2的排错过程
- MySQL主从复制配置
- mysql主从数据复制
- Mysql 主从复制
- mysql的主从复制
- Mysql搭建主从复制
- MySQL主从复制配置
- Mysql 主从数据库复制
- mysql主从复制
- MySQL主从复制
- 运维必须要懂的MySQL主从复制原理
- Android activity相互跳转后台出现两个页面的坑
- 微信小程序使用Socket
- spherface bug
- jsp页面静态和动态引入其他jsp页面的三种方式及区别
- mysql主从复制机制排错过程
- [转] Bayer转为RGB 2x2
- MySQL5.7安装及新建密码
- Eigen error C2039: “THIS_FUNCTION_IS_NOT_FOR_INTEGER_NUMERIC_TYPES”: 不是“Eigen::internal::static_asse
- OkHttp中response.body().string()解析
- swiper使用样例
- 无限轮播
- Assertion "OSQCreate" failed at line 71 in ..\LWIP\arch\sys_arch.c错误解决方法
- lua语言学习笔记