question Re: save ranger audit to HDFS Vs Ranger audit to DB? in Archives of Support Questions (Read Only)

save ranger audit to HDFS Vs Ranger audit to DB?

garunkumar85 — Fri, 11 Mar 2016 23:25:47 GMT

whats the difference, prons and cons having ranger audit to DB vs ranger audit to HDFS?

Re: save ranger audit to HDFS Vs Ranger audit to DB?

awatson — Sat, 12 Mar 2016 00:08:55 GMT

Storing ranger audit logs on HDFS is beneficial for a couple of years:

A) It provides a more scalable distributed data store, so you can store logs for a lot longer

B) If you are currently leveraging Hadoop to store all security/audit logs. You can store your Ranger Audit logs along those in HDFS and be able to do better correlation between access request from different systems to help detect anomalies

Storing in the RBDMS was the original default. It provides better response times on smaller data sets but it's not as scalable and you will then need to maintain (e.g. purge/roll logs) on a set frequency.

Cheers,

Andrew

Re: save ranger audit to HDFS Vs Ranger audit to DB?

garunkumar85 — Sat, 12 Mar 2016 03:19:51 GMT

Thanks @Andrew Watson

@andrew watson

@Vperiasamy

Do we know which version of HDP saving ranger Audit to DB is going to be unsupported?

https://community.hortonworks.com/questions/2202/ranger-audit-options-is-db-audit-still-supported-i.html

Re: save ranger audit to HDFS Vs Ranger audit to DB?

bganesan — Sat, 12 Mar 2016 04:32:20 GMT

Ranger support for DB will most probably be phased out in the next release, it is being discussed in the community currently.