Update mariadb confs and ports

Cleanup all options in galera.cnf. Bind to all interfaces and ports
appropriately.

Change-Id: I516613d09673ba61aadda2c7bbb4abbbe4ea47ac
Partially-Implements: blueprint update-configs
Closes-Bug: #1478330

6 files changed, 18 insertions, 12 deletions

diff --git a/ansible/roles/bootstrap.yml b/ansible/roles/bootstrap.yml
index 84799d7d8..d3fdd8354 100644
--- a/ansible/roles/bootstrap.yml
+++ b/ansible/roles/bootstrap.yml
@@ -3,6 +3,7 @@
   command: docker exec -t kolla_ansible /usr/bin/ansible localhost
     -m mysql_db
     -a "login_host='{{ database_address }}'
+        login_port='{{ mariadb_port }}'
         login_user='{{ database_user }}'
         login_password='{{ database_password }}'
         name='{{ service_database_name }}'"
@@ -15,6 +16,7 @@
   command: docker exec -t kolla_ansible /usr/bin/ansible localhost
     -m mysql_user
     -a "login_host='{{ database_address }}'
+        login_port='{{ mariadb_port }}'
         login_user='{{ database_user }}'
         login_password='{{ database_password }}'
         name='{{ service_database_name }}'
diff --git a/ansible/roles/haproxy/templates/haproxy.cfg.j2 b/ansible/roles/haproxy/templates/haproxy.cfg.j2
index 57a2ab542..257989bd3 100644
--- a/ansible/roles/haproxy/templates/haproxy.cfg.j2
+++ b/ansible/roles/haproxy/templates/haproxy.cfg.j2
@@ -16,13 +16,11 @@ defaults
 
 listen mariadb
   mode tcp
-  option mysql-check user haproxy
   option tcpka
-
-  # TODO(SamYaple): Make DB port configurable throughout Ansible
-  bind {{ kolla_internal_address }}:3306
+  option mysql-check user haproxy
+  bind {{ kolla_internal_address }}:{{ mariadb_port }}
 {% for host in groups['mariadb'] %}
-  server {{ hostvars[host]['ansible_hostname'] }} {{ hostvars[host]['ansible_' + api_interface]['ipv4']['address'] }}:3306 check inter 2000 rise 2 fall 5 {% if not loop.first %}backup{% endif %}
+  server {{ hostvars[host]['ansible_hostname'] }} {{ hostvars[host]['ansible_' + api_interface]['ipv4']['address'] }}:{{ mariadb_port }} check inter 2000 rise 2 fall 5 {% if not loop.first %}backup{% endif %}
 
 {% endfor %}
 
diff --git a/ansible/roles/keystone/tasks/bootstrap.yml b/ansible/roles/keystone/tasks/bootstrap.yml
index 91485a3cc..bad18ed19 100644
--- a/ansible/roles/keystone/tasks/bootstrap.yml
+++ b/ansible/roles/keystone/tasks/bootstrap.yml
@@ -3,6 +3,7 @@
   command: docker exec -t kolla_ansible /usr/bin/ansible localhost
     -m mysql_db
     -a "login_host='{{ database_address }}'
+        login_port='{{ mariadb_port }}'
         login_user='{{ database_user }}'
         login_password='{{ database_password }}'
         name='{{ keystone_database_name }}'"
@@ -15,6 +16,7 @@
   command: docker exec -t kolla_ansible /usr/bin/ansible localhost
     -m mysql_user
     -a "login_host='{{ database_address }}'
+        login_port='{{ mariadb_port }}'
         login_user='{{ database_user }}'
         login_password='{{ database_password }}'
         name='{{ keystone_database_name }}'
diff --git a/ansible/roles/mariadb/defaults/main.yml b/ansible/roles/mariadb/defaults/main.yml
index cb0ddbd9b..93564bb47 100644
--- a/ansible/roles/mariadb/defaults/main.yml
+++ b/ansible/roles/mariadb/defaults/main.yml
@@ -4,7 +4,7 @@ project_name: "mariadb"
 ####################
 # Database
 ####################
-database_cluster_name: "kolla"
+database_cluster_name: "openstack"
 
 
 ####################
diff --git a/ansible/roles/mariadb/tasks/register.yml b/ansible/roles/mariadb/tasks/register.yml
index 5462aa4ce..4e6e7e42d 100644
--- a/ansible/roles/mariadb/tasks/register.yml
+++ b/ansible/roles/mariadb/tasks/register.yml
@@ -18,6 +18,7 @@
   command: docker exec -t kolla_ansible /usr/bin/ansible localhost
     -m mysql_user
     -a "login_host='{{ hostvars[inventory_hostname]['ansible_' + api_interface]['ipv4']['address'] }}'
+        login_port='{{ mariadb_port }}'
         login_user='{{ database_user }}'
         login_password='{{ database_password }}'
         name='haproxy'
diff --git a/ansible/roles/mariadb/templates/galera.cnf.j2 b/ansible/roles/mariadb/templates/galera.cnf.j2
index 271d12d7e..c44bce951 100644
--- a/ansible/roles/mariadb/templates/galera.cnf.j2
+++ b/ansible/roles/mariadb/templates/galera.cnf.j2
@@ -1,17 +1,20 @@
 [mysqld]
 bind-address={{ hostvars[inventory_hostname]['ansible_' + api_interface]['ipv4']['address'] }}
+port={{ mariadb_port }}
+
 binlog_format=ROW
 default-storage-engine=innodb
 innodb_autoinc_lock_mode=2
-query_cache_size=0
-query_cache_type=0
-innodb_log_file_size=48M
 
-wsrep_provider=/usr/lib64/galera/libgalera_smm.so
-wsrep_cluster_address=gcomm://{% if (groups['mariadb'] | length) > 1 %}{% for host in groups['mariadb'] %}{{ hostvars[host]['ansible_hostname'] }}{% if not loop.last %},{% endif %}{% endfor %}{% endif %}
+wsrep_cluster_address=gcomm://{% if (groups['mariadb'] | length) > 1 %}{% for host in groups['mariadb'] %}{{ hostvars[host]['ansible_' + api_interface]['ipv4']['address'] }}:{{ mariadb_wsrep_port }}{% if not loop.last %},{% endif %}{% endfor %}{% endif %}
+
+wsrep_provider_options="gmcast.listen_addr=tcp://{{ hostvars[inventory_hostname]['ansible_' + api_interface]['ipv4']['address'] }}:{{ mariadb_wsrep_port }};ist.recv_addr={{ hostvars[inventory_hostname]['ansible_' + api_interface]['ipv4']['address'] }}:{{ mariadb_ist_port }}"
 
+wsrep_node_address={{ hostvars[inventory_hostname]['ansible_' + api_interface]['ipv4']['address'] }}:{{ mariadb_wsrep_port }}
+wsrep_sst_receive_address={{ hostvars[inventory_hostname]['ansible_' + api_interface]['ipv4']['address'] }}:{{ mariadb_sst_port }}
+
+wsrep_provider=/usr/lib64/galera/libgalera_smm.so
 wsrep_cluster_name="{{ database_cluster_name }}"
-wsrep_node_address={{ hostvars[inventory_hostname]['ansible_' + api_interface]['ipv4']['address'] }}
 wsrep_node_name={{ ansible_hostname }}
 wsrep_sst_method=xtrabackup-v2
 wsrep_sst_auth={{ database_user }}:{{ database_password }}