date:20160622

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

2016-06-22 Thread Tim Bell

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 
Date: Thursday 23 June 2016 at 00:03
To: Gilles Mocellin 
Cc: openstack-operators 
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 
> 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@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

___
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

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

2016-06-22 Thread Abel Lopez

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.mocel...@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@lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
>
___
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

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

2016-06-22 Thread Gilles Mocellin


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@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

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

2016-06-22 Thread Silence Dogood

I use thermite.

On Wed, Jun 22, 2016 at 5:26 PM, Gilles Mocellin <
gilles.mocel...@nuagelibre.org> wrote:

> 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 ?
>
> ___
> OpenStack-operators mailing list
> OpenStack-operators@lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
>
___
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

Re: [Openstack-operators] Next Ops Midcycle NYC August 25-26

2016-06-22 Thread Mark Voelker

It would definitely be cool to have more ops folks attend both events.  I’d be 
happy to check in with the rest of the organizers and see if there’s a 
possibility of working something out.

At Your Service,

Mark T. Voelker



> On Jun 22, 2016, at 12:27 PM, David Medberry  wrote:
> 
> Would be sweet if that offer could be extended at least a week as we go 
> through the corp travel process. OTOH, $99 is almost cheap enough to buy and 
> not care I'll be doing that I guess.
> 
> On Wed, Jun 22, 2016 at 9:44 AM, Matt Jarvis  
> wrote:
> Hi Mark
> 
> Given we've not got the Eventbrite for the Ops Meetup live yet, is there any 
> chance you could extend the early bird pricing or give operators who may be 
> travelling for the Ops Meetup a discount code ? I suspect there may be quite 
> a lot of interest for those travelling some distance. 
> 
> Matt
> 
> On 22 June 2016 at 14:58, Mark Voelker  wrote:
> Hi Ops,
> 
> FYI for those that may not be aware, that’s also the week of OpenStack East.  
> OpenStack East runs August 23-24 also in New York City (about ~15-20 minutes 
> away from Civic Hall by MTA at the Playstation Theater).  If you’re coming to 
> town for the Ops Midcycle, you may want to make a week of it.  Earlybird 
> pricing for OpenStack East is still available but prices increase tomorrow:
> 
> http://www.openstackeast.com/
> 
> At Your Service,
> 
> Mark T. Voelker
> (wearer of many hats, one of which is OpenStack East steering committee 
> member)
> 
> 
> 
> > On Jun 21, 2016, at 11:36 AM, Jonathan D. Proulx  wrote:
> >
> > Hi All,
> >
> > The Ops Meetups Team has selected[1] New York City as the location of the
> > next mid-cycle meetup on August 25 and 26 2016 at Civic Hall[2]
> >
> > Many thanks to Bloomberg for sponsoring the location.  And thanks to
> > BestBuy as well for their offer of the Seattle location.  The choice
> > was very close and hopefully their offer will stand for our next North
> > American meet-up.
> >
> > There's quite a bit of work to do to make this all happen in the
> > next couple of months so it's still a great time to join the Ops
> > Meetups Team[3] and help out.
> >
> > -Jon
> >
> > --
> >
> > [1] 
> > http://eavesdrop.openstack.org/meetings/ops_meetups_team/2016/ops_meetups_team.2016-06-21-14.02.html
> > [2] 
> > https://urldefense.proofpoint.com/v2/url?u=http-3A__civichall.org_about-2Dcivic-2Dhall_=CwICAg=Sqcl0Ez6M0X8aeM67LKIiDJAXVeAw-YihVMNtXt-uEs=Q8IhPU-EIzbG5YDx5LYO7zEJpGZykn7RwFg-UTPWvDc=oAH-SSZ6EFikpmcyUpbf3984kyPBIuLJKkQadC6CKUw=36Kl-0b4WBC06xaYXo0V5AM2lHzvjhL48bBV48cz2is=
> > [3] https://wiki.openstack.org/wiki/Ops_Meetups_Team
> >
> >
> > ___
> > OpenStack-operators mailing list
> > OpenStack-operators@lists.openstack.org
> > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
> 
> ___
> OpenStack-operators mailing list
> OpenStack-operators@lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
> 
> 
> DataCentred Limited registered in England and Wales no. 05611763
> ___
> OpenStack-operators mailing list
> OpenStack-operators@lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
> 
> 

___
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

Re: [Openstack-operators] Next Ops Midcycle NYC August 25-26

