MySQL主从复制实战

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"

       loose_rpl_semi_sync_master_enabled = 1

       loose_rpl_semi_sync_slave_enabled = 1

       loose_rpl_semi_sync_master_timeout = 5000

       rpl_semi_sync_master_wait_point = AFTER_SYNC

       rpl_semi_sync_master_wait_for_slave_count = 1

3、 准备从库参数

        bind-address=192.168.1.52

        server_id=523306

        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

MySQL主从复制实战

原文：https://www.cnblogs.com/zhoading/p/15121921.html