MongoDB installation and upgrade

Downloading the connector

The connector is provided as a zip file on the Delphix download site. Perform these steps to download the connector:

1. Launch a web browser and navigate to the Delphix download portal.

2. Login to the portal using customer support credentials.

3. Navigate to Delphix Product Releases -> Select Connectors  ->  MongoDB_Linux → v0.X.X (applicable version number) → click the sc_mongo_0.X.X.json file available to initiate the download.

Installing the connector

1. Login to the Delphix Management application.

2. Click Manage -> Plugins.
   

3. To upload a plugin, click the + icon.
   

4. This step displays the Upload or Upgrade a Plugin dialog. Upload the sc_mongo_0.X.X.json file.
   

For more information, refer to the Continuous Data Engine connector management page.

Upgrading the connector

Uploading a higher version connector is the same as installing the MongoDB connector. 

Perform the following steps to upgrade a connector version:

1. Upload the higher version connector file at step 4 above.

2. Refresh all corresponding environments.

3. Ensure connector discovery is completed successfully.

4. Take a new snapshot of the staging database and VDB.

To verify the new version of the connector, view the snapshot metadata on the new snapshot.

To upgrade to newer versions of the MongoDB connector, you must follow the upgrade path as given below.

Things to consider during upgrade

• $MONGO_REPO_CFGFILE file update with connector upgrade

  • After uploading the 1.1.0 MongoDB connector version, specify the MongoDB database tools path in $MONGO_REPO_CFGFILE.

  • After uploading the 1.2.0 or later MongoDB connector version, specify all relevant paths for mongosh, mongod, mongorestore, mongodump, and mongosync in $MONGO_REPO_CFGFILE.

  • After uploading the 1.2.1 or later MongoDB connector version, replace the Legacy mongo shell with the mongosh shell on the staging and target environments, to make benefit of more shell features like MongoDB node.js driver support.

  • Once complete, refresh the environment. Steps can be found in the Refresh an environment section in the Environment operations page before executing any other operation.

Upgrade to MongoDB connector v1.2.1 or later

If the dSource type is onlinemongodump.

1. Make sure that the Source MongoDB Host Connect String contains replica set to PRIMARY as a first node in the connection string.

   1. For example, if Source MongoDB Host Connect String is set to mongohost1.com:28501,mongohost2.com:28502,mongohost3.com:28503, the mongohost1.com:28501 must refers to the PRIMARY node of replica set.

2. If the source database is SSL/TLS enabled, modify the Source MongoDB Host Connect String using the following rules:

   1. --ssl should be replaced with --tls

   2. --sslPEMKeyFile should be replaced with --tlsCertificateKeyFile

   3. --sslCAFile should be replaced with --tlsCAFile

Upgrading the MongoDB database version on source and staging

Upgrade process 

Perform the following steps when upgrading your MongoDB version.

1. On Staging and Target environments

   • Install newer MongoDB version on the Staging and Target Environments.

     Specify location of new MongoDB version.

     $ cat .mongorepos.txt

     MONGO_PATH=/u01/mongo509/bin/mongod

     MONGO_PATH=/u01/mongo6017/bin/mongod

2. Refresh Staging and Target environments to make sure the newly installed MongoDB repository is discovered.
   

3. Disable VDB and dSource.

4. Migrate dSource to newer repository.

   • Login to Delphix Engine CLI.
     $ ssh admin@dlpx-21000-mkk.dcol2.delphix.com (admin@dlpx-21000-mkk.dcol2.delphix.com) Password:: dlpx-21000-mkk.dcol2>
   • Make sure newly added MongoDB version is displayed in the repositories.
     dlpx-21000-mkk.dcol2> repository
dlpx-21000-mkk.dcol2 repository> ls
Objects
NAME VERSION ENVIRONMENT
'MongoDB - (version: v6.0.17) [/u01/mongo6017/bin/mongod]' - mkk-prod-src
   • Go to the sourceconfig and update the repository of the given dSource.
     dlpx-21000-mkk.dcol2 sourceconfig>
select offline_mongodb
dlpx-21000-mkk.dcol2 sourceconfig 'offline_mongodb'> update
dlpx-21000-mkk.dcol2 sourceconfig 'offline_mongodb'
update *> set repository="'MongoDB - (version: v6.0.17) [/u01/mongo6017/bin/mongod]'"
dlpx-21000-mkk.dcol2 sourceconfig 'offline_mongodb' update *> commit
Dispatched job JOB-44
SOURCE_CONFIG_UPDATE job started for "offline_mongodb".
SOURCE_CONFIG_UPDATE job for "offline_mongodb" completed successfully.
   • Make sure the repository has been successfully updated for the given sourceconfig.
     dlpx-21000-mkk.dcol2 sourceconfig 'offline_mongodb'> ls
Properties
type: AppDataStagedSourceConfig
name: offline_mongodb
discovered: false
environmentUser: delphix
linkingEnabled: true
parameters:
pretty_name: offline_mongodb
reference: APPDATA_STAGED_SOURCE_CONFIG-1
repository: 'MongoDB - (version: v6.0.17) [/u01/mongo6017/bin/mongod]'
toolkit: sc:mongopy
   • Go to Delphix Engine UI, enable dSource and take a new snapshot

5. Migrate VDB to newer repository.
   
   

6. Enable VDB and take a new snapshot.