[client]
port=3306
socket=/mysqlroot/socket/mysqld.sock

[mysql.server]
user					= mysql

[mysqld_safe]
log-error				= /mysqlroot/log/mysqld.error.log
malloc-lib				= /usr/local/lib/libtcmalloc_minimal.so	# GOOGLE'S TCMALLOC INSTEAD OF SYSTEM MEMORY ALLOCATOR
core-file
core-file-size                          = 100000000000

[mysqladmin]
socket					= /mysqlroot/socket/mysqld.sock

[mysqld]
##  DUMP A CORE FILE ON CRASH
core-file

##  DIRECTORY LAYOUT
datadir					= /mysqlroot/mysql/datadir
tmpdir					= /mysqlroot/mysql/tmpdir

##  LISTENING / CONNECTIONS
socket					= /mysqlroot/socket/mysqld.sock
max_connections				= 1024
max_user_connections			= 1024
max_connect_errors			= 99999999
skip-name-resolve

##  SLOW QUERY LOG
slow-query-log				= 1
slow-query-log-file			= /mysqlroot/mysql/slowlog/mysqld_slow.log
long_query_time				= 0				# LOG ALL QUERIES, SUBJECT TO RATE LIMITING BELOW
log_slow_verbosity			= full				# LOG AS MUCH DETAIL AS WE CAN, INCLUDING QUERY PLAN, ETC.
log_slow_rate_limit			= 250				# LOG EVERY NTH SESSION (1 = ALL)
slow_query_log_timestamp_precision 	= microsecond			# ENABLE MICROSECOND LEVEL PRECISION FOR QUERY TIME
# log_slow_filter				= full_scan,full_join,tmp_table,tmp_table_on_disk,filesort,filesort_on_disk
# log-queries-not-using-indexes						# THIS WILL LOG QUERIES THAT HAVE DATA THAT ISN'T COVERED BY INDEXES

##  REPLICATION
server-id				= 202
binlog_format				= ROW
log-bin					= /mysqlroot/mysql/binlog/mysql-bin
relay_log				= /mysqlroot/mysql/relaylog/relay.log
relay_log_index				= /mysqlroot/mysql/relaylog/relay.index
relay_log_info_file			= /mysqlroot/mysql/relaylog/relay.info
read_only				= 0				# SLAVES START IN READ-ONLY MODE
									# TO PREVENT MIS-CONFIGURED SYSTEMS FROM WRITING TO THEM
									# COMMENT THIS OUT WHEN YOU CHANGE THIS SYSTEM TO WRITE-MASTER
log_slave_updates
skip-slave-start
log_bin_trust_function_creators		= 1				# NECESSARY FOR RUNNING MIGRATE USING NON-ROOT ACCOUNT

##  Percona XtraDB Cluster config
wsrep_provider				= /usr/lib64/libgalera_smm.so
wsrep_provider_options			= 'gcache.size=10G; gcs.sync_donor=1; gcs.max_packet_size=64500; evs.send_window=512; evs.user_send_window=512'
wsrep_cluster_address			= gcomm://sugarproddb01.sugarops.com:4567
wsrep_slave_threads			= 32
#wsrep_sst_method			= rsync
wsrep_sst_method			= xtrabackup
wsrep_sst_auth				= root:password
# Comment out the above and uncomment below if you want to skip sync.
# wsrep_sst_method			= skip
wsrep_cluster_name			= sugar_aws_prod_cluster
wsrep_node_name				= sugarproddb02.sugarops.com
# Turn these up to try and avoid crashes
wsrep_max_ws_rows                       = 1048576
wsrep_max_ws_size			= 2G
default_storage_engine			= InnoDB
innodb_autoinc_lock_mode		= 2
innodb_locks_unsafe_for_binlog		= 1

##  MYISAM
key_buffer_size				= 16M

##  MEMORY TABLES
max_heap_table_size			= 64M
tmp_table_size				= 64M

##  QUERY CACHE
#query_cache_type			= 1
query_cache_type			= 0
#query_cache_size			= 32M
#query_cache_limit			= 2M				# DEFAULT IS 1MB, AND THAT IS WHAT WE HAD ON SSDB6/5.0

##  INNODB
# These don't work with Percona Cluster
# innodb_log_group_home_dir		= /mysqlroot/mysql/innodb
# innodb_data_home_dir			= /mysqlroot/mysql/innodb
default-storage-engine			= innodb
innodb_file_per_table
innodb_thread_concurrency		= 0
innodb_thread_sleep_delay		= 0
innodb_buffer_pool_size			= 48G				# THIS IS DIVIDED UP AMONG THE MULTIPLE BUFFER POOL INSTANCES
innodb_buffer_pool_instances		= 4				# THIS IS SUPPOSEDLY A MAJOR PERFORMANCE PARAMETER FOR 5.5
innodb_additional_mem_pool_size		= 48M
innodb_log_buffer_size			= 16M
sync_binlog				= 1
innodb_flush_method			= ALL_O_DIRECT
innodb_purge_threads			= 1				# USE SEPARATE THREAD FOR OLD RECORD PURGING
innodb_lock_wait_timeout		= 50
innodb_data_file_path			= ibdata1:10M:autoextend
innodb_log_files_in_group		= 2
innodb_log_file_size			= 4G
innodb_io_capacity			= 20000				# MUCH HIGHER FOR SSDS
innodb_write_io_threads			= 64				# NUMBER OF SPINDLES
innodb_read_io_threads			= 64				# NUMBER OF SPINDLES
innodb_adaptive_flushing_method		= keep_average			# FOR SSDS
innodb_read_ahead			= none				# FOR SSDS
innodb_flush_neighbor_pages		= 0				# FOR SSDS
innodb_flush_log_at_trx_commit		= 2				# FOR SSDS
innodb_log_block_size			= 4096				# FOR SSDS


##  MISC GLOBAL OPTIONS
character-set-server			= utf8				# THIS REPLACES "default-character-set"
table_open_cache			= 8192				# HOW MANY TABLES CAN BE SIMULTANEOUSLY OPEN FOR A MYSQL INSTANCE
table_definition_cache			= 8192
read_buffer_size			= 512K
read_rnd_buffer_size			= 4M
join_buffer_size			= 2M
thread_cache_size			= 512
connect_timeout				= 5
wait_timeout				= 15
myisam_sort_buffer_size			= 32M
max_allowed_packet			= 32M
#performance_schema							# ENABLE THE PERFORMANCE SCHEMA DB
skip-name-resolve