Handle MongoDB Storage Engine Migration

Handle MongoDB Storage Engine Migration

During Paxata upgrade, if you are not using MMapV1 and does not have preference for wiredTiger or MMapV1 as storage engine, then Paxata recommend them to use wiredTiger as Mongo Storage Engine, as it provides faster query time. 

If Paxata is the only application that is using mongo then below are the steps you can follow the switch MongoDB Storage Engine from MMapV1 to wiredTiger.

1) Stop Paxata Server

service paxata-server stop

2) Take mongo backup of paxata schema (default mongo db name for paxata is "paxata").

sudo mongodump --db paxata --out /data/paxata/mongobackups/`date +"%m-%d-%y"`

3) Edit /etc/mongod.conf to use wiredTiger ( i.e set engine: "wiredTiger" ).

# Where and how to store data.
storage:
  dbPath: /usr/local/paxata/mongo
  journal:
    enabled: true
  engine: wiredTiger


4) restart mongod.

service mongod restart

5) restore paxata backup as new schema (with different schema name than "paxata", such as "paxataNew").

sudo mongorestore --db paxataNew --drop /var/backups/mongobackups/03-23-17/paxata/

6) edit paxata's /usr/local/paxata/server/config/database.properties to use new schema ("paxataNew").

mongo.database=paxataNew

7) restart paxata server service

service paxata-server restart
0 Kudos
0 Replies