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

核心提示： max_connections=300log-binlog-bin=/usr/local/mysql/data2/app-net1_2-binserver-id = 1[mysqld3]port = 3308socket = /tmp/mysql.sock3skip-lockingpid-

max_connections=300

log-bin

log-bin=/usr/local/mysql/data2/app-net1_2-bin

server-id　　　 = 1

[mysqld3]

port = 3308

socket = /tmp/mysql.sock3

skip-locking

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-bin

log-bin=/usr/local/mysql/data3/app-net1_3-bin

server-id　　　 = 1

[mysqld4]

port　　　　　　= 3309

socket　　　　　= /tmp/mysql.sock4

skip-locking

pid-file = /usr/local/mysql/data1/app-net1d.pid

datadir = /usr/local/mysql/data1

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

user = mysql

log-bin

log-bin=/usr/local/mysql/data1/app-net1_4-bin

server-id　　　= 1

[mysqldump]

quick

max_allowed_packet = 16M

[mysql]

no-auto-rehash

# Remove the next comment character if you are not familiar with SQL

#safe-updates

[isamchk]

key_buffer = 128M

sort_buffer_size = 128M

read_buffer = 2M

write_buffer = 2M

[myisamchk]

key_buffer = 128M

sort_buffer_size = 128M

read_buffer = 2M

write_buffer = 2M

[mysqlhotcopy]

interactive-timeout

启动多mysql服务都是相同的,

db-app:/ # /usr/local/mysq/bin/mysqld_multi　 --config-file=/etc/my.cnf start 1-4