Re: MySQL 5.7.17 GTID Replication always breaking

[Christian Huck]

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