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

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

第二部分,　在一台服务器构建多mysql主 服务.

提示:建立一个帐号,专门用于下面主从复制,本例用的的帐号repl, 口令为:’1234567890’, 可让其拥有0select_priv, reload_priv,process_priv,grant_priv,super_priv,repl_slave_priv,repl_client_priv 权限，并能通过任何客户进行访问,即访问客户为’%’。
主要是修改my.cnf中的内容,让每个mysql生成自己的bin-log文件及各自的运行环境，现贴上我的my.cnf全部内容,相关参数与请参考mysql 官文手册.
#[client]
#password = your_password
#port = 3306
#socket = /tmp/mysql.sock

[mysqld_multi]
mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin
user = mysql
password = mypasswd
[mysqld1]
port = 3306
socket = /tmp/mysql.sock1
skip-locking
pid-file=/usr/local/mysql/data/net-app1a.pid
datadir = /usr/local/mysql/data
log=/usr/local/mysql/data/net-app1.log
user = mysql
log-slow-queries=/usr/local/mysql/data/slowquery.log
long_query_time = 2
key_buffer = 256m
max_allowed_packet = 1m
table_cache = 512
sort_buffer_size = 2m
read_buffer_size = 2m
myisam_sort_buffer_size = 64m
thread_cache = 32
query_cache_size = 32m
thread_concurrency = 2
max_connections=500
log-bin
log-bin=/usr/local/mysql/data/app-net1_1-bin
server-id = 1
[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
log-bin