diff --git a/roles/galera/templates/my.cnf b/roles/galera/templates/my.cnf index dfe1acd..7e43ab0 100644 --- a/roles/galera/templates/my.cnf +++ b/roles/galera/templates/my.cnf @@ -1,24 +1,27 @@ [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock -symbolic-links=0 +default_storage_engine=InnoDB +bind-address=0.0.0.0 sql_mode=STRICT_ALL_TABLES max_allowed_packet=64M +symbolic-links=0 + ft_stopword_file=/srv/stopwords.txt ft_min_word_len=3 ft_boolean_syntax=' |-><()~*:""&^' + innodb_buffer_pool_size=1600M innodb_log_file_size=48M -binlog_format=MIXED -default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 innodb_flush_log_at_trx_commit=0 -bind-address=0.0.0.0 + +server_id={{ ansible_hostname[-1:]|int+1 }} log-bin="{{ mysql_cluster_name }}" -log-slave-updates +log_slave_updates=0 +binlog_format=MIXED sync_binlog=0 -server_id={{ ansible_hostname[-1:]|int+1 }} [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mariadb/mysqld.pid