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_connections
configured 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.
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.