[Openstack-operators] Database cleanup policy

Abel Lopez alopgeek at gmail.com
Thu Oct 30 20:20:32 UTC 2014

We just had this question come up regarding the labs, but it applies to production as well.

I'm thinking that we need to implement some sort of periodic database pruning. Perhaps like every two months or so, go through all databases, all tables, and do like

delete from FOO where deleted=1 and deleted_at < date_sub(now(), interval 2 month)

Just as an example.

Does anyone have see any issues with purging deleted=1 data?
I've seen this be very helpful for things like Keystone tokens, etc.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20141030/6be7a3b4/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 496 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20141030/6be7a3b4/attachment.pgp>

More information about the OpenStack-operators mailing list