2016-06-22 Thread David Medberry

Would be sweet if that offer could be extended at least a week as we go
through the corp travel process. OTOH, $99 is almost cheap enough to buy
and not care I'll be doing that I guess.

On Wed, Jun 22, 2016 at 9:44 AM, Matt Jarvis 
wrote:

> Hi Mark
>
> Given we've not got the Eventbrite for the Ops Meetup live yet, is there
> any chance you could extend the early bird pricing or give operators who
> may be travelling for the Ops Meetup a discount code ? I suspect there may
> be quite a lot of interest for those travelling some distance.
>
> Matt
>
> On 22 June 2016 at 14:58, Mark Voelker  wrote:
>
>> Hi Ops,
>>
>> FYI for those that may not be aware, that’s also the week of OpenStack
>> East.  OpenStack East runs August 23-24 also in New York City (about ~15-20
>> minutes away from Civic Hall by MTA at the Playstation Theater).  If you’re
>> coming to town for the Ops Midcycle, you may want to make a week of it.
>> Earlybird pricing for OpenStack East is still available but prices increase
>> tomorrow:
>>
>> http://www.openstackeast.com/
>>
>> At Your Service,
>>
>> Mark T. Voelker
>> (wearer of many hats, one of which is OpenStack East steering committee
>> member)
>>
>>
>>
>> > On Jun 21, 2016, at 11:36 AM, Jonathan D. Proulx 
>> wrote:
>> >
>> > Hi All,
>> >
>> > The Ops Meetups Team has selected[1] New York City as the location of
>> the
>> > next mid-cycle meetup on August 25 and 26 2016 at Civic Hall[2]
>> >
>> > Many thanks to Bloomberg for sponsoring the location.  And thanks to
>> > BestBuy as well for their offer of the Seattle location.  The choice
>> > was very close and hopefully their offer will stand for our next North
>> > American meet-up.
>> >
>> > There's quite a bit of work to do to make this all happen in the
>> > next couple of months so it's still a great time to join the Ops
>> > Meetups Team[3] and help out.
>> >
>> > -Jon
>> >
>> > --
>> >
>> > [1]
>> http://eavesdrop.openstack.org/meetings/ops_meetups_team/2016/ops_meetups_team.2016-06-21-14.02.html
>> > [2]
>> https://urldefense.proofpoint.com/v2/url?u=http-3A__civichall.org_about-2Dcivic-2Dhall_=CwICAg=Sqcl0Ez6M0X8aeM67LKIiDJAXVeAw-YihVMNtXt-uEs=Q8IhPU-EIzbG5YDx5LYO7zEJpGZykn7RwFg-UTPWvDc=oAH-SSZ6EFikpmcyUpbf3984kyPBIuLJKkQadC6CKUw=36Kl-0b4WBC06xaYXo0V5AM2lHzvjhL48bBV48cz2is=
>> > [3] https://wiki.openstack.org/wiki/Ops_Meetups_Team
>> >
>> >
>> > ___
>> > OpenStack-operators mailing list
>> > OpenStack-operators@lists.openstack.org
>> > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
>>
>> ___
>> OpenStack-operators mailing list
>> OpenStack-operators@lists.openstack.org
>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
>>
>
>
> DataCentred Limited registered in England and Wales no. 05611763
> ___
> OpenStack-operators mailing list
> OpenStack-operators@lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
>
>
___
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

Re: [Openstack-operators] Next Ops Midcycle NYC August 25-26

2016-06-22 Thread Tom Fifield


On 22/06/16 23:09, Saverio Proto wrote:

Did we create already a etherpad ?

I hope I did this correctly:
https://etherpad.openstack.org/p/NYC-ops-meetup


Looks great to me! Thanks for doing that :)



Saverio

2016-06-22 15:58 GMT+02:00 Mark Voelker :

Hi Ops,

FYI for those that may not be aware, that’s also the week of OpenStack East.  
OpenStack East runs August 23-24 also in New York City (about ~15-20 minutes 
away from Civic Hall by MTA at the Playstation Theater).  If you’re coming to 
town for the Ops Midcycle, you may want to make a week of it.  Earlybird 
pricing for OpenStack East is still available but prices increase tomorrow:

http://www.openstackeast.com/

At Your Service,

Mark T. Voelker
(wearer of many hats, one of which is OpenStack East steering committee member)




On Jun 21, 2016, at 11:36 AM, Jonathan D. Proulx  wrote:

Hi All,

