Issue
The connector sync returns the following error:
MySQL Error: Binary logging must be enabled: SHOW MASTER STATUS must return a non-empty result.
Environment
Connector: Amazon RDS MySQL
Resolution
- Enable automatic snapshots in AWS.
- Start a historical sync in the connector's Setup tab.
Cause
The command SHOW MASTER STATUS returns a binlog position we need for incremental syncs. When this is disabled, we lose track of the incremental sync position. A historical resync is required to ensure data integrity.