Canal1.1.6发送MySql的binlog日志到Rocketmq(1)

MySQL启用binlog

MySQL版本8.0.27

1.1 修改 mysql 的配置文件 my.cnf 

  [mysqld]追加内容如下：

# 打开binlog

log-bin=mysql-bin

# 选择ROW(行)模式

binlog-format=ROW

# 配置MySQL replaction需要定义，不要和canal的slaveId重复

server_id=1    

1.2 重启 mysql

service mysqld restart

1.3 登录 mysql 客户端，查看 log_bin 变量

show variables like 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | ON    |
+---------------+-------+
1 row in set

  log_bin:ON  ，ON表示打开   OFF 表示关闭  

1.4 登录 mysql 客户端，查看日志格式

mysql> show variables like 'binlog_format';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| binlog_format | ROW   |
+---------------+-------+
1 row in set

1.5 登录 mysql 客户端，查看日志列表

mysql> show binary logs;
+------------------+-----------+-----------+
| Log_name         | File_size | Encrypted |
+------------------+-----------+-----------+
| mysql-bin.000001 |      1229 | No        |
| mysql-bin.000002 |       801 | No        |
+------------------+-----------+-----------+
2 rows in set