Does mysql-cdc support source creation for AWS RDS Mysql?
I'm trying to create a source for AWS RDS Mysql using mysql-cdc, but I'm encountering errors. Initially, I received a series of Internal error messages. After changing the port to 8306, I got a different error related to a Communications link failure. Here's the command I used to create the source:
create source mysql_mydb2 WITH ( connector = 'mysql-cdc', hostname = 'ENDPOINT', port = '3306', username = 'user', password = 'pass', database.name = 'db', server.id = 5455, debezium.snapshot.mode='schema_only', debezium.snapshot.locking.mode = 'none');
However, creating a table with a similar command works fine. I'm also curious about the difference in port numbers and whether debezium.snapshot.mode and debezium.snapshot.locking.mode are applicable when creating a source. Can you help me understand what's going wrong and how to fix it?
Sumit Singh
Asked on Mar 07, 2024
I'm having trouble creating a source for AWS RDS Mysql using mysql-cdc. Despite following the documentation, I'm encountering errors that suggest an Internal error and a Communications link failure. I've tried changing the port and adjusting the source creation command, but the issue persists. Additionally, I'm confused about the port number discrepancy and the usage of debezium.snapshot.mode and debezium.snapshot.locking.mode in the context of source creation. Can someone provide guidance on resolving these errors and clarify the correct usage of these parameters?