Connect to Multiple Databases On the Same Server

Issue

I added a second database to the MySQL Server that is connected to Fivetran. However, the tables from this database are not appearing in the connector schema.

Environment

Connector: MySQL

Resolution

You need to create a new connector to connect to the second database. You must add a different user for connecting to your second database to prevent the connectors from terminating each other's connection. For more information, see our .

Cause

Each database on a server has its own Replica ID.