做图片视频的网站,wordpress如何增加轮播,网站初期内容,房产网站关键词优化由于binlog日志带多删除了几个后发现MySQL主从不同步1、由于binlog日志带多删除了几个后发现MySQL主从不同步mysql show slave status\G;Slave_IO_Running: NoSlave_SQL_Running: Yes查看报错日志为[ERROR] Slave I/O: Got fatal error 1236 from master when reading data…由于binlog日志带多删除了几个后发现MySQL主从不同步1、由于binlog日志带多删除了几个后发现MySQL主从不同步mysql show slave status\G;Slave_IO_Running: NoSlave_SQL_Running: Yes查看报错日志为[ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: Could not find first log file name in binary log index file,解决方式从服务器配置主服务器查看mysql show master status;------------------------------------------------------------| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |------------------------------------------------------------| mysql-bin.000005 | 106 | | |------------------------------------------------------------1 row in set (0.00 sec)从服务器设置mysql change master to master_host192.168.0.10,master_userreplication,master_passwordreplication,master_log_filemysql-bin.000003,master_log_pos106;Query OK, 0 rows affected (0.03 sec)mysqlstop slave;mysqlstart slave;主服务器配置从服务器上查看mysql show master status;------------------------------------------------------------| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |------------------------------------------------------------| mysql-bin.000005 | 106 | | |------------------------------------------------------------1 row in set (0.00 sec)主服务器配置mysql change master to master_host192.168.0.11,master_userreplication,master_passwordreplication,master_log_filemysql-bin.000005,master_log_pos106;Query OK, 0 rows affected (0.03 sec)mysqlstop slave;mysqlstart slave;在查看slave状态ok解决。
