Migrate your data to Percona Server for MongoDB

enable_percona_mongo

1. The custom URI, if provided
2. The existing MongoDB VM
3. The new PSMDB cluster

1. Connect to your MongoDB instance through SSH, for example, using AWS Systems Manager Agent (SSM Agent).
2. To assign the

   backup

   role to the user who is to run the backup script, run this command:

   # Connect to MongoDB and grant the backup rolemongo --username {admin_username} --password {admin_password} --authenticationDatabase admindb.grantRolesToUser("asset-manager", ['backup'])

   Use these values:

   • admin_username

     : the

     asset-manager

     user if you're using our MongoDB VM

   • admin_password

     : the password that is stored in the

     mongo_db_connection_string

     secret in Secret Manager
3. Copy the backup script from the following location, and then run it:

   ./aws/scripts/mongodb-backup.sh

   To provide the correct username and password, run this command:

   ./mongodb-backup.sh asset-manager {password}

4. Retrieve the .tar file, for example, using the Secure Copy Protocol (SCP).
5. To validate which pod is the primary pod, run these commands:

   kubectl exec -it psmdb-db-rs0-x -c mongod -- bashmongo --username {admin_username} --password {admin_password} --authenticationDatabase adminrs.status()

   The password is stored in the

   psmdb_asset_manager_password

   secret in Secret Manager.
   Important

   You must run the restore operation on the primary pod, otherwise the operation fails. Ensure you perform the next steps on the primary pod.
   The primary pod is the pod that has these values:

   • "state" : 1

   • "stateStr" : "PRIMARY"

6. To retrieve .the tar file using SCP and copy it to the PSMDB primary pod, run this command:

   kubectl cp ~/tmp/mongo_data_backup_YYYY-MM-DD_HH-MM-SS.tar.gz psmdb-db-rs0-x:/tmp/mongo_backup_YYYY-MM-DD_HH-MM-SS.tar.gz -c mongod

7. Copy the restore script from the following location to the primary pod:

   ./aws/scripts/mongodb-restore.sh

   Run this command:

   kubectl cp ~/scripts/mongodb-restore.sh psmdb-db-rs0-x:/tmp/mongodb-restore.sh -c mongod

8. To connect to the primary pod and import the backup, run these commands:

   kubectl exec -it psmdb-db-rs0-x -c mongod -- bashcd /tmpchmod +x mongodb-restore.sh./mongodb-restore.sh asset-manager {password} mongo_backup_YYYY-MM-DD_HH-MM-SS.archive

9. To update the

   mongo_connection_uri

   terraform variable to use the new PSMDB cluster, run this command:

   mongo_connection_uri = "mongodb+srv://asset-manager:{password}@psmdb-db-rs0.{kubernetes_namespace}.svc.cluster.local?authSource=admin&replicaSet=rs0&ssl=false"

10. Restart the Asset Manager services so that they use the new connection string.
11. When you're sure that the new PSMDB cluster is working, you can disable MongoDB VM instance by setting the Terraform variable

    enable_mongo=false

    .