Currently when adding some tuning options via hiera, galera won't start because
overriding even a single mysql option will reset the whole key in the hash. So
for example, when adding: tripleo::profile::base::database::mysql::mysql_server_options:
mysqld:
# MySQL InnoDB equally divided in 1GB instances innodb_buffer_pool_instances: 2
# Query network write timeout raised to 120 seconds net_write_timeout: 120
# Query network read timeout raised to 120 seconds net_read_timeout: 120
# MySQL connection timeout set to 8 hours connect_timeout: 28800
Things will break because all the wsrep options that are set normally will be
overridden and galera will refuse to start
Tested by passing the above hiera keys and observing the deploy complete
successfully and the settings correctly applied to galera/mysql on the overcloud.
Reviewed: https:/ /review. opendev. org/688514 /git.openstack. org/cgit/ openstack/ puppet- tripleo/ commit/ ?id=7e78ebdc0f3 678afddea3bdab2 007c7b6ac92776
Committed: https:/
Submitter: Zuul
Branch: master
commit 7e78ebdc0f3678a fddea3bdab2007c 7b6ac92776
Author: Michele Baldessari <email address hidden>
Date: Mon Oct 14 19:19:51 2019 +0200
Deep merge hiera keys for mysqld_options
Currently when adding some tuning options via hiera, galera won't start because
tripleo: :profile: :base:: database: :mysql: :mysql_ server_ options:
innodb_ buffer_ pool_instances: 2
net_ write_timeout: 120
net_ read_timeout: 120
connect_ timeout: 28800
overriding even a single mysql option will reset the whole key in the hash. So
for example, when adding:
mysqld:
# MySQL InnoDB equally divided in 1GB instances
# Query network write timeout raised to 120 seconds
# Query network read timeout raised to 120 seconds
# MySQL connection timeout set to 8 hours
Things will break because all the wsrep options that are set normally will be
overridden and galera will refuse to start
Tested by passing the above hiera keys and observing the deploy complete
successfully and the settings correctly applied to galera/mysql on the overcloud.
Change-Id: I30f03bc8eb81db 0243c137d4af089 24adeebc951
Closes-Bug: #1848060