PXC config file example

gistfile1.txt

[client]
socket=/data/mysql/mysql.sock


[mysqld_safe]
# connect this node up to the cluster
wsrep_urls              =       gcomm://10.1.6.10:4567,gcomm://10.1.6.11:4567,gcomm://10.1.6.12:4567

[mysqld]

# base server settings
datadir                 =       /data/mysql
socket                  =       /data/mysql/mysql.sock
log-error               =       error.log
skip-name-resolve

back_log                =       1024
max_connections         =       5000
table_cache             =       1024
thread_cache_size       =       32

# timeouts
wait_timeout            =       120  
connect_timeout         =       120
interactive_timeout     =       120

# internal temporary tables
tmpdir                  =       /dev/shm
tmp_table_size          =       64M
max_heap_table_size     =       64M

# no query cache
query_cache_size = 0M
query_cache_type = 0

# slow query log
slow_query_log          =       ON
slow_query_log_file     =       slow.log
long_query_time         =       1
log_slow_verbosity      =       full
slow_query_log_timestamp_always         =       ON
slow_query_log_timestamp_precision      =       microsecond
slow_query_log_use_global_control       =       "log_slow_filter,log_slow_rate_limit,log_slow_verbosity,long_query_time"

# mysql replication settings
server-id               =       10
log-bin
log-slave-updates
binlog_format           =       ROW
# Keep binlog for a maximum of 5 days then flush it (not the current one)
expire_logs_days        = 5


# innodb settings
innodb_buffer_pool_size          =  70G
innodb_buffer_pool_instances     =  8
# monitor with replication and see how the checkpoint age does here
innodb_log_file_size             =  1G 
innodb_flush_log_at_trx_commit   =  2
innodb_flush_method              =  ALL_O_DIRECT
innodb_adaptive_flushing_method  =  keep_average
innodb-file-per-table
innodb_locks_unsafe_for_binlog   =  1
innodb_autoinc_lock_mode         =  2
innodb_file_format               =  Barracuda
innodb_old_blocks_time           =  1000

# ssd tunings
innodb_flush_neighbor_pages      = none
innodb_read_ahead                = none

# galera settings
wsrep_cluster_name              =       mycluster
wsrep_cluster_address           =
wsrep_node_name                 =       db3
wsrep_node_address              =       10.1.6.12
 
wsrep_sst_method                =       xtrabackup
#wsrep_sst_method               =       none
wsrep_sst_auth                  =       sst_user:password
 
wsrep_auto_increment_control    =       OFF #?
wsrep_retry_autocommit          =       1 #?
wsrep_slave_threads             =       16

wsrep_provider                  =       /usr/lib64/libgalera_smm.so
wsrep_provider_options          =       "gcache.size=20G;gcs.fc_factor=0.99;gcs.fc_limit=256;gcs.fc_master_slave=yes"

#wsrep-recover