Mysql应用mysql从库Last

概述介绍《Mysql应用mysql从库Last》开发教程，希望对您有用。

《MysqL应用MysqL从库Last》要点：
本文介绍了MysqL应用MysqL从库Last，希望对您有用。如果有疑问，可以联系我们。

导读：MysqL从库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'报错处理 查看MysqL运行状况与备份情况,登录MysqL从库查看主从同步状态

MysqL> show slave status\G;  *************************** 1. row ***************************                 Slave_IO_State:                     Master_Host: 101.200.*.*                    Master_User: backup                    Master_Port: 3306                  Connect_Retry: 60                Master_Log_file: master-bin.000113            Read_Master_Log_Pos: 276925387                 Relay_Log_file: MysqL-relay.000001                  Relay_Log_Pos: 4          Relay_Master_Log_file: master-bin.000113               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: 276925387                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: NulL  Master_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: 21                    Master_UUID: e4a43da7-5b58-11e5-a12f-00163e003632               Master_Info_file: /home/data/MysqL/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: 170204 10:48:06       Last_sql_Error_Timestamp:                  Master_SSL_Crl:              Master_SSL_Crlpath:              RetrIEved_GtID_Set:               Executed_GtID_Set:                   auto_position: 0  1 row in set (0.00 sec)    ERROR:   No query specifIEd 

突然之间Slave_IO_Running: 状态变成NO了

 MysqL应用

解决方法.MysqL应用

首先在从库上执行MysqL应用

stop slave;MysqL应用

查看主库master状态

 MysqL应用

MysqL> show master status\G;  *************************** 1. row ***************************               file: MysqL-bin.000113           position: 276925387       binlog_Do_DB:    binlog_Ignore_DB:   Executed_GtID_Set:   1 row in set (0.00 sec)    ERROR:   No query specifIEd    MysqL> flush logs;  query OK, 0 rows affected (0.11 sec) 

刷新binlog日志MysqL应用

flush logs;MysqL应用

刷新后的日志会+1MysqL应用

例如上面的 file: MysqL-bin.000113 会变成 file: MysqL-bin.000114MysqL应用

再次查看master状态MysqL应用

MysqL> show master status\G;  *************************** 1. row ***************************               file: MysqL-bin.000114           position: 120       binlog_Do_DB:    binlog_Ignore_DB:   Executed_GtID_Set:   1 row in set (0.00 sec)    ERROR:   No query specifIEd 

然后就不需要在 *** 作master,切换到从库MysqL应用

输入CHANGE MASTER TO MASTER_LOG_file='MysqL-bin.000114',MASTER_LOG_POS=120;MysqL应用

执行start slave;MysqL应用

查看从库状态
 MysqL应用

MysqL> show slave status\G;  *************************** 1. row ***************************                 Slave_IO_State: Waiting for master to send event                    Master_Host: 101.200.*.*                    Master_User: backup                    Master_Port: 3306                  Connect_Retry: 60                Master_Log_file: MysqL-bin.000114            Read_Master_Log_Pos: 11314                 Relay_Log_file: MysqL-relay.000002                  Relay_Log_Pos: 11477          Relay_Master_Log_file: MysqL-bin.000114               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: 11314                Relay_Log_Space: 11646                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: 21                    Master_UUID: e4a43da7-5b58-11e5-a12f-00163e003632               Master_Info_file: /home/data/MysqL/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:        Last_sql_Error_Timestamp:                  Master_SSL_Crl:              Master_SSL_Crlpath:              RetrIEved_GtID_Set:               Executed_GtID_Set:                   auto_position: 0  1 row in set (0.00 sec)    ERROR:   No query specifIEd 

 MysqL应用

总结

以上是内存溢出为你收集整理的Mysql应用mysql从库Last全部内容，希望文章能够帮你解决Mysql应用mysql从库Last所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。