mysql 主从

主

server_id=1
log_bin=/srv/logs/mysql/mysql-bin
expire_logs_days=30

从

server_id=2
read_only = on
super_read_only = on
relay_log=/srv/logs/mysql/mysql-replay-bin
expire_logs_days=30
slave-parallel-type=LOGICAL_CLOCK
slave-parallel-workers=32