Edit on GitHub
Binary Logging Must Be Enabledlink
Issuelink
The connector shows the following error:
MySQL Error: Binary logging must be enabled: SHOW MASTER STATUS must return a non-empty result.
Environmentlink
Connector: Amazon RDS MySQL
Resolutionlink
To resolve this issue, perform the following steps:
Start a historical re-sync in the connector's Setup tab.
Causelink
The command SHOW MASTER STATUS
returns a binlog position that we need for incremental syncs. When this is disabled, we lose track of the incremental sync position. A historical re-sync is required to ensure data integrity.