mysql - 如何为 Debezium 连接器的 RDS Mysql 启用二进制日志记录

Question

我正在尝试按照文档设置 MySQL Debezium 连接器

https://debezium.io/documentation/reference/0.10/connectors/mysql.html

我想为 RDS 启用 bin 日志记录，其中我有一个数据库实例的读取器和写入器。

我尝试启用它，但看起来我错过了一些东西：

mysql> show global variables like 'log_bin'; show global variables like 'binlog_format';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | OFF   |
+---------------+-------+
1 row in set (0.19 sec)

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| binlog_format | ROW   |
+---------------+-------+
1 row in set (0.20 sec)

mysql> SHOW BINARY LOGS;
ERROR 1381 (HY000): You are not using binary logging
mysql> call mysql.rds_set_configuration('binlog retention hours', 24);
Query OK, 0 rows affected (0.20 sec)

mysql> SHOW BINARY LOGS;
ERROR 1381 (HY000): You are not using binary logging
mysql> CALL mysql.rds_show_configuration
    -> ;
+------------------------+-------+------------------------------------------------------------------------------------------------------+
| name                   | value | description                                                                                          |
+------------------------+-------+------------------------------------------------------------------------------------------------------+
| binlog retention hours | 24    | binlog retention hours specifies the duration in hours before binary logs are automatically deleted. |
+------------------------+-------+------------------------------------------------------------------------------------------------------+
1 row in set (0.18 sec)

Query OK, 0 rows affected (0.18 sec)

mysql> SHOW BINARY LOGS;
ERROR 1381 (HY000): You are not using binary logging

你能建议我错过什么吗？

标签： mysqlamazon-web-servicesamazon-rdsdebezium