Deployer is unable to set MariaDB memory usage

[aeva black]

The current galera.cnf.j2 template does not provide any mechanism to the deployer to control the memory usage of InnoDB. It should, at a minimum, allow setting innodb_buffer_pool_size; 8192MB is not necessarily suitable to every environment.

Current template code:

{% set dynamic_pool_size_mb = (hostvars[inventory_hostname]['ansible_memtotal_mb'] * 0.4) | round | int %}
{% if dynamic_pool_size_mb < 8192 %}
innodb_buffer_pool_size = '{{ dynamic_pool_size_mb }}M'
{% else %}
innodb_buffer_pool_size = '8192M'
{% endif %}

Suggested resolution: include a variable in the role which would allow the deployer to set dynamic_pool_size_mb. If not set, retain current behavior.

[Eduardo Gonzalez (egonzalez90)]

Hi, you can override config files values.

/etc/kolla/config/galera.cnf or /etc/kolla/config/<hostname>/galera.cnf

[mysqld]
innodb_buffer_pool_size = 'valueMB'