binlog主从备份
主 140， 从16
# 192.168.100.140
授权
GRANT REPLICATION SLAVE ON *.* to 'root'@'192.168.100.16' identified by 'siye2020';
1
/etc/my.conf
#binlog
log-bin=mysql_binlog
server-id=1
expire_logs_days = 8
sync_binlog=0
binlog_format=mixed
binlog-do-db=test
1
2
3
4
5
6
7
8
2
3
4
5
6
7
8
编辑 (opens new window)
上次更新: 2021/10/11, 12:43:58