			[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=48M
			symbolic-links=0
			max_connections=800
			local_infile=0

			ft_stopword_file=/srv/stopwords.txt
			ft_min_word_len=3
			ft_boolean_syntax=' \|-><()~*:""&^'

			innodb_buffer_pool_size=2000M
			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

c4science/roles/mariadb/templates/my.cnf
bb098afff73fmaster

my.cnf
View Options