Error: Binary Logging Must be Enabled

Issue

The following error appears:

MySQL Error: Binary logging must be enabled: SHOW MASTER STATUS must return a non-empty result.

Environment

Connector: Amazon RDS MySQL

Resolution

To resolve this issue, perform the following steps:

1. Enable automatic snapshots in AWS.

2. Start a historical re-sync in the connector's Setup tab.

Cause

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.