[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