###
#
# MAKE CHANGES TO THIS FILE to overwrite /etc/my.cnf
# or to add any new settings.
#
###
[mysql]
# Prompt that shows 'user@host (default database) mysql> ' prompt.
# Can be commented out if you like the old 'mysql> ' prompt.
prompt='\u@\h (\d) mysql> '

[mysqld]
# If this server is using replication, this needs to be set. The current
# trend I have seen is use the last two octets. (e.g. 192.168.162.101
# server-id=162101)
server-id=162077

# When you run SHOW SLAVE HOSTS on the master, this will be the name displayed.
# uncomment and customize if this is a replicate db.
report-host=db2-billing.prod.stl.cw

# Enable these settings for a master MySQL instance.
sync_binlog=1
innodb_flush_log_at_trx_commit=1
innodb_support_xa=1

# If this server is a replicant of one system and a master of another,
# use this option.
log_slave_updates

# We need to get to a point where all replicants use this. It prevents
# users from doing writes on a replicant.
#read_only

# Will disable automatic restart of replication on MySQL start.
# It is recommended that we use this. Uncomment this lines for slave.
skip_slave_start

# Do not use 'replicate_wild_ignore_table=mysql.%' it will prevent
# events and routines from replicating. Uncomment these lines for slave.
replicate_ignore_table=mysql.columns_priv
replicate_ignore_table=mysql.db
replicate_ignore_table=mysql.host
replicate_ignore_table=mysql.procs_priv
replicate_ignore_table=mysql.tables_priv
replicate_ignore_table=mysql.user
#replicate_ignore_table=MAATKIT.backupset
#replicate_ignore_table=MAATKIT.checksum
#replicate_ignore_table=MAATKIT.deadlocks

# If the server is a replicant, this should be uncommented.
relay-log=relay-bin

# If this server is a master, this should be uncommented.
expire_logs_days=5

# Below are the default locations for data directories for MySQL. If you
# need to change the location of the databases or the innodb files, this
# is the place to make the changes.
datadir=/var/lib/mysql/data
innodb_data_home_dir=/var/lib/mysql/data
innodb_log_group_home_dir=/var/lib/mysql/data

# Change this setting to reflect 50%-85% of memory usable by MySQL.
# On 32-bit systems the maximum we use is 2G.
#20090114#innodb_buffer_pool_size=2G
innodb_buffer_pool_size=8192M

innodb_file_per_table=1

max_connect_errors=250
max_connections=2000
sql_mode=NO_AUTO_CREATE_USER
table_open_cache=8192
innodb_additional_mem_pool_size=256M
query_cache_limit=4194304
query_cache_type=1
query_cache_size=67108864

#slave_skip_errors=all

thread_cache_size=100