配置文件

[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