开启方法:
1、编辑/etc/my.cnf
2、增加如下三行:
server_id=1
log_bin=binlog
log_bin_index=binlog.index
3、重启mysql
4、验证方法:
mysql> show variables like '%log%bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin | ON |
| sql_log_bin | ON |
+---------------+-------+
5、日志验证:
mysql> system ls -l /opt/mysql/data
total 122988
-rw-r-----. 1 mysql mysql 56 Jun 7 17:05 auto.cnf
-rw-r-----. 1 mysql mysql 154 Jun 26 22:44 binlog.000001
-rw-r-----. 1 mysql mysql 16 Jun 26 22:44 binlog.index