diff options
| author | Jeffrey Zhang <zhang.lei.fly@gmail.com> | 2016-09-05 11:57:23 +0800 |
|---|---|---|
| committer | Jeffrey Zhang <jeffrey.zhang@99cloud.net> | 2016-09-14 02:57:19 +0000 |
| commit | de0c7801004130fd02baa8bccec40d2a618e4ff5 (patch) | |
| tree | 889f02c9a341c4e8cc44ff3437b881483383adbc | |
| parent | b6c40d9deb40404aa83b9e391d12ab1de3eae720 (diff) | |
| download | kolla-de0c7801004130fd02baa8bccec40d2a618e4ff5.tar.gz kolla-de0c7801004130fd02baa8bccec40d2a618e4ff5.zip | |
Change Mariadb default character set to utf8
Closes-Bug: #1623307
Change-Id: I364a8345872ae3b0a7ff684edfe9ff0e22f2c26c
Signed-off-by: Jeffrey Zhang <zhang.lei.fly@gmail.com>
| -rw-r--r-- | ansible/roles/mariadb/templates/galera.cnf.j2 | 10 |
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 %} |