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 for MySQL

Resolution

To resolve this issue:

1. Run SHOW MASTER STATUS on the source database as the Fivetran user and confirm that it returns an empty result. If the query returns values, verify that:
   • The connection's host points to the writer instance.
   • The AWS configuration is correct.
2. .Enable automatic snapshots in AWS. For more information, see the AWS Introduction to backups documentation.
3. In Fivetran, trigger a historical re-sync. To learn how, see How to Trigger Historical Re-Syncs for Fivetran Connections.

Cause

Fivetran uses the SHOW MASTER STATUS command to retrieve the binary log position required for incremental syncs. If binary logging is disabled, we can't determine the incremental sync position. A historical re-sync ensures data integrity after binary logging is enabled.

If SHOW MASTER STATUS returns values but the error persists, the connection may be configured to use a reader instance or another host that isn't associated with the connection.