[mysqld]
server_id=1
log-bin
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /data/mysql
tmpdir          = /data/tmp

collation-server        = utf8_unicode_ci
init-connect            ='SET NAMES utf8'
character-set-server    = utf8

lc-messages-dir = /usr/share/mysql
skip-external-locking
skip-name-resolve
log-basename=sql2

default_storage_engine                  = InnoDB
binlog_format                           = ROW
query_cache_size                        = 0
performance_schema                      = 0
max_allowed_packet                      = 64M
max_connections                         = 10000
aria_block_size                         = 8192

tmp_table_size                          = 2000000000
max_heap_table_size                     = 2000000000

join_buffer_space_limit = 300M
join_buffer_size = 100M

innodb_read_io_threads                  = 64
innodb_write_io_threads                 = 64
innodb_use_sys_malloc                   = 500
innodb_buffer_pool_size                 = 50G
innodb_flush_method                     = O_DIRECT
innodb_flush_log_at_trx_commit          = 0
innodb_thread_concurrency               = 0
innodb_buffer_pool_instances            = 32
innodb_autoinc_lock_mode                = 2
innodb_doublewrite                      = 1
innodb_file_per_table                   = 1
innodb_log_file_size                    = 512M
innodb_io_capacity                      = 5000
innodb_io_capacity_max                  = 10000

thread_stack                            = 256K
thread_cache_size                       = 5000
table_cache                             = 8192
table_open_cache                        = 65536
table_definition_cache                  = 262144
key_buffer_size                         = 32M
sort_buffer_size                        = 4M
net_buffer_length                       = 32K
read_buffer_size                        = 1M
read_rnd_buffer_size                    = 8M

wsrep_max_ws_rows                       = 262144
wsrep_max_ws_size                       = 2147483648

innodb_force_recovery                   = 0
expire_logs_days                        = 2
lock_wait_timeout                       = 60

wait_timeout                            = 28800
wsrep_retry_autocommit                  = 1

wsrep_on=ON
wsrep_sync_wait = 1
wsrep_log_conflicts=ON
wsrep_slave_threads=16
query_cache_size=0
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
query_cache_type=0
bind-address=0.0.0.0

wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_provider_options="gcache.size=32G; gcache.page_size=1G"
wsrep_cluster_name="cluster"
wsrep_cluster_address="gcomm://192.168.201.39,192.168.201.40,192.168.201.41"
wsrep_sst_method=rsync
wsrep_node_address="192.168.201.40"
wsrep_node_name="sql2"