[Openstack-operators] Database cleanup policy

2014-10-30 Thread Abel Lopez
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

Re: [Openstack-operators] Database cleanup policy

2014-10-30 Thread Morgan Fainberg
Hi Abel, For Keystone we already have a way to prune out expired records: keystone-manage token_flush This can be run via cron (recommended). The reason for the side band tool is that keystone does not have an internal scheduler for periodic tasks (not a common use keystone needs to do across

Re: [Openstack-operators] Database cleanup policy

2014-10-30 Thread Abel Lopez
Oh, I think you just gave me an idea for a new blueprint... Honestly, It seems that this is something that should be part of ${service}-manage On Oct 30, 2014, at 1:47 PM, Morgan Fainberg morgan.fainb...@gmail.com wrote: Hi Abel, For Keystone we already have a way to prune out expired