Canal系列2-Canal同步到Kafka

一. MySQL的准备

MySQL版本 5.7.31

1.1 binlog格式

vim /etc/my.cnf

server-id=1
log-bin=mysql-bin 
binlog_format=row 
binlog-do-db=canal_test

重启mysql服务

测试记录:

mysql> show variables like '%log_bin%';
+---------------------------------+-------------------------------------+
| Variable_name                   | Value                               |
+---------------------------------+-------------------------------------+
| log_bin                         | ON                                  |
| log_bin_basename                | /home/mysql/data/3306/hp8-bin       |
| log_bin_index                   | /home/mysql/data/3306/hp8-bin.index |
| log_bin_trust_function_creators | OFF                                 |
| log_bin_use_v1_row_events       | OFF                                 |
| sql_log_bin                     | ON                                  |
+---------------------------------+-------------------------------------+
6 rows in set (0.01 sec)

mysql> show variables like '%binlog_format%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| binlog_format | ROW   |
+---------------+-------+
1 row in set (0.00 sec)

mysql> 

1.2 创建库表

代码:

create database canal_test default character set utf8;
show create database canal_test\G

use canal_test;
CREATE