[mysqld]
pid_file=/var/run/mysqld.pid
socket=/var/db/mysql/mysql.sock

server-id = 41

#default-storage-engine = InnoDB

# replication (slave)
master-host = pe1
master-user = repl
master-password = XXXXXX
replicate-ignore-db = test
replicate-ignore-db = ccnbench
relay-log = pe2-relay-bin

# binary logs for replication (master)
#max_binlog_size=500M
#log-bin=/var/db/mysql/fs1-binlog
#log-slave-updates

datadir=/var/db/mysql
skip-external-locking
skip-name-resolve
delay-key-write=ALL
myisam-recover=BACKUP,FORCE

max_connections=400

max_allowed_packet=4M
table_cache=1024
thread_cache_size=24
tmp_table_size=150M
max_heap_table_size=150M

# global
key_buffer_size=500M
query_cache_size=200M
query_cache_limit=4M
query_cache_type=1
myisam_sort_buffer_size=32M

# per thread
sort_buffer_size=2M
read_buffer_size=1M
read_rnd_buffer_size=1M


log-slow-queries=/var/db/mysql/slow_queries.log
long_query_time=6
#log-long-format

innodb_buffer_pool_size=1G
innodb_additional_mem_pool_size=500M
innodb_flush_log_at_trx_commit=2
#skip-innodb

#log-warnings

[mysql.server]
basedir=/usr/local/mysql
datadir=/var/db/mysql
pid-file=/var/db/mysql/mysqld.pid
user=mysql

[mysqld_safe]
log-error=/var/log/mysqld.log

[mysqldump]
quick
max_allowed_packet=16M
user=repmgr
password=r3pl!c@t3
socket=/var/db/mysql/mysql.sock

[mysql]
no-auto-rehash
socket=/var/db/mysql/mysql.sock

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout
user=repmgr
password=XXXXXX

[mysqladmin]
socket=/var/db/mysql/mysql.sock