The Ops Meetups Team has selected[1] New York City as the location of the
next mid-cycle meetup on August 25 and 26 2016 at Civic Hall[2]

Many thanks to Bloomberg for sponsoring the location.  And thanks to
BestBuy as well for their offer of the Seattle location.  The choice
was very close and hopefully their offer will stand for our next North
American meet-up.

There's quite a bit of work to do to make this all happen in the
next couple of months so it's still a great time to join the Ops
Meetups Team[3] and help out.

-Jon

--

[1] 
http://eavesdrop.openstack.org/meetings/ops_meetups_team/2016/ops_meetups_team.2016-06-21-14.02.html
[2] 
https://urldefense.proofpoint.com/v2/url?u=http-3A__civichall.org_about-2Dcivic-2Dhall_=CwICAg=Sqcl0Ez6M0X8aeM67LKIiDJAXVeAw-YihVMNtXt-uEs=Q8IhPU-EIzbG5YDx5LYO7zEJpGZykn7RwFg-UTPWvDc=oAH-SSZ6EFikpmcyUpbf3984kyPBIuLJKkQadC6CKUw=36Kl-0b4WBC06xaYXo0V5AM2lHzvjhL48bBV48cz2is=
[3] https://wiki.openstack.org/wiki/Ops_Meetups_Team


___
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators


___
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators


___
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators




___
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

Re: [Openstack-operators] Next Ops Midcycle NYC August 25-26

2016-06-22 Thread Saverio Proto

Did we create already a etherpad ?

I hope I did this correctly:
https://etherpad.openstack.org/p/NYC-ops-meetup

Saverio

2016-06-22 15:58 GMT+02:00 Mark Voelker :
> Hi Ops,
>
> FYI for those that may not be aware, that’s also the week of OpenStack East.  
> OpenStack East runs August 23-24 also in New York City (about ~15-20 minutes 
> away from Civic Hall by MTA at the Playstation Theater).  If you’re coming to 
> town for the Ops Midcycle, you may want to make a week of it.  Earlybird 
> pricing for OpenStack East is still available but prices increase tomorrow:
>
> http://www.openstackeast.com/
>
> At Your Service,
>
> Mark T. Voelker
> (wearer of many hats, one of which is OpenStack East steering committee 
> member)
>
>
>
>> On Jun 21, 2016, at 11:36 AM, Jonathan D. Proulx  wrote:
>>
>> Hi All,
>>
>> The Ops Meetups Team has selected[1] New York City as the location of the
>> next mid-cycle meetup on August 25 and 26 2016 at Civic Hall[2]
>>
>> Many thanks to Bloomberg for sponsoring the location.  And thanks to
>> BestBuy as well for their offer of the Seattle location.  The choice
>> was very close and hopefully their offer will stand for our next North
>> American meet-up.
>>
>> There's quite a bit of work to do to make this all happen in the
>> next couple of months so it's still a great time to join the Ops
>> Meetups Team[3] and help out.
>>
>> -Jon
>>
>> --
>>
>> [1] 
>> http://eavesdrop.openstack.org/meetings/ops_meetups_team/2016/ops_meetups_team.2016-06-21-14.02.html
>> [2] 
>> https://urldefense.proofpoint.com/v2/url?u=http-3A__civichall.org_about-2Dcivic-2Dhall_=CwICAg=Sqcl0Ez6M0X8aeM67LKIiDJAXVeAw-YihVMNtXt-uEs=Q8IhPU-EIzbG5YDx5LYO7zEJpGZykn7RwFg-UTPWvDc=oAH-SSZ6EFikpmcyUpbf3984kyPBIuLJKkQadC6CKUw=36Kl-0b4WBC06xaYXo0V5AM2lHzvjhL48bBV48cz2is=
>> [3] https://wiki.openstack.org/wiki/Ops_Meetups_Team
>>
>>
>> ___
>> OpenStack-operators mailing list
>> OpenStack-operators@lists.openstack.org
>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
>
> ___
> OpenStack-operators mailing list
> OpenStack-operators@lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

___
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

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

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

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

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

Re: [Openstack-operators] Next Ops Midcycle NYC August 25-26

Re: [Openstack-operators] Next Ops Midcycle NYC August 25-26

Re: [Openstack-operators] Next Ops Midcycle NYC August 25-26

Re: [Openstack-operators] Next Ops Midcycle NYC August 25-26

8 matches

Site Navigation

Mail list logo

Footer information