ASP源码.NET源码PHP源码JSP源码JAVA源码DELPHI源码PB源码VC源码VB源码Android源码
当前位置:首页 >> 数据库 >> 其他数据库 >> Linux Mysql 56 主从(Master/Slave)同步配置

Linux Mysql 56 主从(Master/Slave)同步配置(3/4)

来源:网络整理     时间:2018-08-22     关键词:

本篇文章主要介绍了" Linux Mysql 56 主从(Master/Slave)同步配置",主要涉及到方面的内容,对于其他数据库感兴趣的同学可以参考一下: 安装环境:操作系统:CentOS 6.7 64位数据库:mysql 5.6主库(master)IP:192.168.1.91从库(slave)IP:192.16...

Replicate_Wild_Do_Table:

Replicate_Wild_Ignore_Table:

Last_Errno: 0

Last_Error:

Skip_Counter: 0

Exec_Master_Log_Pos: 120

Relay_Log_Space: 623

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

Master_UUID: a2e674e1-a536-11e8-92da-000c29d0ad20

Master_Info_File: /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)

注:在该处可能会有如下错误:

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> stop slave;

mysql> reset slave;

mysql> start slave;

相关图片

相关文章