[mysqld] server-id = 10 log-bin = mysql-bin replicate-same-server-id = 0 auto_increment_increment = 10 auto_increment_offset = 1 master-host = master2.streamtheworld.com master-user = node_DBS01 master-password = ************* report-host = master1 relay-log = master1-relay-bin max_binlog_size = 20M expire_logs_days = 3 binlog_ignore_db = streaming_dev socket = /var/lib/mysql/mysql.sock set-variable = max_connections=3000 set-variable = max_connect_errors=1000 set-variable = thread_cache=5000 set-variable = back_log=500 #sort_buffer_size = 10m #max_allowed_packet = 2000m #table_cache = 512 #tmp_table_size = 100m #myisam_max_sort_file_size = 100g #myisam_max_extra_sort_file_size = 100g #myisam_sort_buffer_size = 80M #key_buffer_size = 1500M #query_cache_size = 100M #bulk_insert_buffer_size = 32M skip-locking skip-name-resolve old-passwords slave-skip-errors=126,1051,1062 log-slow-queries = /var/lib/mysql/mysql-slow.log log-queries-not-using-indexes [mysql.server] #user=mysql #basedir=/var/lib [mysqld_safe] #err-log=/var/log/mysqld.log #pid-file=/var/run/mysqld/mysqld.pid