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

[mysql.server]
user					= mysql

[mysqld_safe]
wsrep_urls				= gcomm://shopstyle-prod-db02-use1.ec2.shopstyle.com:4567,gcomm://shopstyle-prod-db03-use1.ec2.shopstyle.com:4567,gcomm://shopstyle-prod-db04-use1.ec2.shopstyle.com:4567,gcomm://
log-error				= /mysqlroot/log/mysqld.error.log
malloc-lib				= /usr/local/lib/libtcmalloc_minimal.so	# GOOGLE'S TCMALLOC INSTEAD OF SYSTEM MEMORY ALLOCATOR

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

[mysqld]
##  DIRECTORY LAYOUT
datadir					= /mysqlroot/mysql/datadir
tmpdir					= /mysqlroot/mysql/tmpdir

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

##  SLOW QUERY LOG
slow-query-log				= 1
slow-query-log-file			= /var/log/mysql/mysqld_slow.log
long_query_time				= 1				# LOG QUERIES OVER ONE SECOND
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)
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				= 102
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_slave_threads=32
wsrep_sst_method=rsync
# Comment out the above and uncomment below if you want to skip sync.
# wsrep_sst_method=skip
wsrep_cluster_name=shopstyle_aws_prod_cluster
wsrep_node_name=shopstyle-prod-db02-use1.ec2.shopstyle.com
# Since we aren't doing multi-master, this isn't necessary.
wsrep_auto_increment_control=0
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
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, BUT IF RESTORING FROM LVM BACKUP, NEEDS TO THE THE SAME AS THE ORIGINAL


##  MISC GLOBAL OPTIONS
character-set-server			= utf8				# THIS REPLACES "default-character-set"
table_open_cache			= 1200				# HOW MANY TABLES CAN BE SIMULTANEOUSLY OPEN FOR A MYSQL INSTANCE
thread_cache_size			= 16
read_buffer_size			= 512K
read_rnd_buffer_size			= 4M
join_buffer_size			= 2M
#performance_schema							# ENABLE THE PERFORMANCE SCHEMA DB
skip-name-resolve
default-time-zone			 = America/Chicago