aboutsummaryrefslogtreecommitdiff
path: root/ansible/roles/mariadb/templates/galera.cnf.j2
diff options
context:
space:
mode:
Diffstat (limited to 'ansible/roles/mariadb/templates/galera.cnf.j2')
-rw-r--r--ansible/roles/mariadb/templates/galera.cnf.j257
1 files changed, 0 insertions, 57 deletions
diff --git a/ansible/roles/mariadb/templates/galera.cnf.j2 b/ansible/roles/mariadb/templates/galera.cnf.j2
deleted file mode 100644
index d74c74f29..000000000
--- a/ansible/roles/mariadb/templates/galera.cnf.j2
+++ /dev/null
@@ -1,57 +0,0 @@
-{%- set wsrep_driver = '/usr/lib/galera/libgalera_smm.so' if kolla_base_distro == 'ubuntu' else '/usr/lib64/galera/libgalera_smm.so' %}
-
-{#- Disable Galera in the case of of Kubernetes as its not supported yet. Otherwise, #}
-{#- 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 }}
-
-log-error=/var/log/kolla/mariadb/mariadb.log
-
-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 %}
-
-wsrep_provider_options=gmcast.listen_addr=tcp://{{ api_interface_address }}:{{ mariadb_wsrep_port }};ist.recv_addr={{ api_interface_address }}:{{ mariadb_ist_port }}
-
-wsrep_node_address={{ api_interface_address }}:{{ mariadb_wsrep_port }}
-wsrep_sst_receive_address={{ api_interface_address }}:{{ mariadb_sst_port }}
-
-wsrep_provider={{ wsrep_driver }}
-wsrep_cluster_name="{{ database_cluster_name }}"
-wsrep_node_name={{ ansible_hostname }}
-wsrep_sst_method=xtrabackup-v2
-wsrep_sst_auth={{ database_user }}:{{ database_password }}
-wsrep_slave_threads=4
-wsrep_notify_cmd=/usr/local/bin/wsrep-notify.sh
-
-max_connections=10000
-
-key_buffer_size = '64M'
-max_heap_table_size = '64M'
-tmp_table_size = '64M'
-{% set dynamic_pool_size_mb = (hostvars[inventory_hostname]['ansible_memtotal_mb'] * 0.4) | round | int %}
-{% if dynamic_pool_size_mb < 8192 %}
-innodb_buffer_pool_size = '{{ dynamic_pool_size_mb }}M'
-{% else %}
-innodb_buffer_pool_size = '8192M'
-{% endif %}
-
-[server]
-pid-file=/var/lib/mysql/mariadb.pid