binlog简单介绍
1.开启binlog
#查看MySQL是否开启binlog:
show variables like '%log_bin%';
#开启,/etc/my.cnf
server-id=1
log-bin=mysql-bin
binlog_format=row
log_bin_basename=/var/log/mysql/mysql-bin #bin文件路径及名前缀
log_bin_index=/var/log/mysql/mysql-bin.index #bin文件index
2.binlog操作
原创
2021-09-04 11:09:54 ·
134 阅读 ·
0 评论