第一步:正常安装这里就不说了,不懂得看下这篇文章
https://www.csdcb.cn/article/259.html


第二部:创建目录
mkdir -p /opt/extdata/mysql/3307/data /opt/extdata/mysql/3308/data /opt/extdata/mysql/3309/data /opt/extdata/mysql/3307/logs /opt/extdata/mysql/3308/logs /opt/extdata/mysql/3309/logs

touch /opt/extdata/mysql/3307/logs/mysqld.log /opt/extdata/mysql/3308/logs/mysqld.log /opt/extdata/mysql/3309/logs/mysqld.log

第三部:拷贝数据目录

3.1、执行sql查看数据目录在什么地方
show global variables like '%datadir%';

默认应该在 /var/lib/mysql 这个目录下,我得修改过,我的在 /opt/extdata/mysql/3306/data/
3.2、拷贝数据目录
scp -r /opt/extdata/mysql/3306/data/* /opt/extdata/mysql/3307/data/
scp -r /opt/extdata/mysql/3306/data/* /opt/extdata/mysql/3308/data/
scp -r /opt/extdata/mysql/3306/data/* /opt/extdata/mysql/3309/data/

3.3、拷贝配置文件并修改
cp /etc/my.cnf /opt/extdata/mysql/3307/
修改  /opt/extdata/mysql/3307/my.cnf 内容如下
vim  /opt/extdata/mysql/3307/my.cnf
[mysqld]
log-bin=mysql-bin
server-id=3307
port=3307
datadir=/opt/extdata/mysql/3307/data
socket=/opt/extdata/mysql/3307/mysql.sock
log-error=/opt/extdata/mysql/3307/log/mysqld.log
pid-file=/opt/extdata/mysql/3307/mysqld.pid
[client]
socket=/opt/extdata/mysql/3307/mysql.sock

3.4、拷贝配置文件并替换路径
cp /opt/extdata/mysql/3307/my.cnf /opt/extdata/mysql/3308/
cp /opt/extdata/mysql/3307/my.cnf /opt/extdata/mysql/3309/

3.5、替换配置文件中得3307为 3308、3309
sed -i 's/3307/3308/g' /opt/extdata/mysql/3308/my.cnf
sed -i 's/3307/3309/g' /opt/extdata/mysql/3309/my.cnf

第四步:修改目录权限
chown -R mysql:mysql /opt/extdata/mysql/

第五步:启动
mysqld --defaults-file=/opt/extdata/mysql/3307/my.cnf --user=mysql &
mysqld --defaults-file=/opt/extdata/mysql/3308/my.cnf --user=mysql &
mysqld --defaults-file=/opt/extdata/mysql/3309/my.cnf --user=mysql &

第六步:停止
mysqladmin -uroot -p -S /opt/extdata/mysql/3307/mysql.sock shutdown
mysqladmin -uroot -p -S /opt/extdata/mysql/3308/mysql.sock shutdown
mysqladmin -uroot -p -S /opt/extdata/mysql/3309/mysql.sock shutdown

第七步:验证进程
ps -ef | grep mysqld

最后修改于 2021-01-08 12:52:37
如果觉得我的文章对你有用,请随意赞赏
扫一扫支付
上一篇