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