Home Admin Corner

Paxata Community Members: Something special in a community experience is coming your way. Stay tuned to this space.
In the meantime, check out the brand new Data Prep for Data Science topic here and the new DataRobot Community.

Visit the official Paxata Documentation portal for all of your doc needs.

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.
  dbPath: /usr/local/paxata/mongo
    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").


7) restart paxata server service

service paxata-server restart
Sign In or Register to comment.