Issue
While setting up a connector with Google Cloud MySQL replica, the following error appears: Failed to determine binlog filename/position.
Environment
Connector: Google Cloud MySQL
Resolution
Configure your Fivetran setup form to use the master server instead of the replica.
Cause
Please see the below from Fivetran Google Cloud MySQL Documentation.
Your Google Cloud MySQL master server needs to be made accessible to Fivetran's data processing server.
Fivetran requires full access to the master's binlogs. Google allows read-only access to the read replica binlogs.