How to limit Oozie database size?

[#1]

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?

[#2 · Accepted solution]

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

[#3]

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

[#4]

here's mysql docs for oozie in hdp.

[#5]

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