mysql多实例配置_mysql多实例配置(非mysqld_multi)

除了可以使用service mysql start启动mysql，还可以自己填写参数，同样可以启动数据库。

且还可以指定如下的选项：

basedir datadir pid-file socket defaults-file，那么是不是可以复制两份分别运行呢？当然是可以的，亲。

注意：初始的mysql是通过mysql源码安装的，这样所有的东西都在一起好打包精简之类的。

复制代码 代码示例:

cp -R /usr/local/mysql /usr/local/mysql1

cp -R /usr/local/mysql /usr/local/mysql2

cp -R /usr/local/mysql /usr/local/mysql3

cp -R /usr/local/mysql /usr/local/mysql4

chown -R mysql.mysql /usr/local/mysql1

chown -R mysql.mysql /usr/local/mysql2

chown -R mysql.mysql /usr/local/mysql3

chown -R mysql.mysql /usr/local/mysql4

复制了4份mysql。

接下来我们针对每份mysql做相应的设置。

1、清空mysql1、2、3、4下data目录用的默认数据库，重建

复制代码 代码示例:

/usr/local/mysql1/scripts/mysql_install_db -basedir=/usr/local/mysql1 --datadir=/usr/local/mysql1/data --user=mysql

/usr/local/mysql2/scripts/mysql_install_db -basedir=/usr/local/mysql2 --datadir=/usr/local/mysql2/data --user=mysql

/usr/local/mysql3/scripts/mysql_install_db -basedir=/usr/local/mysql3 --datadir=/usr/local/mysql3/data --user=mysql

/usr/local/mysql4/scripts/mysql_install_db -basedir=/usr/local/mysql4 --datadir=/usr/local/mysql4/data --user=mysql

2、分别修改mysql中的配置文件

复制代码 代码示例:

vi /usr/local/mysql1/my.cnf

port = 3307

socket =/tmp/mysql3307.sock

vi /usr/local/mysql1/my.cnf

port = 3308

socket =/tmp/mysql3308.sock

vi /usr/local/mysql1/my.cnf

port = 3309

socket =/tmp/mysql3309.sock

vi /usr/local/mysql1/my.cnf

port = 3310

socket =/tmp/mysql3310.sock

确认以上四个端口没有被使用

3、编写启动脚本

复制代码 代码示例:

/usr/local/mysql1/bin/mysqld --defaults-file=/usr/local/mysql1/my.cnf --basedir=/usr/local/mysql1 --datadir=/usr/local/mysql1/data --user=mysql --pid-file=/usr/local/mysql1/data/mysql.pid &

/usr/local/mysql2/bin/mysqld --defaults-file=/usr/local/mysql2/my.cnf --basedir=/usr/local/mysql2 --datadir=/usr/local/mysql2/data --user=mysql --pid-file=/usr/local/mysql2/data/mysql.pid &

/usr/local/mysql3/bin/mysqld --defaults-file=/usr/local/mysql3/my.cnf --basedir=/usr/local/mysql3 --datadir=/usr/local/mysql3/data --user=mysql --pid-file=/usr/local/mysql3/data/mysql.pid &

/usr/local/mysql4/bin/mysqld --defaults-file=/usr/local/mysql4/my.cnf --basedir=/usr/local/mysql4 --datadir=/usr/local/mysql4/data --user=mysql --pid-file=/usr/local/mysql4/data/mysql.pid &

4、分别登陆不同的mysql

复制代码 代码示例:

mysql -S /tmp/mysql3307.socket

mysql -S /tmp/mysql3308.socket

mysql -S /tmp/mysql3309.socket

mysql -S /tmp/mysql3310.socket