			[mysqld]
			datadir=/var/lib/mysql
			socket=/var/lib/mysql/mysql.sock
			symbolic-links=0
			sql_mode=STRICT_ALL_TABLES
			max_allowed_packet=33554432
			ft_stopword_file=/srv/stopwords.txt
			ft_min_word_len=3
			ft_boolean_syntax=' \|-><()~*:""&^'
			innodb_buffer_pool_size=1600M
			wsrep_provider=/usr/lib64/galera-3/libgalera_smm.so
			wsrep_cluster_address="gcomm://{{ groups['dbs']\|join(',') }}"
			binlog_format=row
			default_storage_engine=InnoDB
			innodb_autoinc_lock_mode=2
			bind-address=0.0.0.0
			wsrep_cluster_name="{{ mysql_cluster_name }}"
			wsrep_sst_method=rsync
			wsrep_node_address="{{ ansible_eth0.ipv4.address }}"
			wsrep_node_name="{{ ansible_eth0.ipv4.address }}"
			wsrep_provider_options="gcs.fc_limit = 256; gcs.fc_factor = 0.99; gcs.fc_master_slave = yes"
			log-bin="{{ mysql_cluster_name }}"
			log-slave-updates

			[mysqld_safe]
			log-error=/var/log/mysqld.log
			pid-file=/var/run/mysqld/mysqld.pid

c4science/roles/galera/templates/my.cnf
c3bdeff427fcmaster

my.cnf
View Options