[mysqld] datadir=/db_slave/data socket=/tmp/mysql_slave.sock user=mysql #bind-address=202.144.72.125 #bind-address=192.168.124.105 #bind-address=0.0.0.0 port=3307 #innodb_buffer_pool_size=25G #innodb_flush_method=O_DIRECT query_cache_type=1 query_cache_size=128M query_cache_limit=4M max_connections=100 general_log=1 general_log_file=/db_slave/log/query.log slow_query_log_file=/db_slave/log/slow.log log-error=/db_slave/log/error.log ### Slave Configuration ### read-only=1 server-id=2 relay-log=db-relay-bin #skip-slave-start ### end ###