Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to limit Oozie database size?

Solved Go to solution

How to limit Oozie database size?

Contributor

Oozie Database size is growing at a rapid pace. It is currently @ 22gb but the customer would like to know how to limit the size of this db? and also looking for a procedure to archive old data so that it will never run of the space allocated. Can someone point me in the right direction to address this customer's concerns on Oozie Database size?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How to limit Oozie database size?

Mentor

@rbalam Oozie cleans up the database every 30 days by default, needless to say your customer should use an RDBMS like mysql and not derby in production. In latter case, you need to put derby on a large mount point, in case of RDBMS, all standard DBA practices apply.

4 REPLIES 4

Re: How to limit Oozie database size?

Mentor

@rbalam Oozie cleans up the database every 30 days by default, needless to say your customer should use an RDBMS like mysql and not derby in production. In latter case, you need to put derby on a large mount point, in case of RDBMS, all standard DBA practices apply.

Re: How to limit Oozie database size?

Contributor
@Artem Ervits

This customer is using mysql for Oozie but they are sharing it with other HDP components .. so what is the config to make the Oozie clean up data every 15 days? and also do we have a procedure if they want the old data in another database?

Re: How to limit Oozie database size?

Mentor

here's mysql docs for oozie in hdp.

Re: How to limit Oozie database size?

Mentor

@rbalam see this thread for property. Here's the whole list of properties you can look at.