## **查看 binlog 日志状态** ~~~ mysql> show global variables like '%log_bin%'; ~~~ 返回值如下： | Variable\_name | Value | | --- | --- | | log\_bin | ON | | log\_bin\_basename | /www/server/data/mysql-bin | | log\_bin\_index | /www/server/data/mysql-bin.index | | log\_bin\_trust\_function\_creators | OFF | | log\_bin\_use\_v1\_row\_events | OFF | ## **查看正在使用的 binlog 日志** ~~~ mysql> show master status; ~~~ 返回值如下： | File | Position | Binlog\_Do\_DB | Binlog\_Ignore\_DB | Executed\_Gtid\_Set | | --- | --- | --- | --- | --- | | mysql-bin.000008 | 154 | | | | ## **开启 binlog 日志（修改 my.cnf 配置文件）** ~~~ [mysqld] log-bin=mysql-bin server-id = 1 # 如果配置了主从，这里的 server-id 需要注意不能重复 ~~~