mysql binlog

 

show variables like 'log_bin';

show variables like 'binlog_format';

cp   /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf

修改my.cnf  binlog_format内容

# log_bin

log-bin = mysql-bin #开启binlog

binlog-format = ROW #选择row模式

server_id = 1 #配置mysql replication需要定义，不能喝canal的slaveId重复