[mysqld]
#innodb_force_recovery = 4
datadir=/opt/mysql
socket=/opt/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

max_connections = 500

##XtrDB Cluster Settings
binlog_format=ROW
wsrep_cluster_name=spiritCluster
wsrep_cluster_address=gcomm://xxx.xxx.xxx.xxx,n
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_sst_method=xtrabackup-v2
wsrep_node_address=xxx.xxx.xxx.xxx
wsrep_sst_auth=xxx:xxx
innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
server-id=3
innodb_flush_log_at_trx_commit=0
binlog_format=ROW
binlog_cache_size = 1M
binlog_stmt_cache_size = 1M
innodb_buffer_pool_size=80G
innodb_log_file_size=100M
innodb_log_files_in_group=4
log_queries_not_using_indexes=1
wsrep_causal_reads=0


#default-character-set=utf8

#skip-character-set-client-handshake 
#collation_server=utf8_unicode_ci 
character_set_server=utf8

lower_case_table_names=1


# use InnoDB storage engine with file per table option to keep it flexible 
default-storage-engine=InnoDB
innodb_file_per_table
slow_query_log=1
slow_query_log_file=/var/lib/mysql/slow-queries.log

#log-queries-not-using-indexes
long_query_time=1



[mysqld_safe]
log-error=/opt/mysql/mysqld.log
pid-file=/opt/mysql/mysqld.pid

[mysql]
socket=/opt/mysql/mysql.sock

[client]
default-character-set=utf8