my.cnf.local

[mysqld]
socket = /pxc/datadir/pxc.sock
port = 3000
basedir=/pxc
datadir=/pxc/datadir
log_slow_queries        = /pxc/datadir/mysql-slow.log
long_query_time         = 10
loose-log_slow_verbosity = microtime,query_plan,innodb,profiling,profiling_use_getrusage
loose-slow_query_log_timestamp_always = true
loose-slow_query_log_timestamp_precision = microsecond
loose-slow_query_log_use_global_control = log_slow_filter,log_slow_rate_limit,log_slow_verbosity,long_query_time,min_examined_row_limit

#loose-log_slow_slave_statements
#log_slave_updates

#log_bin                 = /pxc/datadir/mysql-bin.log
#max_binlog_size         = 100M
#expire_logs_days        = 2

binlog_format           = ROW
thread_stack            = 256K
thread_cache_size       = 512
tmp_table_size          = 32M
max_heap_table_size     = 32M
max_connections         = 10000
open-files-limit        = 65535
table_open_cache        = 8192
table_definition_cache  = 8192
key_buffer_size         = 64M
innodb_buffer_pool_size         = 500M
innodb_flush_log_at_trx_commit  = 2
innodb_flush_method             = O_DIRECT
innodb_log_files_in_group       = 2
innodb_log_file_size            = 20M
innodb_file_per_table           = 1

#loose-query_response_time_stats
wsrep_sst_receive_address=127.0.0.1:4000
wsrep_node_incoming_address=127.0.0.1
wsrep_cluster_address='gcomm://127.0.0.1:5010,127.0.0.1:6010'
wsrep_provider=/pxc/lib/libgalera_smm.so
#wsrep_max_ws_rows = 768K
#wsrep_max_ws_size = 4G
wsrep_provider_options = "gmcast.listen_addr=tcp://127.0.0.1:4010"
#wsrep_provider_options=""

wsrep_slave_threads=2
wsrep_cluster_name=Archie
wsrep_sst_method=rsync
wsrep_sst_auth = root:test
wsrep_node_name=Arch1

innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
#wsrep_mysql_replication_bundle = 50

[client]
user=root
password=test
socket = /pxc/datadir/pxc.sock


#!include /tmp/test.cnf