aboutsummaryrefslogtreecommitdiff
path: root/ansible
diff options
context:
space:
mode:
authorJenkins <jenkins@review.openstack.org>2016-09-14 13:14:26 +0000
committerGerrit Code Review <review@openstack.org>2016-09-14 13:14:26 +0000
commit557c02fe778ebf648753830fd0d42f19a23a021f (patch)
tree946ed1c599062a7bad53aa09c90a8eacc5706718 /ansible
parent119c41cdc4ee70f0fe41bd83ec7ca42de4f81b2a (diff)
parentde0c7801004130fd02baa8bccec40d2a618e4ff5 (diff)
downloadkolla-557c02fe778ebf648753830fd0d42f19a23a021f.tar.gz
kolla-557c02fe778ebf648753830fd0d42f19a23a021f.zip
Merge "Change Mariadb default character set to utf8"
Diffstat (limited to 'ansible')
-rw-r--r--ansible/roles/mariadb/templates/galera.cnf.j210
1 files changed, 10 insertions, 0 deletions
diff --git a/ansible/roles/mariadb/templates/galera.cnf.j2 b/ansible/roles/mariadb/templates/galera.cnf.j2
index 3dcb5f867..3d7eb938e 100644
--- a/ansible/roles/mariadb/templates/galera.cnf.j2
+++ b/ansible/roles/mariadb/templates/galera.cnf.j2
@@ -4,6 +4,12 @@
{#- mariadb will fail to start #}
{%- set wsrep_driver = 'none' if orchestration_engine == 'KUBERNETES' else wsrep_driver %}
+[client]
+default-character-set=utf8
+
+[mysql]
+default-character-set=utf8
+
[mysqld]
bind-address={{ api_interface_address }}
port={{ mariadb_port }}
@@ -14,6 +20,10 @@ binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
+collation-server = utf8_unicode_ci
+init-connect='SET NAMES utf8'
+character-set-server = utf8
+
datadir=/var/lib/mysql/
wsrep_cluster_address=gcomm://{% if (groups['mariadb'] | length) > 1 %}{% for host in groups['mariadb'] %}{{ hostvars[host]['ansible_' + hostvars[host]['api_interface']]['ipv4']['address'] }}:{{ mariadb_wsrep_port }}{% if not loop.last %},{% endif %}{% endfor %}{% endif %}