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.