[mysql] socket=/mnt/mysql/mysql/mysql.sock [mysqld] max_connections=1000 datadir=/mnt/mysql/mysql tmpdir=/mnt/mysql/tmp socket=/mnt/mysql/mysql/mysql.sock long_query_time=0.4 slow_query_log=1 slow_query_log_file = /var/log/mysql-slow.log log-bin = /mnt/mysql/logs/binarylogs relay-log = db3-relay-bin #this should be same name on both masters skip-name-resolve log-error=/var/log/mysqld.log server-id=1041111039 expire_logs_days = 4 innodb_support_xa = 1 sync-binlog = 0 #Slave Settings skip_slave_start log_slave_updates = 1 read_only = 1 table_open_cache=2048 thread_cache_size=128 open_files_limit=10000 innodb_buffer_pool_size = 24G innodb_log_file_size = 200M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 2 innodb_thread_concurrency = 0 innodb_flush_method=O_DIRECT innodb_file_per_table=1 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [client] socket=/mnt/mysql/mysql/mysql.sock