1、准备主从二进制与中断日志记录

       mkdir -p /mysql/log/3306/binlog

       mkdir -p /mysql/log/3306/relaylog

       chown -R mysql:mysql /mysql/log/3306/binlog

       chown -R mysql:mysql /mysql/log/3306/relaylog

       chmod -R 775 /mysql/log/3306/binlog

       chmod -R 775 /mysql/log/3306/relaylog

2、准备主库参数

       bind-address=192.168.1.51

       server_id=513306

       skip_name_resolve = ON

       expire_logs_days = 7

       innodb_support_xa =1

       binlog_cache_size = 1M

       max_binlog_size = 2048M

       log_bin_trust_function_creators = 1

       innodb_flush_log_at_trx_commit =1

       sync_binlog = 1

       

       transaction-isolation = READ-COMMITTED

       gtid_mode = ON

       enforce_gtid_consistency = 1

       log-slave-updates = 1

       binlog_gtid_simple_recovery=1

       

       log_bin=/mysql/log/3306/binlog/itpuxdb-binlog

       log_bin_index=/mysql/log/3306/binlog/itpuxdb-binlog.index

       binlog_format=ROW

       binlog_rows_query_log_events=on

 

       plugin_dir=/mysql/app/mysql/lib/plugin/

       plugin_load="rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so"