[client]
port			= 8661
default-character-set	= utf8
protocol=tcp

[mysqld]
port			= 8661
socket			= /mysql/tmp/mysql.sock
skip-external-locking
skip-name-resolve

key_buffer_size		= 512M
#table_cache		= 64
table_open_cache        = 131072
table_definition_cache  = 131072
max_allowed_packet	= 32M
sort_buffer_size        = 2M
tmp_table_size          = 1M
read_rnd_buffer_size    = 3M
myisam_sort_buffer_size = 1M
lower_case_table_names	= 1
default-storage-engine	= InnoDB
max-connections		= 6000
query_cache_size	= 0
query_cache_type	= 0
character_set_server	= utf8
init-connect='SET NAMES utf8;'
thread_concurrency	= 48
group_concat_max_len	= 16M
delayed_queue_size	= 1000
read_buffer_size	= 4M
thread_cache_size	= 8

tmpdir			= /mysql/tmp
datadir			= /mysql/data
log_error               = /mysql/error.log
pid-file                = /mysql/mysql.pid

federated

innodb_data_home_dir		= /mysql/data/
innodb_data_file_path		= ibdata1:1G:autoextend
innodb_additional_mem_pool_size = 20M
innodb_autoextend_increment	= 200
innodb_buffer_pool_size		= 81920M
innodb_log_buffer_size		= 25M
innodb_log_file_size		= 2000M
innodb_log_files_in_group	= 2
innodb_log_group_home_dir	= /mysql/data
innodb_thread_concurrency	= 40
innodb_flush_log_at_trx_commit	= 0
innodb_lock_wait_timeout	= 120
#DirectIO
#innodb_flush_method=O_DIRECT

# Slow queries logging
#log-slow-queries		= /mysql/logs/slow/slow.log
#long_query_time			= 10

#WSREP

#WSREP Optimization
innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
sync_binlog=0
innodb_flush_log_at_trx_commit=2
innodb_doublewrite=1

# (This must be substituted by wsrep_format)
binlog_format=ROW

# Override bind-address
# In some systems bind-address defaults to 127.0.0.1, and with mysqldump SST
# it will have (most likely) disastrous consequences on donor node
bind-address=0.0.0.0

##
## WSREP options
##

# Full path to wsrep provider library or 'none'
wsrep_provider=/usr/lib/galera/libgalera_smm.so

# Provider specific configuration options
#wsrep_provider_options=

# Logical cluster name. Should be the same for all nodes.
wsrep_cluster_name="dbh"

# Group communication system handle
#wsrep_cluster_address="gcomm://"
wsrep_cluster_address="gcomm://<censored>"

# Human-readable node name (non-unique). Hostname by default.
#wsrep_node_name=

# Base replication <address|hostname>[:port] of the node.
# The values supplied will be used as defaults for state transfer receiving,
# listening ports and so on. Default: address of the first network interface.

# Address for incoming client connections. Autodetect by default.
wsrep_node_incoming_address=<censored>

# How many threads will process writesets from other nodes
wsrep_slave_threads=250

# DBUG options for wsrep provider
#wsrep_dbug_option

# Generate fake primary keys for non-PK tables (required for multi-master
# and parallel applying operation)
wsrep_certify_nonPK=1

# Maximum number of rows in write set
wsrep_max_ws_rows=3000

# Maximum size of write set
wsrep_max_ws_size=5000000

# to enable debug level logging, set this to 1
wsrep_debug=0

# convert locking sessions into transactions
wsrep_convert_LOCK_to_trx=0

# how many times to retry deadlocked autocommits
wsrep_retry_autocommit=0

# change auto_increment_increment and auto_increment_offset automatically
wsrep_auto_increment_control=1

# retry autoinc insert, which failed for duplicate key error
wsrep_drupal_282555_workaround=0

# enable "strictly synchronous" semantics for read operations
wsrep_causal_reads=0
#wsrep_log_conflicts=1

# Command to call when node status or cluster membership changes.
# Will be passed all or some of the following options:
# --status  - new status of this node
# --uuid    - UUID of the cluster
# --primary - whether the component is primary or not ("yes"/"no")
# --members - comma-separated list of members
# --index   - index of this node in the list
wsrep_notify_cmd=

##
## WSREP State Transfer options
##

# State Snapshot Transfer method
wsrep_sst_method=xtrabackup
#wsrep_sst_method=mysqldump
# Address on THIS node to receive SST at. DON'T SET IT TO DONOR ADDRESS!!!
# (SST method dependent. Defaults to the first IP of the first interface)
wsrep_sst_receive_address=<censored>

# SST authentication string. This will be used to send SST to joining nodes.
# Depends on SST method. For mysqldump method it is root:<root password>
wsrep_sst_auth=<censored>

# Desired SST donor name.
#wsrep_sst_donor=

# Reject client queries when donating SST (false)
#wsrep_sst_donor_rejects_queries=0

# Protocol version to use
# wsrep_protocol_version=


[mysqldump]

quick
max_allowed_packet = 16M

[mysql]

no-auto-rehash


[myisamchk]

key_buffer_size			= 256M
sort_buffer_size		= 256M
read_buffer			= 2M
write_buffer			= 2M

[mysqlhotcopy]
interactive-timeout