[client]
default_character_set	    = utf8mb4
port        		    = 3306
socket      		    = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket      = /var/run/mysqld/mysqld.sock
nice        = 0

[mysqld]
log_warnings                    = 1
server-id                       = 2001
character_set_server   		= utf8mb4
collation_server       		= utf8mb4_general_ci
init_connect			= 'SET collation_connection = utf8mb4_general_ci'
init-connect			= 'SET NAMES utf8mb4'
user                            = mysql
pid-file                        = /var/run/mysqld/mysqld.pid
socket                          = /var/run/mysqld/mysqld.sock
port                            = 3306
basedir                         = /usr
datadir                         = /data/mysql/data
tmpdir                          = /data/mysql/tmp
lc-messages-dir                 = /usr/share/mysql
skip-external-locking
skip-character-set-client-handshake
skip_name_resolve               = ON
userstat                        = 1
sync_binlog                     = 0
open_files_limit                = 65535
max_connect_errors              = 100000
optimizer_switch                ='index_merge_intersection=off'
innodb_print_all_deadlocks      = 1
default_time_zone               = '+00:00'

connect_timeout		= 60
max_allowed_packet      = 52M
thread_cache_size       = 39
thread_handling 	= pool-of-threads

query_cache_type        = 0
query_cache_limit       = 0
query_cache_size        = 0

log_error               = /data/mysql/log/mysqlerror.log

slow_query_log          = 1
log_output              = FILE
slow_query_log_file     = /data/mysql/log/mysql-slow.log
long_query_time         = 1

##clustering db configuration
wsrep_on                    = ON
wsrep_provider              = /usr/lib/galera/libgalera_smm.so
wsrep_cluster_name          = galera-test
wsrep_cluster_address       = gcomm://192.168.56.107,192.168.56.108, 192.168.56.109
wsrep_sst_method            = mariabackup
wsrep_sst_auth              = clusteradmin:clusteradmin789
wsrep_node_address          = 192.168.56.107
wsrep_node_name             = node107
wsrep_OSU_method            = TOI
wsrep_slave_threads         = 21
#log_slave_updates           = on
#wsrep_trx_fragment_unit     = statements
#wsrep_trx_fragment_size     = 5

log_bin                     = /data/mysql/log/mysql-bin.log
log_bin_index               = /data/mysql/log/mysql-bin.index
expire_logs_days            = 7
max_binlog_size             = 100M
binlog_format               = ROW
default_storage_engine      = InnoDB
innodb_autoinc_lock_mode    = 2

sql_mode                        = NO_ENGINE_SUBSTITUTION
innodb_buffer_pool_size         = 512M
innodb_log_file_size            = 64M
innodb_log_buffer_size          = 50M
innodb_flush_log_at_trx_commit  = 2
thread_pool_size                = 4
innodb_flush_method             = O_DIRECT

innodb_buffer_pool_dump_at_shutdown     = 1
innodb_buffer_pool_load_at_startup      = 1
innodb_io_capacity                      = 1000
innodb_io_capacity_max                  = 2000

relay_log_recovery              = 1

# for Query Analysis
innodb_monitor_enable	= all
performance_schema	= ON

max_connections            = 10096
extra_max_connections      = 5
max_heap_table_size        = 32M
tmp_table_size             = 32M
sort_buffer_size           = 256K

[mysqldump]
quick
quote-names
max_allowed_packet    = 16M

[mysql]
default_character_set	= utf8mb4

[isamchk]

[xtrabackup]
user=clusteradmin
password=clusteradmin789

[mariadb]
plugin_load_add         	= query_response_time
query_response_time_stats	= 1