开启MySQL的binlog功能

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf

server-id       = 1
log_bin         = /var/log/mysql/mysql-bin.log
expire_logs_days    = 30
max_binlog_size   = 100M
binlog_format     = ROW

sudo service mysqld restart

mysql -u root -p -e "show global variables like '%log_bin%';"

+---------------------------------+--------------------------------+
| Variable_name                   | Value                          |
+---------------------------------+--------------------------------+
| log_bin                         | ON                             |
| log_bin_basename                | /var/log/mysql/mysql-bin       |
| log_bin_index                   | /var/log/mysql/mysql-bin.index |
+---------------------------------+--------------------------------+