[mysqld]
#primary
datadir=/mnt/db/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql

# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

bind-address = 0.0.0.0

skip-name-resolve

key_buffer = 384M
table_cache = 256
sort_buffer_size = 8M
read_buffer_size = 2M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
#Try number of CPU’s*2 for thread_concurrency
thread_concurrency = 8
innodb_buffer_pool_size = 12G
innodb_additional_mem_pool_size = 20M

log-bin = /mnt/db/mysql/mysql-bin.log
expire_logs_days        = 10
max_binlog_size         = 100M
sync_binlog=1

relay-log = /mnt/db/tmp/mysql/relay.log
relay-log-info-file = /mnt/db/tmp/mysql/relay-log.info
relay-log-index = /mnt/db/tmp/mysql/relay-log.index

binlog-do-db=ph_production  # input the database which should be replicated
binlog-do-db=main_june
binlog-do-db=main_beta
#binlog-do-db=platphorm_test
binlog-ignore-db=mysql      # input the database that should be ignored for replication
binlog-ignore-db=test

server-id=1

#information for becoming slave.
master-host = 10.209.109.171
master-user = replication
master-password = slave2
master-port = 3306

auto_increment_increment= 2
auto_increment_offset   = 1

innodb_lock_wait_timeout = 500

# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
ssl-ca=/etc/mysql/ca-cert.pem
ssl-cert=/etc/mysql/server-cert.pem
ssl-key=/etc/mysql/server-key.pem

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysql.server]
user=mysql
basedir=/var/lib