Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1483656

Summary:	MariaDB adjustment parameter missing
Product:	Red Hat OpenStack	Reporter:	Aviv Guetta <aguetta>
Component:	puppet-tripleo	Assignee:	RHOS Maint <rhos-maint>
Status:	CLOSED ERRATA	QA Contact:	pkomarov
Severity:	medium	Docs Contact:
Priority:	high
Version:	10.0 (Newton)	CC:	aschultz, fdinitto, jjoyce, jschluet, lruzicka, mbayer, mburns, mschuppe, pkomarov, rhel-osp-director-maint, slinaber, tvignaud, ushkalim, vcojot, yroblamo
Target Milestone:	z6	Keywords:	Triaged, ZStream
Target Release:	10.0 (Newton)
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	puppet-tripleo-5.6.2-1.el7ost	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:
Clones:	1488538 (view as bug list)		Environment:
Last Closed:	2017-11-15 13:45:13 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Aviv Guetta 2017-08-21 15:58:50 UTC

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/

Comment 14 Michael Bayer 2017-10-02 14:49:15 UTC

*** Bug 1472249 has been marked as a duplicate of this bug. ***

Comment 20 pkomarov 2017-11-05 13:23:59 UTC

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 |
+-------------------------+-----------+

Comment 22 errata-xmlrpc 2017-11-15 13:45:13 UTC

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