Please contact your support team if you have a question or need assistance for any Rackspace products, services, or articles.
This question is answered.
We are implementing a private openstack environment, and have 3 controllers, with more compute nodes in the near future. We have glance, nova, cinder, neutron, and keystone. We have increased our database max connections from the default of 100 to 300, but still are running out of connections. We can increase that number further, but want to know if there is a reasonable formula to use. I know that all the services create worker processes, and it seems to be related to the number of cpus. For instance, one one server, we have 26 glance-registry, and 26 glance-api processes. And that is just one service.
Does anyone know of a reasonable formula or sizing document? maybe something like #cpus X 5 x number of glance controllers (just for glance connections). Currently, looking at my database connections I have:
29 glance, 32 cinder, 130 nova, 23 neutron, and 11 keystone connections active on the db server. Any ideas on proper sizing of db connections?
Thank you for reaching out to us regarding this. OpenStack definitely uses quite a number of database connections and so therefore the number will need to be higher than what one would normally consider sufficient.
You can find the following information which eludes to the formula we use here in our upstream Rackspace Private Cloud powered by OpenStack deployment:
# NOTE: The number of max connections is defined by ( host_vcpus * 100 ). This value
# is the lowest integer based on the ansible facts gathered from every galera node.
# Computing the connections value using the lowest denominator maintains cluster integrity
# by not attempting to over commit to a less capable machine.
Hope this helps out Jim!
* This is based on MariaDB+Galera Cluster
Just noticed that link to master is broken -- here is a link to the same file on the latest tag:
Thanks for the info. I have run across this information before, so I guess this is the most info there is. I was hoping for a more detailed breakdown. Something like the number of nova-api * 12 + glance-api * 12 ...... Where the actual calculations are made to come up with that information. I just dont think that is has been analyzed to that level. We will use the number of vcpus*100, and go from there...
The Rackspace Community (“Community”) is provided “AS IS” without warranty of any kind. The information on the Community sites is created by members of the Community and is intended for reference and general discussions only. Although some of the content may contain information provided by Rackspace employees, it does not represent an assessment of a particular customer environment or an assessment of any specific compliance with laws or regulations or constitute advice. We recommend that you engage additional expertise in order to further evaluate applicable requirements for your specific environment. For customer specific support issues please contact your Rackspace Support Team.READ MORE
RACKSPACE MAKES NO REPRESENTATIONS OR WARRANTIES OF ANY KIND, EXPRESS OR IMPLIED, AS TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS OF THE RACKSPACE OPEN CLOUD COMMUNITY SITE. RACKSPACE RESERVES THE RIGHT TO DISCONTINUE OR MAKE CHANGES TO ITS SERVICES OFFERINGS AND SPECIFICATIONS AT ANY TIME WITHOUT NOTICE. USERS MUST TAKE FULL RESPONSIBILITY FOR APPLICATION OF ANY SERVICES AND/OR PROCESSES MENTIONED IN ANY COMMUNITY DISCUSSIONS. EXCEPT AS SET FORTH IN RACKSPACE GENERAL TERMS AND CONDITIONS, CLOUD TERMS OF SERVICE AND/OR OTHER AGREEMENT YOU SIGN WITH RACKSPACE, RACKSPACE ASSUMES NO LIABILITY WHATSOEVER, AND DISCLAIMS ANY EXPRESS OR IMPLIED WARRANTY, RELATING TO ITS SERVICES INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NONINFRINGEMENT.
ALTHOUGH PART OF THE COMMUNITY GENERATED CONTENT MAY EXPLAIN HOW RACKSPACE SERVICES MAY WORK WITH THIRD PARTY PRODUCTS, THE INFORMATION CONTAINED IN THE COMMUNITY DISCUSSIONS IS NOT DESIGNED TO WORK WITH ALL SCENARIOS. ANY USE OR CHANGES TO THIRD PARTY PRODUCTS AND/OR CONFIGURATIONS SHOULD BE MADE AT THE DISCRETION OF YOUR ADMINISTRATORS AND SUBJECT TO THE APPLICABLE TERMS AND CONDITIONS OF SUCH THIRD PARTY. EVEN THOUGH RACKSPACE EMPLOYEES MAY PARTICIPATE IN THE COMMUNITY DISCUSSIONS, RACKSPACE DOES NOT PROVIDE TECHNICAL SUPPORT FOR THIRD PARTY PRODUCTS, OTHER THAN SPECIFIED IN YOUR HOSTING SERVICES AGREEMENT YOU HAVE SIGNED WITH RACKSPACE AND RACKSPACE ACCEPTS NO RESPONSIBILITY FOR THIRD-PARTY PRODUCTS.READ LESS