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