我正在实现MySQL5.5(主)和mariaDB 10.2 (从)之间的主从复制,我得到了错误,比如在从
Relay log write failure: could not queue event from master
下面是我的配置
我运行MySQL5.5(主)作为独立服务器,mariadb (从) 10.2作为docker。
在主服务器中-
in my.cnf
[mysqld]
log-bin=mysql-bin
server-id=1
创建复制用户
CREATE USER 'repl'@'%' IDENTIFIED BY 'DuoS123';
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%';
获取主二进制位置
FLUSH TABLES WITH READ LOCK;
SHOW MASTER STATUS;
输出:-
filename : mysql-bin.000004 pos: 904
备机:
in my.cnf
[mysqld]
server-id=2
CHANGE MASTER TO MASTER_HOST='172.31.85.75', MASTER_USER='repl', MASTER_PASSWORD='DuoS123', MASTER_LOG_FILE='mysql-bin.000004',MASTER_LOG_POS=904 ;
发布于 2018-03-27 14:05:46
经过一番挖掘,我找到了解决方案,我将这一行添加到我的MariaDB10.2 my.cnf中,现在它的功能非常出色
slave_sql_verify_checksum=0
https://stackoverflow.com/questions/49504983
复制相似问题