Page MenuHomePhorge
Files F117756669

No OneTemporary
Actions

Authored By
Unknown
Size
1 KB
Referenced Files
None
Subscribers
None

View Options

diff --git a/deployments/ansible/roles/kolab-node/files/my.cnf.j2 b/deployments/ansible/roles/kolab-node/files/my.cnf.j2
index e2a20c8..f9c79f7 100644
--- a/deployments/ansible/roles/kolab-node/files/my.cnf.j2
+++ b/deployments/ansible/roles/kolab-node/files/my.cnf.j2
@@ -1,47 +1,47 @@
[galera]
wsrep_on=1
#wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
#wsrep_provider_options="gcache.size=4G; gcache.page_size=4G"
wsrep_cluster_name="kolab"
wsrep_cluster_address="gcomm://{{ primary_ip }},{{ secondary_ip }}"
wsrep_sst_method=rsync
# Temporary change to force the resync donor
#wsrep_sst_donor="hostname"
bind-address={{ bind_address }}
[mysqld]
binlog_format=row
datadir=/data/mysql
default_storage_engine=innodb
innodb_autoinc_lock_mode=2
# Set to ~50% - 75% of available system memory
innodb_buffer_pool_size={{ mariadb_innodb_buffer_pool_size | default('1G') }}
innodb_defragment=1
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=0
-innodb_log_file_size={{ mariadb_innodb_log_file_size | default('256M') }}
-innodb_log_buffer_size={{ mariadb_innodb_log_buffer_size | default('128M') }}
+innodb_log_file_size={{ mariadb_innodb_log_file_size | default('128M') }}
+innodb_log_buffer_size={{ mariadb_innodb_log_buffer_size | default('32M') }}
long_query_time=1
max_allowed_packet=68M
max_connections=512
max_heap_table_size=512M
query_cache_type=1
query_cache_limit=64M
query_cache_min_res_unit=1K
query_cache_size={{ mariadb_query_cache_size | default('128M') }}
slow_query_log=0
slow_query_log_file=/var/log/mariadb/slow.log
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
table_open_cache=1000
thread_cache_size=256
#tmpdir=/var/tmp/mariadb
#tmp_table_size=512M
user=mysql
wait_timeout = 3600
lower_case_table_names = 0
[mysqld_safe]
log-error=/var/log/mariadb/error.log
pid-file=/var/run/mariadb/mariadb.pid

File Metadata

Mime Type
text/x-diff
Expires
Sat, Apr 4, 8:48 AM (2 w, 5 d ago)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
18823320
Default Alt Text
(1 KB)

Event Timeline