Skip to main content

Upgrade MongoDB to Amazon DB without upgrading AgilitySync

Overview​

Follow these instructions step-by-step to Upgrade MongoDB to Amazon DB without upgrading AgilitySync to RHEL 8 or 9(Agility Sync on RHEL 8 or 9), this can be done with MongoDB on same box or MongoDB on separate Box.

  1. Create a cluster in Amazon DB using Amazon Web Services(AWS) documentation.

  2. Assign the current App Box to the Cluster.

  3. Download the Amazon DocumentDB Certificate Authority (CA) certificate required to authenticate to your App box.

  4. Check the cluster connection using the mongo shell command given in document DB cluster in AWS.

  5. Create a user in DocumentDB using an encrypted password.

a. Download the backup script to App Server:

cd /tmp wget <as-backup-restore.py>

b. Make it Executable:

chmod +x <as-backup-restore.py>

c. Encrypt a password:

./as-backup-restore.py -o encrypt --encryption_key "key from agilitysync.yaml 
file" --password_to_encrypt "password"

Make a note of the plain password and the encrypted password.​

  1. Script to add a new user in App box (which will be used for cluster setup):

cd /opt/agilitysync/current/common/install/

./adduser_mongodb.py --adminuser <DocumentDBCluster username> --adminpassword <DocumentDBCluster pwd> --newuser syncuser --newpassword <new encrypted pwd> --replicasetname rs0 --replicasethosts <replicahostname> --sslcacertfile /etc/global-bundle.pem --ssl true

  1. To take backup of existing Data:

a. Stop Services:

as-stop-services

a. Run the backup script:

cd /tmp

./as-backup-restore.py -o backup -p </tmp> -t

(a tar.gz file gets created under the specified path)

  1. Run the restore script using the below parameters:
./as-backup-restore.py -o restore --mongo-host <replicate hostname> --mongo-user 
syncuser --mongo-pass "Mongo User's un-encrypted password" --mongo-
ssl-ca-certs /etc/global-bundle.pem --mongo-ssl true -p <path to backup 
tar file> -t

  1. Modify the agilitysync.yaml
vim /etc/agilitysync/agilitysync.yaml

Add Amazon Cluster details like below:

mongodb_replicaset_hosts: <replicate hostname>

mongodb_database: agilitysync

mongodb_username: syncuser

mongodb_password: <Encrypted pwd of the user>

mongodb_ssl: true

mongodb_ssl_ca_certs: /etc/global-bundle.pem

mongodb_replicaset_name: rs0

mongo_retry_writes: false

mongodb_read_preference: secondaryPreferred

And Save

  1. Start services:

as-start-services