I would encourage you to use that repo and if there is something worth to be 
added updated, please do! All suggestions are welcome.

Edgar

From: Tim Bell <[email protected]>
Date: Wednesday, June 22, 2016 at 10:53 PM
To: Abel Lopez <[email protected]>, Gilles Mocellin 
<[email protected]>
Cc: "[email protected]" 
<[email protected]>
Subject: Re: [Openstack-operators] How do you handle purge of database tables ?

There are also some tools in the OSOps repository (Nova for example has 
https://github.com/openstack/osops-tools-generic/tree/master/nova)<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_openstack_osops-2Dtools-2Dgeneric_tree_master_nova-29&d=CwMGaQ&c=DS6PUFBBr_KiLo7Sjt3ljp5jaW5k2i9ijVXllEdOozc&r=G0XRJfDQsuBvqa_wpWyDAUlSpeMV4W1qfWqBfctlWwQ&m=YTsxdMdPQDeVWL18ZtfPm4l8Ukb65tAIMhgQ9NI5wtQ&s=iqH-TOGPCLIqE7no9W6uOVjn0xGpf-aV9YPh_whjx8Q&e=>

Tim

From: Abel Lopez <[email protected]>
Date: Thursday 23 June 2016 at 00:03
To: Gilles Mocellin <[email protected]>
Cc: openstack-operators <[email protected]>
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 
<[email protected]<mailto:[email protected]>> 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://urldefense.proofpoint.com/v2/url?u=https-3A__blueprints.launchpad.net_nova_-26-2343-3Bspec_purge-2Ddeleted-2Dinstances-2Dcmd&d=CwMGaQ&c=DS6PUFBBr_KiLo7Sjt3ljp5jaW5k2i9ijVXllEdOozc&r=G0XRJfDQsuBvqa_wpWyDAUlSpeMV4W1qfWqBfctlWwQ&m=YTsxdMdPQDeVWL18ZtfPm4l8Ukb65tAIMhgQ9NI5wtQ&s=NNbrSqzhDJ1ZxMs5D6pZKKrpsFj6PY1ssWnk6ITIQtA&e=>
https://blueprints.launchpad.net/cinder/+spec/database-purge<https://urldefense.proofpoint.com/v2/url?u=https-3A__blueprints.launchpad.net_cinder_-26-2343-3Bspec_database-2Dpurge&d=CwMGaQ&c=DS6PUFBBr_KiLo7Sjt3ljp5jaW5k2i9ijVXllEdOozc&r=G0XRJfDQsuBvqa_wpWyDAUlSpeMV4W1qfWqBfctlWwQ&m=YTsxdMdPQDeVWL18ZtfPm4l8Ukb65tAIMhgQ9NI5wtQ&s=CeqEqcnBufMXJxtM88hq2RG0qxfrqP6Eq6WofpFhqeM&e=>
https://blueprints.launchpad.net/glance/+spec/database-purge<https://urldefense.proofpoint.com/v2/url?u=https-3A__blueprints.launchpad.net_glance_-26-2343-3Bspec_database-2Dpurge&d=CwMGaQ&c=DS6PUFBBr_KiLo7Sjt3ljp5jaW5k2i9ijVXllEdOozc&r=G0XRJfDQsuBvqa_wpWyDAUlSpeMV4W1qfWqBfctlWwQ&m=YTsxdMdPQDeVWL18ZtfPm4l8Ukb65tAIMhgQ9NI5wtQ&s=iFf934niIjhaYHZLjcSD9-ebCVvpEeIOqljFy9unIfo&e=>



_______________________________________________
OpenStack-operators mailing list
[email protected]<mailto:[email protected]>
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators<https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.openstack.org_cgi-2Dbin_mailman_listinfo_openstack-2Doperators&d=CwMGaQ&c=DS6PUFBBr_KiLo7Sjt3ljp5jaW5k2i9ijVXllEdOozc&r=G0XRJfDQsuBvqa_wpWyDAUlSpeMV4W1qfWqBfctlWwQ&m=YTsxdMdPQDeVWL18ZtfPm4l8Ukb65tAIMhgQ9NI5wtQ&s=O4evdHuvokO4rzSqgxybzMqXAxxQJ88dRb4S3DJd-Xw&e=>

_______________________________________________
OpenStack-operators mailing list
[email protected]
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

Reply via email to