单机环境下安装多个MySQL服务器

2014-11-24 18:34:54 · 作者: · 浏览: 1

Step1:


安装数据库:


./configure --prefix=/usr/local/mysql-master


make && make install


./configure --prefix=/usr/local/mysql-slave


make && make install



Step2:从源代码文件的support-files文件夹中拷贝两份my_small.cnf文件,放到/etc文件夹下,分别命名为my-master.cnf,my-slave.cnf


Step3:修改这两个配置文件的mysqld部分,例如我的配置文件如下:


my-master.cnf:



port = 3306


socket = /tmp/mysql.sock


skip-locking


key_buffer = 16K


max_allowed_packet = 1M


table_cache = 4


sort_buffer_size = 64K


read_buffer_size = 256K


read_rnd_buffer_size = 256K


net_buffer_length = 2K


thread_stack = 128K


pid-file = /var/run/mysqld/mysqld.pid



server-id = 1


log-bin=mysql-bin



my-slave.cnf:



port = 3307


socket = /tmp/mysql2.sock


skip-locking


key_buffer = 16K


max_allowed_packet = 1M


table_cache = 4


sort_buffer_size = 64K


read_buffer_size = 256K


read_rnd_buffer_size = 256K


net_buffer_length = 2K


thread_stack = 128K


pid-file = /var/run/mysqld/mysqld2.pid



server-id = 2



Step4:分别对两个服务器执行


sudo ./mysql_install_db --defaults-file=/etc/my-master.cnf


sudo ./mysql_install_db --defaults-file=/etc/my-slave.cnf



Step5:修改数据目录权限,chown mysql:mysql -R var


Step6:创建pid文件目录,并修改权限


sudo mkdir /var/run/mysqld


sudo chgrp mysql /var/run/mysqld


sudo chmod g+w /var/run/mysqld



最后分别运行相应的服务器,例如mysql-master:


./mysqld-safe --defaults-file=/etc/my-master.cnf


运行客户端


./mysql --defaults-file=/etc/my-master.cnf



当然,我们也可以把相应的服务器启动语句写入到脚本里,一次启动两个服务器