Comment 2 for bug 1647340

Revision history for this message
johan (johan-severalnines) wrote :

[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