What is the best way to Backup Ranger meta data periodically?

[#1]

What is the best way to backup the Ranger database 0.5.0(only meta data for the purpose of disaster recovery). I see that the REST API is available. Can you please share your experience if you have implemented this in your organization? Thank you.

[#2 · Accepted solution]

The best option is to just backup your Ranger database. For production, you should also consider setting up DB level replication (active/active or active/passive). This will give you HA and DR.

[#3]

@bdurai, Thank you very much for redirecting me to this idea of 'setting up Replication'. I was spending my time on creating a Java application that uses REST APIs. If 'Setting up DB Level Replication' is effective solution in this case, it saves us lot of time. If you can please share more information of how to do this, it will be a great help. Thank you very much again.

[#4]

It would depend on which DB vendor you are using and what sort of license you have for your RDBMS. If you don't already have replication at the DB level, you might just for regular export of the DB, e.g mysqldump in MySQL would be a good short term solution for you

[#5]

@Hazarathkumar bobba

Please refer below link to setup master slave replication if you are using mysql.

http://www.tecmint.com/how-to-setup-mysql-master-slave-replication-in-rhel-centos-fedora/

You can also write sample oozie/cron job which will take mysqldump and store to some archived location, same script should have login to purge older dumps.

[#6]

@Hazarathkumar bobba - Please check below answers and accept one which is more relevant.

[#7]

Thank you @bdurai and @Kuldeep Kulkarni for your time. These were helpful.

[#8]

Hi @bdurai and @Kuldeep Kulkarni,

I have developed a Java tool which can download all the policies from Ranger and create those policies back into another Ranger Environment. Just thought of sharing with you guys.

Thanks for your time though.