Question
How do I change the hostname for a MySQL database for an existing connector?
Environment
Connector: MySQL Database
Answer
Option 1: If binary logs match
1. Pause the connector
2. Click the Setup tab
3. Click the Edit connection details link
4. Update the host field with new value
5 Click Save and Test
6. Unpause the connector
Option 2: If binary logs do not match
1. Pause the connector
2. Click the Setup tab
3. Click the Edit connection details link
4. Update the host field with new value
5 Click Save and Test
6. Click Re-sync All Historical Data on the setup page
Cause
The connector captures changes in the binary logs using cursors. If the hostname change impacts the binary logs then the cursor is lost. This requires a resync.