[mysqld]
datadir=/home/mysql57/data
tmpdir=/home/mysql57/tmp
socket=/home/mysql57/run/mysql.sock
user=mysql
default_password_lifetime=0
symbolic-links=0
read_buffer_size=128M
read_rnd_buffer_size=128M
sort_buffer_size=128M
key_buffer_size=128M
max_connections = 1024
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
binlog-format=ROW
log-slave-updates=true
gtid-mode=on # GTID only
enforce-gtid-consistency=true # GTID only
master-info-repository=TABLE
relay-log-info-repository=TABLE
sync-master-info=1
slave-parallel-workers=2
binlog-checksum=CRC32
master-verify-checksum=1
slave-sql-verify-checksum=1
binlog-rows-query-log_events=1
report-port=3306
port=3306
log-bin=/home/mysql57/log/mysql-bin.log
report-host=192.168.11.33
server-id = 33
binlog-ignore-db=mysql
replicate-ignore-db=mysql
sync_binlog=0
expire_logs_days = 10
slow_query_log_file=/home/mysql57/log/query-slow.log
innodb_log_file_size = 512M
innodb_log_files_in_group = 3
innodb_log_buffer_size = 512M
innodb_buffer_pool_size = 15480M
innodb_flush_log_at_trx_commit=2
innodb_lock_wait_timeout=3600
key_buffer_size = 512M
skip-name-resolve
[mysqld_safe]
log-error=/home/mysql57/log/mysqld.log
pid-file=/home/mysql57/run/mysqld.pid
[client]
socket=/home/mysql57/run/mysql.sock
