Open Stack

Another vote of confidence for the script that Tim has mentioned with regards to clearing down Nova’s DB.  I blogged a bit about the process and the results here:

http://dischord.org/2015/12/30/archiving-data-in-nova-s-database/ <http://dischord.org/2015/12/30/archiving-data-in-nova-s-database/>

— 

-Nick

> On 23 Jun 2016, at 06:53, Tim Bell <Tim.Bell at cern.ch> wrote:
> 
> There are also some tools in the OSOps repository (Nova for example has https://github.com/openstack/osops-tools-generic/tree/master/nova) <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/nova/+spec/purge-deleted-instances-cmd>
>>> https://blueprints.launchpad.net/cinder/+spec/database-purge <https://blueprints.launchpad.net/cinder/+spec/database-purge>
>>> https://blueprints.launchpad.net/glance/+spec/database-purge <https://blueprints.launchpad.net/glance/+spec/database-purge>

-- 
DataCentred Limited registered in England and Wales no. 05611763
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20160623/de35cd26/attachment.html>