MySQL主从复制实战

2021-12-27 02:37:35

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