MySQL Forums
Forum List  »  Replication

Re: MySQL 5.7.17 GTID Replication always breaking
Posted by: Christian Huck
Date: February 24, 2017 03:09AM

Relevant parts of the my.cnf:


[mysqld]
datadir = /var/lib/mysql/live
log-error = /var/log/mysql/mysql.live.log
pid-file = /var/run/mysqld/mysql.live.pid
bind-address = 0.0.0.0
port = 3306
socket = /var/lib/mysql/mysql.live.sock
character-set-server = utf8
collation-server = utf8_general_ci
max_connections = 151
symbolic-links = 0
user = mysql
max_allowed_packet = 256M
event_scheduler = ON
innodb_buffer_pool_size = 12G
innodb_log_file_size = 512M
max_connections = 1000

# replication enabled
server-id = 1
binlog-ignore-db = mysql
binlog-ignore-db = health_monitor
replicate-ignore-db = mysql
replicate-ignore-db = health_monitor
enforce-gtid-consistency = true
gtid-mode = on
log-bin = /var/log/mysql/binlogs_live/mysql-bin
max_binlog_size = 500M
expire_logs_days = 7
relay-log = /var/log/mysql/relaylogs_live/mysql-relay
max_relay_log_size=500M
auto_increment_increment = 3
auto_increment_offset = 1
skip-slave-start = true
binlog-format=MIXED
master-info-repository = TABLE
relay-log-info-repository = TABLE


[mysqldump]
max_allowed_packet = 128M
quick
quote-names

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL 5.7.17 GTID Replication always breaking
670
February 24, 2017 03:09AM


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.