mysqld_multi管理多实例
环境:
centos6.3 x86
kernel:2.6.32-279.el6.x86_64
mysql version:mysql-5.1.61
mysql与mysql2分别挂载两个不同的磁盘
通过socket进行管理每个实例
mysql -uuser -ppassword -S socketpath
启动实例2
mysqld_multi start 2
<注意:每个实例都要对[mysqld_multi]标签中的用户有相关的权限问题,否则mysqld服务通过mysqld_multi是无法启动>
下面是my.cnf的配置
MyISAM引擎
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
user = multi_admin
password = my_password
[mysqld]
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
port = 3306
log-error = /var/lib/mysql/mysql-error.log
user = mysql
log-bin = mysql.bin
max-binlog-size = 512M
key_buffer_size = 128M
table_cache = 1024
sort_buffer_size = 16M
read_buffer_size = 16M
net_buffer_length = 512K
join_buffer_size = 3M
query_cache_size = 15M
query_cache_limit = 15M
query_cache_type = 1
server-id = 1
[mysqld2]
socket = /tmp/mysql.sock2
port = 3307
pid-file = /var/lib/mysql2/hostname.pid2
datadir = /var/lib/mysql2
log-error = /var/lib/mysql2/mysql2-error.log
user = mysql
server-id = 2