开启binlog日志
vi /etc/my.cnf
## 增加
log-bin=mysql-bin
server-id=1
重启mysql
systemctl restart mysqld
查看binlog日志的位置
show variables like 'datadir';
system ls -lh /var/lib/mysql/;
查看binlog日志
开启binlog日志
vi /etc/my.cnf
## 增加
log-bin=mysql-bin
server-id=1
重启mysql
systemctl restart mysqld
查看binlog日志的位置
show variables like 'datadir';
system ls -lh /var/lib/mysql/;
查看binlog日志