MySQL Forums
Forum List  »  Replication

Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
Posted by: Chintan Shah
Date: June 05, 2016 10:43PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
3150
June 05, 2016 10:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.