Thursday, April 12, 2012

Extract Data from Master oplog and Restore it in another MongoDB server

Extract data from oplog in MongoDB and restore in another MongoDB server.

                            Recently I came across a problem where we have to do a lot of modifications in the mongodb server which will be having issues with the production database. We removed the replication between the master and slave and then did the operation in slave and then updated the data using the tool wordnik-oss tools.

                             Unfortunately we did not have a replica set and we had normal Master-Slave setup. While all the updates are happening in slave I need to keep track of the master data so that I can add it to the slave. For this I used a tool named mongodb-admin-utils in wordnik-oss

Required software:

  1. Java and Git:
                  yum install java-1.6.0-sun-devel java-1.6.0-sun git

  2. Maven:
        recent version of wordnik-oss require maven 3

                  cd /usr/src
                    tar zxf apache-maven-3.0.4-bin.tar.gz

Building wordnik:

  1. Download and compile

                            git clone wordnik

  2. Compile and build
             In my case I only needed mongodb-admin-utils and hence I packaged only   that.

                         cd wordnik/modules/mongo-admin-utils
                        /usr/src/apache-maven-3.0.4/bin/mvn package

                       Once this is complete you can use mongo-admin-utils in the host.

Get Incremental oplog Backup from mongo master server

                cd wordnik/modules/mongo-admin-utils
               ./bin/ com.wordnik.system.mongodb.IncrementalBackupUtil  -o /root/mongo -h mastermongodb

                                   /root/mongo => output directory where the oplog is stored.
                                   mastermongodb => mongodb master host.

** We can't use this tool in slave as there is no oplog in slave.

Replay the Data from the oplog to the database

          I had some problems in restoring data from backup and I had to add the following settings for the restore to work without any issues.

    ulimit -n 20000

           Added the following Java options in so that it does not fail with Out Of Memory (OOM ) erros.

JAVA_CONFIG_OPTIONS="-Xms5g -Xmx10g -XX:NewSize=2g -XX:MaxNewSize=2g -XX:+UseConcMarkSweepGC -XX:+UseParNewGC -XX:PermSize=2g -XX:MaxPermSize=2g"

Replay Command:

            ./bin/ com.wordnik.system.mongodb.ReplayUtil -i /root/mongo -h localhost
                localhost => the mongodb server in which you want the data to be added.

         If you face any issues you can go ahead and file a issue in . The developer is a awesome person and will help you sort out the issue.

Custom puppet master hostname error hostname was not match with the server certificate

 When you want to use custom hostname for puppet it shows the following error.
err: Could not retrieve catalog from remote server: hostname was not match with the server certificate
warning: Not using cache on failed catalog
err: Could not retrieve catalog; skipping run
err: Could not send report: hostname was not match with the server certificate

 In my case I wanted to use the default hostname "puppet" . Add the following entries to puppet master configuration file /etc/puppet/puppet.conf

 certname = puppet

stop puppet master; mv /var/lib/puppet /var/lib/puppet-bak

start puppet

 Ensure that the cert is loaded with the name you want.

puppet cert print $(puppet master --configprint certname)|grep Subject

        Subject: CN=puppet

If the CN field is showing your hostname then this would not work.

Now you can use puppet agents to connect using

puppet agent --test --server puppet

Ensure that you have entries in /etc/hosts for puppet master