Question

Can I connect initially to a replica and then move the same connector to a production database?

Environment

Connector: MySQL

Answer

We do not support changing the replica instance for a created connector unless you perform a full historical re-sync after swapping instances in Edit connection details.

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 would always need to be a re-sync to catch up.