How to increase Galera innodb_buffer_pool_size with tripleo / Director in Red Hat OpenStack Platform?

Environment

Red Hat OpenStack Platform 10
Red Hat OpenStack Platform 17.1

Issue

How to increase Galera innodb_buffer_pool_size with tripleo / Director in Red Hat OpenStack Platform?

Resolution

1. Please push this change via the templates, e.g. in /home/stack/templates/network-environment.yaml:

   • For RHOSP10:

   parameter_defaults:
     controllerExtraConfig:
       tripleo::profile::base::database::mysql::innodb_buffer_pool_size: 20G
   

   • For RHOSP17.1:

   parameter_defaults:
     MysqlInnodbBufferPoolSize: '20G'
   

2. Then, run openstack overcloud deploy again to apply the changes to the Overcloud.

Root Cause

Also refer to https://access.redhat.com/articles/1432053

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.