[Openstack-operators] How do you handle purge of database tables ?

Tim Bell Tim.Bell at cern.ch
Thu Jun 23 05:53:04 UTC 2016


There are also some tools in the OSOps repository (Nova for example has https://github.com/openstack/osops-tools-generic/tree/master/nova)

Tim

From: Abel Lopez <alopgeek at gmail.com>
Date: Thursday 23 June 2016 at 00:03
To: Gilles Mocellin <gilles.mocellin at nuagelibre.org>
Cc: openstack-operators <openstack-operators at lists.openstack.org>
Subject: Re: [Openstack-operators] How do you handle purge of database tables ?

Some projects (e.g. cinder) have tools..
`cinder-manage db-purge` or maybe it's "db purge" or something along those lines...
It was around Kilo when that got added.

Otherwise, in the past, I've done
mysql backup, then a massive table by table purge of "deleted=1" rows.

On Wed, Jun 22, 2016 at 2:39 PM, Gilles Mocellin <gilles.mocellin at nuagelibre.org<mailto:gilles.mocellin at nuagelibre.org>> wrote:
Le 22/06/2016 à 23:26, Gilles Mocellin a écrit :
Hello,

While digging in nova's database, I found that many objects ar not really deleted, but instead just marked deleted.
In fact, it's a general behavior in other projects (cinder, glance...).

I understand that. It can be handy.

But, is there a way to handle regular purging of theses elements inside OpenStack configuration ?

Or do we, operators, have to create batchs to purge all that ?

I've found some blueprints indicating that there nothing for now, inside OpenStack :

https://blueprints.launchpad.net/nova/+spec/purge-deleted-instances-cmd
https://blueprints.launchpad.net/cinder/+spec/database-purge
https://blueprints.launchpad.net/glance/+spec/database-purge



_______________________________________________
OpenStack-operators mailing list
OpenStack-operators at lists.openstack.org<mailto:OpenStack-operators at lists.openstack.org>
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20160623/8114daff/attachment.html>


More information about the OpenStack-operators mailing list