[openstack-dev] [octavia] Please give me some comments about my patchs
Hi, Octavia Team: There are two patches I committed: https://review.openstack.org/#/c/590620/ https://review.openstack.org/#/c/594040/ The first implement l7policy and l7rule's quota management. The second provides some restrictions about the protocol when listener is associated with pool. I think these functions are useful for users. I hope to receive some suggestions from you. Thinks. __ OpenStack Development Mailing List (not for usage questions) Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
Re: [openstack-dev] [octavia] Optimize the query of the octavia database
Ok, Thank you very much for your work. Adam Harwell 于2018年9月15日周六 上午8:26写道： > It's high priority for me as well, so we should be able to get something > done very soon, I think. Look for something early next week maybe? > > Thanks, > --Adam > > On Thu, Sep 13, 2018, 21:18 Jeff Yang wrote: > >> Thanks: >> I found the correlative patch in neutron-lbaas: >> https://review.openstack.org/#/c/568361/ >> >> The bug was marked high level by our QA team. I need to fix it as >> soon as possible. >> Does Michael Johnson have any good suggestion? I am willing to >> complete the >> repair work of this bug. If your patch still takes a while to >> prepare. >> >> Michael Johnson 于2018年9月14日周五 上午7:56写道： >> >>> This is a known regression in the Octavia API performance. It has an >>> existing story[0] that is under development. You are correct, that >>> star join is the root of the problem. >>> Look for a patch soon. >>> >>> [0] https://storyboard.openstack.org/#!/story/2002933 >>> >>> Michael >>> On Thu, Sep 13, 2018 at 10:32 AM Erik Olof Gunnar Andersson >>> wrote: >>> > >>> > This was solved in neutron-lbaas recently, maybe we could adopt the >>> same method for Octavia? >>> > >>> > Sent from my iPhone >>> > >>> > On Sep 13, 2018, at 4:54 AM, Jeff Yang >>> wrote: >>> > >>> > Hi, All >>> > >>> > As octavia resources increase, I found that running the "openstack >>> loadbalancer list" command takes longer and longer. Sometimes a 504 error >>> is reported. >>> > >>> > By reading the code, I found that octavia will performs complex left >>> outer join queries when acquiring resources such as loadbalancer, listener, >>> pool, etc. in order to only make one trip to the database. >>> > Reference code: http://paste.openstack.org/show/730022 Line 133 >>> > Generated SQL statements: http://paste.openstack.org/show/730021 >>> > >>> > So, I suggest that adjust the query strategy to provide different join >>> queries for different resources. >>> > >>> > https://storyboard.openstack.org/#!/story/2003751 >>> > >>> > >>> __ >>> > OpenStack Development Mailing List (not for usage questions) >>> > Unsubscribe: >>> openstack-dev-requ...@lists.openstack.org?subject:unsubscribe >>> > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev >>> > >>> > >>> __ >>> > OpenStack Development Mailing List (not for usage questions) >>> > Unsubscribe: >>> openstack-dev-requ...@lists.openstack.org?subject:unsubscribe >>> > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev >>> >>> >>> __ >>> OpenStack Development Mailing List (not for usage questions) >>> Unsubscribe: >>> openstack-dev-requ...@lists.openstack.org?subject:unsubscribe >>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev >>> >> __ >> OpenStack Development Mailing List (not for usage questions) >> Unsubscribe: >> openstack-dev-requ...@lists.openstack.org?subject:unsubscribe >> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev >> > __ > OpenStack Development Mailing List (not for usage questions) > Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > __ OpenStack Development Mailing List (not for usage questions) Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
Re: [openstack-dev] [octavia] Optimize the query of the octavia database
Thanks: I found the correlative patch in neutron-lbaas: https://review.openstack.org/#/c/568361/ The bug was marked high level by our QA team. I need to fix it as soon as possible. Does Michael Johnson have any good suggestion? I am willing to complete the repair work of this bug. If your patch still takes a while to prepare. Michael Johnson 于2018年9月14日周五 上午7:56写道： > This is a known regression in the Octavia API performance. It has an > existing story[0] that is under development. You are correct, that > star join is the root of the problem. > Look for a patch soon. > > [0] https://storyboard.openstack.org/#!/story/2002933 > > Michael > On Thu, Sep 13, 2018 at 10:32 AM Erik Olof Gunnar Andersson > wrote: > > > > This was solved in neutron-lbaas recently, maybe we could adopt the same > method for Octavia? > > > > Sent from my iPhone > > > > On Sep 13, 2018, at 4:54 AM, Jeff Yang wrote: > > > > Hi, All > > > > As octavia resources increase, I found that running the "openstack > loadbalancer list" command takes longer and longer. Sometimes a 504 error > is reported. > > > > By reading the code, I found that octavia will performs complex left > outer join queries when acquiring resources such as loadbalancer, listener, > pool, etc. in order to only make one trip to the database. > > Reference code: http://paste.openstack.org/show/730022 Line 133 > > Generated SQL statements: http://paste.openstack.org/show/730021 > > > > So, I suggest that adjust the query strategy to provide different join > queries for different resources. > > > > https://storyboard.openstack.org/#!/story/2003751 > > > > > __ > > OpenStack Development Mailing List (not for usage questions) > > Unsubscribe: > openstack-dev-requ...@lists.openstack.org?subject:unsubscribe > > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > > > > > __ > > OpenStack Development Mailing List (not for usage questions) > > Unsubscribe: > openstack-dev-requ...@lists.openstack.org?subject:unsubscribe > > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > > __ > OpenStack Development Mailing List (not for usage questions) > Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > __ OpenStack Development Mailing List (not for usage questions) Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
[openstack-dev] [octavia] Optimize the query of the octavia database
Hi, All As octavia resources increase, I found that running the "openstack loadbalancer list" command takes longer and longer. Sometimes a 504 error is reported. By reading the code, I found that octavia will performs complex left outer join queries when acquiring resources such as loadbalancer, listener, pool, etc. in order to only make one trip to the database. Reference code: http://paste.openstack.org/show/730022 Line 133 Generated SQL statements: http://paste.openstack.org/show/730021 So, I suggest that adjust the query strategy to provide different join queries for different resources. https://storyboard.openstack.org/#!/story/2003751 __ OpenStack Development Mailing List (not for usage questions) Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
[openstack-dev] [octavia] Make amphora-agent support http rest api
In some private cloud environments, the possibility of vm being attacked is very small, and all personnel are trusted. At this time, the administrator hopes to reduce the complexity of octavia deployment and operation and maintenance. We can let the amphora-agent provide the http api so that the administrator can ignore the issue of the certificate. https://storyboard.openstack.org/#!/story/2003027 __ OpenStack Development Mailing List (not for usage questions) Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
[openstack-dev] [octavia] Some tips about amphora driver
Recently, my team plans to provider load balancing services with octavia.I recorded some of the needs and suggestions of our team members.The following suggestions about amphora may be very useful. [1] User can specify image and flavor for amphora. [2] Enable multi processes(version<1.8) or multi threads(version>=1.8) for haproxy [3] Provider a script to check and clean up bad loadbalancer and amphora. Moreover we alse need to clean up neutron and nova resources about these loadblancer and amphora. The implementation of [1] and [2] depend on provider flavor framework. So it's time to implement provider flavor framework. About [3], We can't delete loadbalancer by API if the loadbalancer's status is PENDING_UPDATE or PENDING_CREATE. And we haven't api for delete amphora, so if the status of this amphora is not active it will always exists. So the script is necessary. https://storyboard.openstack.org/#!/story/2002896 __ OpenStack Development Mailing List (not for usage questions) Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
