5.4. 设置 MySQL 以运行 Debezium 连接器

流程

1. 创建 MySQL 用户：

   mysql> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';

2. 授予用户所需的权限：

   mysql> GRANT SELECT, RELOAD, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'user' IDENTIFIED BY 'password';

   下表描述了权限。

   重要

   如果使用托管的选项，如 Amazon RDS 或 Amazon Aurora，则不允许全局读取锁定，则使用表级锁定来创建 一致的快照。在这种情况下，您还需要为您创建的用户授予 LOCK TABLES 权限。如需了解更多详细信息，请参阅 快照。

3. 完成用户的权限：

   mysql> FLUSH PRIVILEGES;

流程

1. 检查 log-bin 选项是否已启用：

   // for MySql 5.x
   mysql> SELECT variable_value as "BINARY LOGGING STATUS (log-bin) ::"
   FROM information_schema.global_variables WHERE variable_name='log_bin';
   // for MySql 8.x
   mysql> SELECT variable_value as "BINARY LOGGING STATUS (log-bin) ::"
   FROM performance_schema.global_variables WHERE variable_name='log_bin';

2. 如果是 OFF，请使用以下属性配置 MySQL 服务器配置文件，下表中描述如下：

   server-id         = 223344 # Querying variable is called server_id, e.g. SELECT variable_value FROM information_schema.global_variables WHERE variable_name='server_id';
   log_bin           = mysql-bin
   binlog_format     = ROW
   binlog_row_image  = FULL
   expire_logs_days  = 10

3. 通过检查 binlog 状态一次确认您的更改：

   // for MySql 5.x
   mysql> SELECT variable_value as "BINARY LOGGING STATUS (log-bin) ::"
   FROM information_schema.global_variables WHERE variable_name='log_bin';
   // for MySql 8.x
   mysql> SELECT variable_value as "BINARY LOGGING STATUS (log-bin) ::"
   FROM performance_schema.global_variables WHERE variable_name='log_bin';

流程

1. 启用 gtid_mode ：

   mysql> gtid_mode=ON

2. 启用 enforce_gtid_consistency:

   mysql> enforce_gtid_consistency=ON

3. 确认更改：

   mysql> show global variables like '%GTID%';

流程

1. 配置 interactive_timeout ：

   mysql> interactive_timeout=<duration-in-seconds>

2. 配置 wait_timeout ：

   mysql> wait_timeout=<duration-in-seconds>

流程

1. 检查当前变量值

   mysql> show global variables where variable_name = 'binlog_row_value_options';

2. 结果

   +--------------------------+-------+
   | Variable_name            | Value |
   +--------------------------+-------+
   | binlog_row_value_options |       |
   +--------------------------+-------+

3. 如果值为 PARTIAL_JSON，请通过以下方法取消设置此变量：

   mysql> set @@global.binlog_row_value_options="" ;