Question
Unable to read binary log and warning messaged displayed to re-sync the connector.
Environment
Connector: Aurora MySQL
Answer
1. As per the connector setup documentation, set the binary log retention period to a value between 24 and 168 hours using the following command (168 is set in the command):
CALL mysql.rds_set_configuration('binlog retention hours', 168);2. Re-sync the connector to sync any missed updates.
Cause
The connector has not synced all updates from the binary log before they have expired.