<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">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:<div class=""><br class=""></div><div class=""><a href="http://dischord.org/2015/12/30/archiving-data-in-nova-s-database/" class="">http://dischord.org/2015/12/30/archiving-data-in-nova-s-database/</a></div><div class=""><br class=""><div class="">
<div style="color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">— </div><div class=""><br class=""></div><div class="">-Nick</div></div>
</div>
<br class=""><div><blockquote type="cite" class=""><div class="">On 23 Jun 2016, at 06:53, Tim Bell <<a href="mailto:Tim.Bell@cern.ch" class="">Tim.Bell@cern.ch</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="WordSection1" style="page: WordSection1; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman';" class=""><span style="font-size: 11pt; font-family: Calibri;" class="">There are also some tools in the OSOps repository (Nova for example has<span class="Apple-converted-space"> </span><a href="https://github.com/openstack/osops-tools-generic/tree/master/nova)" style="color: purple; text-decoration: underline;" class="">https://github.com/openstack/osops-tools-generic/tree/master/nova)</a><o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman';" class=""><span style="font-size: 11pt; font-family: Calibri;" class=""><o:p class=""> </o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman';" class=""><span style="font-size: 11pt; font-family: Calibri;" class="">Tim<o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman';" class=""><span style="font-size: 11pt; font-family: Calibri;" class=""><o:p class=""> </o:p></span></div><div style="border-style: solid none none; border-top-color: rgb(181, 196, 223); border-top-width: 1pt; padding: 3pt 0cm 0cm;" class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman';" class=""><b class=""><span style="font-family: Calibri;" class="">From:<span class="Apple-converted-space"> </span></span></b><span style="font-family: Calibri;" class="">Abel Lopez <<a href="mailto:alopgeek@gmail.com" class="">alopgeek@gmail.com</a>><br class=""><b class="">Date:<span class="Apple-converted-space"> </span></b>Thursday 23 June 2016 at 00:03<br class=""><b class="">To:<span class="Apple-converted-space"> </span></b>Gilles Mocellin <<a href="mailto:gilles.mocellin@nuagelibre.org" class="">gilles.mocellin@nuagelibre.org</a>><br class=""><b class="">Cc:<span class="Apple-converted-space"> </span></b>openstack-operators <<a href="mailto:openstack-operators@lists.openstack.org" class="">openstack-operators@lists.openstack.org</a>><br class=""><b class="">Subject:<span class="Apple-converted-space"> </span></b>Re: [Openstack-operators] How do you handle purge of database tables ?<o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman';" class=""><o:p class=""> </o:p></div></div><blockquote id="MAC_OUTLOOK_ATTRIBUTION_BLOCKQUOTE" style="border-style: none none none solid; border-left-color: rgb(181, 196, 223); border-left-width: 4.5pt; padding: 0cm 0cm 0cm 4pt; margin-left: 3.75pt; margin-right: 0cm;" class="" type="cite"><div class=""><div class=""><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman';" class="">Some projects (e.g. cinder) have tools..<span class="Apple-converted-space"> </span><o:p class=""></o:p></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman';" class="">`cinder-manage db-purge` or maybe it's "db purge" or something along those lines...<o:p class=""></o:p></div></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman';" class="">It was around Kilo when that got added.<o:p class=""></o:p></div></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman';" class=""><o:p class=""> </o:p></div></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman';" class="">Otherwise, in the past, I've done<o:p class=""></o:p></div></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman';" class="">mysql backup, then a massive table by table purge of "deleted=1" rows.<o:p class=""></o:p></div></div></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman';" class=""><o:p class=""> </o:p></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman';" class="">On Wed, Jun 22, 2016 at 2:39 PM, Gilles Mocellin <<a href="mailto:gilles.mocellin@nuagelibre.org" target="_blank" style="color: purple; text-decoration: underline;" class="">gilles.mocellin@nuagelibre.org</a>> wrote:<o:p class=""></o:p></div><blockquote style="border-style: none none none solid; border-left-color: rgb(204, 204, 204); border-left-width: 1pt; padding: 0cm 0cm 0cm 6pt; margin-left: 4.8pt; margin-right: 0cm;" class="" type="cite"><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman';" class="">Le 22/06/2016 à 23:26, Gilles Mocellin a écrit :<o:p class=""></o:p></div><blockquote style="border-style: none none none solid; border-left-color: rgb(204, 204, 204); border-left-width: 1pt; padding: 0cm 0cm 0cm 6pt; margin-left: 4.8pt; margin-right: 0cm;" class="" type="cite"><p class="MsoNormal" style="margin: 0cm 0cm 12pt; font-size: 12pt; font-family: 'Times New Roman';">Hello,<br class=""><br class="">While digging in nova's database, I found that many objects ar not really deleted, but instead just marked deleted.<br class="">In fact, it's a general behavior in other projects (cinder, glance...).<br class=""><br class="">I understand that. It can be handy.<br class=""><br class="">But, is there a way to handle regular purging of theses elements inside OpenStack configuration ?<br class=""><br class="">Or do we, operators, have to create batchs to purge all that ?<o:p class=""></o:p></p></blockquote><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman';" class=""><br class="">I've found some blueprints indicating that there nothing for now, inside OpenStack :<br class=""><br class=""><a href="https://blueprints.launchpad.net/nova/+spec/purge-deleted-instances-cmd" target="_blank" style="color: purple; text-decoration: underline;" class="">https://blueprints.launchpad.net/nova/+spec/purge-deleted-instances-cmd</a><br class=""><a href="https://blueprints.launchpad.net/cinder/+spec/database-purge" target="_blank" style="color: purple; text-decoration: underline;" class="">https://blueprints.launchpad.net/cinder/+spec/database-purge</a><br class=""><a href="https://blueprints.launchpad.net/glance/+spec/database-purge" target="_blank" style="color: purple; text-decoration: underline;" class="">https://blueprints.launchpad.net/glance/+spec/database-purge</a><o:p class=""></o:p></div></blockquote></div></div></div></div></blockquote></div></div></blockquote></div><br class=""></div></body></html>
<br>
<span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)">DataCentred Limited registered in England and Wales no. 05611763</span>