Edit on GitHub
Can I Configure Connector With Replica and Then Switch to Production Database?link
Questionlink
Can I configure a connector to use a replica instance initially and then switch to a production instance?
Environmentlink
Connector: MySQL
Answerlink
You can change the server instance for your existing connector to a different one in the Setup tab. However, you must perform a full historical re-sync after changing the instances to re-sync all your data.
Causelink
We use the binary log files in MySQL to replicate the data and these are different for each instance in MySQL. We cannot map the binary log event at which we left off on one of the instances to the other one, and there you would need a re-sync to catch up.