[MYSQLD] user=mysql basedir=/usr/ datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock pid-file=/var/lib/mysql/mysql.pid port=3306 log_error=/var/log/mysql/mysqld.log log_warnings=2 innodb_buffer_pool_size=185M innodb_flush_log_at_trx_commit=2 innodb_file_per_table=1 innodb_data_file_path = ibdata1:100M:autoextend innodb_read_io_threads=4 innodb_write_io_threads=4 innodb_doublewrite=1 innodb_log_file_size=64M innodb_log_buffer_size=16M innodb_buffer_pool_instances=-1 innodb_log_files_in_group=2 innodb_thread_concurrency=64 innodb_flush_method = O_DIRECT innodb_autoinc_lock_mode=2 innodb_stats_on_metadata=0 default_storage_engine=innodb
# REPLICATION SPECIFIC server_id=2 binlog_format=ROW
# OTHER THINGS, BUFFERS ETC tmp_table_size = 64M max_heap_table_size = 64M max_allowed_packet = 512M
memlock=0 sysdate_is_now=1 max_connections=500 thread_cache_size=512 query_cache_type = 0 query_cache_size = 0 table_open_cache=1024 lower_case_table_names=0
performance_schema = 0 performance-schema-max-mutex-classes = 0 performance-schema-max-mutex-instances = 0
wsrep_provider=/usr/lib/libgalera_smm.so wsrep_on=ON wsrep_node_address=10.10.10.12
wsrep_provider_options="gcache.size=1024M; gmcast.segment=0"
wsrep_cluster_name="my_wsrep_cluster"
wsrep_cluster_address=gcomm://10.10.10.11:4567,10.10.10.12:4567,10.10.10.13:4567
wsrep_node_name=10.10.10.12
wsrep_slave_threads=4
wsrep_certify_nonPK=1
wsrep_max_ws_rows=131072
wsrep_max_ws_size=1073741824
wsrep_debug=0
wsrep_convert_LOCK_to_trx=0
wsrep_retry_autocommit=1
wsrep_auto_increment_control=1
wsrep_replicate_myisam=0
wsrep_drupal_282555_workaround=0
wsrep_causal_reads=0
wsrep_sst_method=xtrabackup-v2
wsrep_sst_auth=backupuser:password
[MYSQL] socket=/var/lib/mysql/mysql.sock
[client] socket=/var/lib/mysql/mysql.sock
[xtrabackup] user=backupuser password=password ssl=0
[MYSQLD] /var/lib/ mysql /var/lib/ mysql/mysql. sock /var/lib/ mysql/mysql. pid /var/log/ mysql/mysqld. log buffer_ pool_size= 185M flush_log_ at_trx_ commit= 2 file_per_ table=1 data_file_ path = ibdata1: 100M:autoextend read_io_ threads= 4 write_io_ threads= 4 doublewrite= 1 log_file_ size=64M log_buffer_ size=16M buffer_ pool_instances= -1 log_files_ in_group= 2 thread_ concurrency= 64 autoinc_ lock_mode= 2 stats_on_ metadata= 0 storage_ engine= innodb
user=mysql
basedir=/usr/
datadir=
socket=
pid-file=
port=3306
log_error=
log_warnings=2
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_flush_method = O_DIRECT
innodb_
innodb_
default_
# REPLICATION SPECIFIC
server_id=2
binlog_format=ROW
# OTHER THINGS, BUFFERS ETC
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 512M
memlock=0 cache_size= 512 cache=1024 table_names= 0
sysdate_is_now=1
max_connections=500
thread_
query_cache_type = 0
query_cache_size = 0
table_open_
lower_case_
performance_schema = 0 schema- max-mutex- classes = 0 schema- max-mutex- instances = 0
performance-
performance-
wsrep_provider= /usr/lib/ libgalera_ smm.so address= 10.10.10. 12
wsrep_on=ON
wsrep_node_
wsrep_provider_ options= "gcache. size=1024M; gmcast.segment=0"
wsrep_cluster_ name="my_ wsrep_cluster"
wsrep_cluster_ address= gcomm:/ /10.10. 10.11:4567, 10.10.10. 12:4567, 10.10.10. 13:4567
wsrep_node_ name=10. 10.10.12
wsrep_slave_ threads= 4
wsrep_certify_ nonPK=1
wsrep_max_ ws_rows= 131072
wsrep_max_ ws_size= 1073741824
wsrep_debug=0
wsrep_convert_ LOCK_to_ trx=0
wsrep_retry_ autocommit= 1
wsrep_auto_ increment_ control= 1
wsrep_replicate _myisam= 0
wsrep_drupal_ 282555_ workaround= 0
wsrep_causal_ reads=0
wsrep_sst_ method= xtrabackup- v2
wsrep_sst_ auth=backupuser :password
[MYSQL] /var/lib/ mysql/mysql. sock
socket=
[client] /var/lib/ mysql/mysql. sock
socket=
[xtrabackup]
user=backupuser
password=password
ssl=0