Can I Configure My Connector to Switch From a Replica to a Production Instance?

Question

Can I configure a connector to use a replica instance initially and then switch to a production instance?

Environment

Connector: MySQL

Answer

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.

Cause

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.