在同一台机运行多个Mysql服务

核心提示： master-user = 'repl'master-password = '1234567890'master-port =3309report-host = net-app1master-connect-retry = 30log-binlog-slav

master-user　　 =　 'repl'

master-password =　 '1234567890'

master-port　　 =　3309

report-host = net-app1

master-connect-retry = 30

log-bin

log-slave-updates

[mysqld2]

port = 3307

socket = /tmp/mysql.sock2

pid-file = /usr/local/mysql/data2/net-app1b.pid

datadir = /usr/local/mysql/data2

log=/usr/local/mysql/data2/net-app1.log

user = mysql

log-slow-queries=/usr/local/mysql/data2/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-updates

[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