How can I determine maximum number of connections required to MariaDB database for an Openstack deployment?
Issue
- RHEL-OSP Highly Available deployment with three controllers is using MariaDB with Galera as the database backend. We need to configure below in this environment.
- Default
max_connectionsconfigured for the MariaDB Server is 4096. - Services connect to the database via haproxy and haproxy has default limit of maximum 2000 connections for each proxy.
- Default
- How can I determine if these maximum connections are enough? If they need to be increased, what should be the right value to configure?
Environment
- Red Hat Enterprise Linux Openstack Platform 5.
- Red Hat Enterprise Linux Openstack Platform 6.
- Red Hat Enterprise Linux Openstack Platform 7.
- Red Hat Enterprise Linux Openstack Platform 8.
- Red Hat Enterprise Linux Openstack Platform 9.
- Red Hat Enterprise Linux Openstack Platform 10.
- Red Hat Enterprise Linux Openstack Platform 11.
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
