Re: Mysql 5.7.10 Master-Master replication stops with 1032 error

[Chintan Shah]

Hi Rick,

From Slave:
mysql> SELECT * FROM crm_crmentity_seq;
+--------+
| id |
+--------+
| 340017 |
+--------+
1 row in set (0.00 sec)

Yes there is binlog_ignore in my.cnf of master mode. Below is the my.cnf file

sql-mode = "NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
datadir=/u01/mysql_data/data
socket=/var/lib/mysql/mysql.sock
user=mysql
binlog-ignore-db = "information_schema"
binlog-ignore-db = "mysql"
binlog-ignore-db = "performance_schema"
binlog-ignore-db = "sys"
replicate-ignore-db= "information_schema"
replicate-ignore-db= "mysql"
replicate-ignore-db= "performance_schema"
replicate-ignore-db= "sys"
bind-address = 0.0.0.0
server-id = 1
relay-log = /u01/mysql_data/data/log_bin/mysql-relay-bin
relay-log-index = /u01/mysql_data/data/log_bin/mysql-relay-bin.index
log-error = /u01/mysql_data/data/mysql.err
master-info-file = /u01/mysql_data/data/mysql-master.info
relay-log-info-file = /u01/mysql_data/data/log_bin/mysql-relay-log.info
log-bin = /u01/mysql_data/data/log_bin/mysql-bin
max_binlog_size= 200M
expire_logs_days= 14
binlog_cache_size= 64M
auto_increment_increment = 10
auto_increment_offset = 1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

interactive_timeout=360
wait_timeout=360

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

innodb_lock_wait_timeout=100
innodb_buffer_pool_size=20G
query_cache_size=256M
query_cache_limit=64K
table_open_cache_instances=8