在同一台机运行多个Mysql服务(下)(4)

文章作者 100test 发表时间 2007:03:14 13:48:01
来源 100Test.Com百考试题网

[mysqld3]
port = 3308
socket = /tmp/mysql.sock3
pid-file = /usr/local/mysql/data3/net-app1c.pid
datadir = /usr/local/mysql/data3
log=/usr/local/mysql/data3/net-app1.log
user = mysql
log-slow-queries=/usr/local/mysql/data3/slowquery.log
long_query_time = 10
key_buffer = 128m
max_allowed_packet = 1m
table_cache = 512
sort_buffer_size = 1m
read_buffer_size = 1m
myisam_sort_buffer_size = 32m
thread_cache = 32
query_cache_size = 16m
thread_concurrency = 2
max_connections=300
server-id = 2
master-host = 192.168.0.100
master-user = ’repl’
master-password = ’1234567890’
master-port = 3309
report-host = net-app1
master-connect-retry = 30
log-bin
log-slave-0updates
[mysqld3]
port = 3308
socket = /tmp/mysql.sock4
pid-file = /usr/local/mysql/data4/net-app1d.pid
datadir = /usr/local/mysql/data4
log=/usr/local/mysql/data4/net-app1.log
user = mysql
log-slow-queries=/usr/local/mysql/data4/slowquery.log
long_query_time = 10
key_buffer = 128m
max_allowed_packet = 1m
table_cache = 512
sort_buffer_size = 1m
read_buffer_size = 1m
myisam_sort_buffer_size = 32m
thread_cache = 32
query_cache_size = 16m
thread_concurrency = 2