redhat 配置mysql_Redhat配置多Mysql实例

申请了两台Redhat虚拟机做cobar的实验，空空如也什么都得装。原来在3个Arch上实现了3个datanode，想在Redhat上每个3个总共配6个Mysql实例。

复制多个实例

在/var/lib目录下找到Mysql目录，将其复制两份，以端口号作后缀以区分：

cp -r /var/lib/mysql /var/lib/mysql3307

cp -r /var/lib/mysql /var/lib/mysql3308

chown -R mysql mysql3307

chown -R mysql mysql3308

配置参数

Mysql的配置文件是/etc/my.cnf,但是默认是没有的，在/usr/share/mysql/目录下有5个.cnf后缀的文件，可以根据自己机器内存大小选择一个文件复制为/etc/my.cnf:

/usr/share/mysql/my-small.cnf 64M内存

/usr/share/mysql/my-medium.cnf 128M内存

/usr/share/mysql/my-large.cnf 512M内存

/usr/share/mysql/my-huge.cnf 1-2G内存

/usr/share/mysql/my-innodb-heavy-4G.cnf 4G内存

我将my-huge.cnf复制为my.cnf。

酌情添加以下配置：

[mysqld_multi]

mysqld = /usr/bin/mysqld_safe

mysqladmin = /usr/bin/mysqladmin

[mysqld1]

port = 3306

socket = /var/lib/mysql/mysql.sock

pid-file = /var/lib/mysql/mysql.pid

datadir = /var/lib/mysql

user = mysql

skip-external-locking

key_buffer_size = 384M

max_allowed_packet = 1M

table_open_cache = 512

sort_buffer_size = 2M

read_buffer_size = 2M

read_rnd_buffer_size = 8M

myisam_sort_buffer_size = 64M

thread_cache_size = 8

query_cache_size = 32M

server-id = 1

[mysqld2]

port = 3307

socket = /var/lib/mysql3307/mysql.sock

pid-file = /var/lib/mysql3307/mysql.pid

datadir = /var/lib/mysql3307

user = mysql

skip-external-locking

key_buffer_size = 384M

max_allowed_packet = 1M

table_open_cache = 512

sort_buffer_size = 2M

read_buffer_size = 2M

read_rnd_buffer_size = 8M

myisam_sort_buffer_size = 64M

thread_cache_size = 8

query_cache_size = 32M

server-id = 1

[mysqld3]

port = 3308

socket = /var/lib/mysql3308/mysql.sock

pid-file = /var/lib/mysql3308/mysql.pid

datadir = /var/lib/mysql3308

user = mysql

skip-external-locking

key_buffer_size = 384M

max_allowed_packet = 1M

table_open_cache = 512

sort_buffer_size = 2M

read_buffer_size = 2M

read_rnd_buffer_size = 8M

myisam_sort_buffer_size = 64M

thread_cache_size = 8

query_cache_size = 32M

server-id = 1

要注意其中的mysqld、mysqladmin后配置的目录参数视具体情况而定。

配置完将3个Mysql都启动：

mysqld_multi start

成功~

如果不能正常远程访问可以查看下防火墙配置和Mysql是否配置远程访问。