Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

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

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.

View solution in original post

4 REPLIES 4

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.

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?

Mentor

here's mysql docs for oozie in hdp.

Mentor

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