openstack
/
tripleo-heat-templates
Code Issues Proposed changes

MySQL Galera backports 

This is a squash of 2 backports to fix Galera deployment on Liberty.

1) Enable galera replication for Mariadb 10.1

The generated galera config has to include additional settings for
galera to be active on MariaDB 10.1.
wsrep_on must be explicitely set to ON. On MariaDB 5.5, this was
implicitely set as soon as wsrep_provider was specified.
a valid wsrep_cluster_address must be configured in addition to
wsrep_on, otherwise recovery command mysqld_safe --wsrep-recover
cannot retrieve replication state, and cluster cannot be bootstrapped.
These explicit settings are backward compatible with MariaDB 5.5 since
the two variables exist in both versions of MariaDB.

Closes-Bug: 1563751
(cherry-picked from commit df343c35ce)

2) [liberty-only] mysql: never add brackets to mysql_bind_host

The patch was submitted in Newton, but we can't backport it:
https://review.openstack.org/#/c/369369/
Don't add brackets on mysql_bind_host parameter in Galera config.
Having brackets from this parameter works with old version of
Galera but not newest one.
EPEL upgraded the version of Galera, so we need this change to deploy
TripleO in HA environment

Closes-Bug: #1622755
(cherry picked from commit 41b85b2671)

Change-Id: I1128c560f00fb3ffee8e072f1874ad7e610ff9e0
This commit is contained in:
Damien Ciabrini 2016-03-30 14:19:39 +02:00 committed by Emilien Macchi
parent fc0bcdec3c
commit ef14f86f5d
1 changed files with 3 additions and 1 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

4
puppet/manifests/overcloud_controller_pacemaker.pp
View File

@ -187,8 +187,10 @@ if hiera('step') >= 1 {
'bind-address' => $::hostname,
'max_connections' => hiera('mysql_max_connections'),
'open_files_limit' => '-1',
'wsrep_on' => 'ON',
'wsrep_provider' => '/usr/lib64/galera/libgalera_smm.so',
'wsrep_cluster_name' => 'galera_cluster',
'wsrep_cluster_address' => "gcomm://${galera_nodes}",
'wsrep_slave_threads' => '1',
'wsrep_certify_nonPK' => '1',
'wsrep_max_ws_rows' => '131072',
@ -200,7 +202,7 @@ if hiera('step') >= 1 {
'wsrep_drupal_282555_workaround'=> '0',
'wsrep_causal_reads' => '0',
'wsrep_sst_method' => 'rsync',
'wsrep_provider_options' => "gmcast.listen_addr=tcp://[${mysql_bind_host}]:4567;",
'wsrep_provider_options' => "gmcast.listen_addr=tcp://${mysql_bind_host}:4567;",
},
}