Can the Same Database User Authorize Multiple Connections to the Same Source Database?

Question

Can a single database user authorize multiple MySQL connections connecting to the same source database?

Environment

Connector: MySQL

Resolution

We don't recommend using the same database user to authorize multiple MySQL connections syncing data from the same source database.

To prevent lingering connections used for reading the binary logs from interfering with data replication, we terminate all active connections associated with the authorizing user at the start of each sync.

To avoid unintended connection terminations, we recommend authorizing each MySQL connection with a unique database user and ensuring that each user is dedicated solely to its Fivetran connection.