RDS - MySQL CDC Troubleshooting Guide

Overview

This guide outlines troubleshooting steps for Rivery's Change Data Capture (CDC) with Amazon RDS MySQL Replica. It covers AWS Console settings, MySQL configurations, permissions, binlog settings, and common issues.

1. AWS Console Configuration

• RDS Instance Type: Ensure a Read Replica is used. Check status: Active.
• MySQL Version: Must be 5.7 or later.
• Network Access:
  • Publicly Accessible: Yes (if Rivery connects externally).
  • Security Group: Allow TCP 3306 from Rivery's IP range.
• Binlog Retention: Increase if needed (default is 24h).

CALL mysql.rds_set_configuration('binlog retention hours', 168); -- 7 days

2. MySQL Configuration

Binlog Settings

CDC requires binary logging with ROW format and FULL row image:

SHOW VARIABLES LIKE 'binlog%';

Expected values:

If values are incorrect, modify the Parameter Group in AWS RDS.

Verify Binary Logs

Ensure logs exist:

SHOW BINARY LOGS;

Check current binlog position:

SHOW MASTER STATUS;

Ensure Rivery is using the correct File and Position.

3. Rivery User Permissions

CDC requires:

• REPLICATION SLAVE, REPLICATION CLIENT, SELECT
  Check privileges:

SHOW GRANTS FOR 'rivery_user'@'%';

If missing, grant:

GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'rivery_user'@'%';
GRANT SELECT ON your_database.* TO 'rivery_user'@'%';
FLUSH PRIVILEGES;

4. Replication Status (For Read Replica)

Ensure replication is active:

SHOW SLAVE STATUS\G;

Expected values:

• Slave_IO_Running: Yes
• Slave_SQL_Running: Yes

If not syncing, restart:

STOP SLAVE;
START SLAVE;

5. Rivery Connection Testing

• Test in Rivery Data Sources.
• Verify RDS Security Group settings.
• Ensure correct credentials.
• Run sample query

SELECT * FROM your_database.your_table LIMIT 10;

If it fails, check permissions.

Common Errors & Fixes