在my.cnf的mysqld下加入:
server_id = 0
log_bin=/harddisk/mysql_data/mysql_binlog/mysql-bin
binlog_format = MIXED
max_binlog_size = 100m
MySQL5.7以上开启binlog
原文：http://www.cnblogs.com/yoursoul/p/5114109.html
