Backport Bugzilla No. 1472249[1] to OSP 10. There is a proposed fix upstream[2] which needs a workflow. [1] https://bugzilla.redhat.com/show_bug.cgi?id=1472249 [2] https://review.openstack.org/#/c/490578/
*** Bug 1472249 has been marked as a duplicate of this bug. ***
Verified, Checked in: osp10 , build Z6 function: "hiera-enabled setting for mysql.pp to allow configuration of innodb_buffer_pool_size in mysql implementation." #present in puppet manifest /etc/puppet/modules/tripleo/manifests/profile/base/database/mysql.pp : # [*innodb_buffer_pool_size*] # (Optional) Configure the size of the MySQL buffer pool. # Defaults to hiera('innodb_buffer_pool_size', undef) # class tripleo::profile::base::database::mysql ( ... $innodb_buffer_pool_size = hiera('innodb_buffer_pool_size', undef), #hiera configuration in overcloud deployment template: [root@controller-2 ~]# cat /etc/puppet/hieradata/controller_extraconfig.yaml tripleo::profile::base::database::mysql::innodb_buffer_pool_size: 525M #actual galera mysql config snippet: [root@controller-2 ~]# grep innodb_buffer_pool_size /etc/my.cnf.d/galera.cnf innodb_buffer_pool_size = 525M #mysql configurations check : MariaDB [(none)]> SHOW VARIABLES like '%innodb_buffer_pool_size%'; +-------------------------+-----------+ | Variable_name | Value | +-------------------------+-----------+ | innodb_buffer_pool_size | 550502400 | +-------------------------+-----------+
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2017:3231