question Re: What is the best way to Backup Ranger meta data periodically? in Archives of Support Questions (Read Only)

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

hazarathreddy — Tue, 12 Apr 2016 02:22:50 GMT

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.

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

bdurai — Tue, 12 Apr 2016 02:43:27 GMT

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.

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

hazarathreddy — Tue, 12 Apr 2016 03:13:52 GMT

@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.

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

bdurai — Tue, 12 Apr 2016 05:15:54 GMT

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

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

KuldeepK — Thu, 14 Apr 2016 02:01:31 GMT

@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.

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

KuldeepK — Sat, 16 Apr 2016 02:15:30 GMT

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

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

hazarathreddy — Tue, 19 Apr 2016 03:18:22 GMT

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

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

hazarathreddy — Wed, 18 Jan 2017 03:15:46 GMT

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.