Re: [openstack-dev] [nova] FKs in the DB

2015-11-24 Thread Julien Danjou
On Mon, Nov 23 2015, Jordan Pittier wrote: > Is the DB the limiting factor of openstack performance ? De we have hard > evidence of this ? We need numbers before acting otherwise it will be an > endless discussion. > > When I look at the number of race conditions we had/have in OpenStack, it >

Re: [openstack-dev] [nova] FKs in the DB

2015-11-23 Thread Alexis Lee
Matt Riedemann said on Fri, Nov 20, 2015 at 12:58:55PM -0600: > On 11/20/2015 10:19 AM, Alexis Lee wrote: > >Should we drive one way or the other, or just put up with mixed-mode? > For the record, I hate the mixed mode. +1 > >What should be the policy for new relations? > I prefer consistency,

Re: [openstack-dev] [nova] FKs in the DB

2015-11-23 Thread Alexis Lee
Julien Danjou said on Fri, Nov 20, 2015 at 05:52:59PM +0100: > On Fri, Nov 20 2015, Alexis Lee wrote: > > We just had a fun discussion in IRC about whether foreign keys are evil. > > Initially I thought this was crazy but mordred made some good points. To > > paraphrase, that if you have a

Re: [openstack-dev] [nova] FKs in the DB

2015-11-23 Thread Jordan Pittier
Hi, However, data > integrity /can/ be preserved in other ways than RDBMS constraints, while > persistence layer performance caps that of the whole system Is the DB the limiting factor of openstack performance ? De we have hard evidence of this ? We need numbers before acting otherwise it will

Re: [openstack-dev] [nova] FKs in the DB

2015-11-23 Thread Alexis Lee
Jordan Pittier said on Mon, Nov 23, 2015 at 11:59:35AM +0100: > Is the DB the limiting factor of openstack performance ? De we have hard > evidence of this ? We need numbers before acting otherwise it will be an > endless discussion. Properly parallelised workers scale linearly. Persistent

Re: [openstack-dev] [nova] FKs in the DB

2015-11-23 Thread Clint Byrum
Excerpts from Mike Bayer's message of 2015-11-22 11:59:06 -0800: > > On 11/20/2015 04:33 PM, Clint Byrum wrote: > > Excerpts from Mike Bayer's message of 2015-11-20 11:29:31 -0800: > >> > >> On 11/20/2015 11:19 AM, Alexis Lee wrote: > >>> We just had a fun discussion in IRC about whether foreign

Re: [openstack-dev] [nova] FKs in the DB

2015-11-22 Thread Mike Bayer
On 11/20/2015 04:33 PM, Clint Byrum wrote: > Excerpts from Mike Bayer's message of 2015-11-20 11:29:31 -0800: >> >> On 11/20/2015 11:19 AM, Alexis Lee wrote: >>> We just had a fun discussion in IRC about whether foreign keys are evil. >>> Initially I thought this was crazy but mordred made some

[openstack-dev] [nova] FKs in the DB

2015-11-20 Thread Alexis Lee
We just had a fun discussion in IRC about whether foreign keys are evil. Initially I thought this was crazy but mordred made some good points. To paraphrase, that if you have a scale-out app already it's easier to manage integrity in your app than scale-out your persistence layer. Currently the

Re: [openstack-dev] [nova] FKs in the DB

2015-11-20 Thread Julien Danjou
On Fri, Nov 20 2015, Alexis Lee wrote: > We just had a fun discussion in IRC about whether foreign keys are evil. > Initially I thought this was crazy but mordred made some good points. To > paraphrase, that if you have a scale-out app already it's easier to > manage integrity in your app than

Re: [openstack-dev] [nova] FKs in the DB

2015-11-20 Thread Matt Riedemann
On 11/20/2015 10:19 AM, Alexis Lee wrote: We just had a fun discussion in IRC about whether foreign keys are evil. Initially I thought this was crazy but mordred made some good points. To paraphrase, that if you have a scale-out app already it's easier to manage integrity in your app than

Re: [openstack-dev] [nova] FKs in the DB

2015-11-20 Thread Mike Bayer
On 11/20/2015 11:19 AM, Alexis Lee wrote: > We just had a fun discussion in IRC about whether foreign keys are evil. > Initially I thought this was crazy but mordred made some good points. To > paraphrase, that if you have a scale-out app already it's easier to > manage integrity in your app

Re: [openstack-dev] [nova] FKs in the DB

2015-11-20 Thread Mike Bayer
On 11/20/2015 02:29 PM, Mike Bayer wrote: > > > On 11/20/2015 11:19 AM, Alexis Lee wrote: >> We just had a fun discussion in IRC about whether foreign keys are evil. >> Initially I thought this was crazy but mordred made some good points. To >> paraphrase, that if you have a scale-out app

Re: [openstack-dev] [nova] FKs in the DB

2015-11-20 Thread Clint Byrum
Excerpts from Mike Bayer's message of 2015-11-20 11:29:31 -0800: > > On 11/20/2015 11:19 AM, Alexis Lee wrote: > > We just had a fun discussion in IRC about whether foreign keys are evil. > > Initially I thought this was crazy but mordred made some good points. To > > paraphrase, that if you have

Re: [openstack-dev] [nova] FKs in the DB

2015-11-20 Thread Clint Byrum
Excerpts from Matt Riedemann's message of 2015-11-20 10:58:55 -0800: > > On 11/20/2015 10:19 AM, Alexis Lee wrote: > > We just had a fun discussion in IRC about whether foreign keys are evil. > > Initially I thought this was crazy but mordred made some good points. To > > paraphrase, that if you