# The following options will be passed to all MySQL clients
[client]
#password       = your_password
port            = 3306
#socket          = /tmp/mysql.sock
socket                  = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port            = 3306
#socket          = /tmp/mysql.sock
socket                  = /var/lib/mysql/mysql.sock
skip-locking
set-variable    = key_buffer=64M
#set-variable    = key_buffer=256M
set-variable    = max_allowed_packet=100M
set-variable    = max_connections=1000
set-variable    = table_cache=256
set-variable    = sort_buffer=2M
set-variable    = record_buffer=4M
set-variable    = myisam_sort_buffer_size=64M
set-variable    = net_buffer_length=32K
set-variable    = connect_timeout=14400
set-variable    = thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable    = thread_concurrency=8
log-bin
set-variable    = max_binlog_size=100M
default-table-type=innodb

### IP CONFIG - SLAVE
bind-address=192.168.19.128

### SLAVE CONFIG
#skip-slave-start
master-host=192.168.19.127
master-user=replicate
master-password=removed
master-port=3306
server-id=2


# MySQL Query Caching
query-cache-type = 1
query-cache-size = 60M

set-variable    = ft_min_word_len=3

#set 4/9/04 to fix slave dying
transaction-isolation = READ-COMMITTED

# saves binlog from master locally to chain slaves
#log-slave-updates

# added 12/4/02 - SamS, IPsoft
#innodb_flush_method = O_DSYNC

# SLAVE CONFIGURATION
master-host=192.168.19.127
master-user=replicate
master-password=removed
master-port=3306
server-id=2

innodb_data_home_dir = /usr/local/mysql/data/
#innodb_data_file_path = ibdata1:10M:autoextend:max:2000M
#innodb_data_file_path = ibdata1:2000M;ibdata2:2000M;ibdata3:731906048;ibdata4:2000M
innodb_data_file_path = ibdata1:2000M;ibdata2:2000M;ibdata3:731906048;ibdata4:2000M;ibdata5:5000M;ibdata6:5000M;ibdata7:5000M
innodb_log_group_home_dir = /usr/local/mysql/data/
innodb_log_arch_dir = /usr/local/mysql/data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
set-variable = innodb_buffer_pool_size=512M
set-variable = innodb_additional_mem_pool_size=60M
# Set .._log_file_size to 25 % of buffer pool size
set-variable = innodb_log_file_size=644M
set-variable = innodb_log_buffer_size=64M
innodb_flush_log_at_trx_commit=2
set-variable = innodb_lock_wait_timeout=50

# Point the following paths to different dedicated disks
tmpdir         = /tmp/
#log-update     = /path-to-dedicated-directory/hostname

[mysqldump]
quick
set-variable    = max_allowed_packet=1024M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable    = key_buffer=128M
set-variable    = sort_buffer=128M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

[myisamchk]
set-variable    = key_buffer=128M
set-variable    = sort_buffer=128M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M
set-variable    = ft_min_word_len=3

[mysqlhotcopy]
interactive-timeout