How to Avoid Downtime and Re-Syncs During a MongoDB Upgrade

Question

How can I avoid downtime and re-syncs while upgrading your MongoDB source.

Environment

Connector: MongoDB

Answer

Upgrading to a supported version of MongoDB won't disrupt your syncs, and as long as the oplogs are retained during the upgrade, we won't perform a full re-sync. To avoid downtime during a MongoDB upgrade, we recommend that you do the following:

1. Pause your connector when no syncs are running.

   i. In Fivetran, go to your MongoDB connector page.

   ii. In the top right, set the ENABLED toggle to OFF.

2. Upgrade your MongoDB database.

3. Test your connection.

   i. In Fivetran, go to your MongoDB connector page.

   ii. Select the Setup tab.

   iii. Click Test connection.

   iv. Wait for setup tests to complete.

4. Resume your connector by setting the ENABLED toggle to ON.

If you're unsure about the process, test the upgrade using a staging MongoDB cluster and a corresponding Fivetran connection first. Ensure that you pause the connection before starting the upgrade, and resume it only after the upgrade is complete and verified.