本文共 2293 字，大约阅读时间需要 7 分钟。

????????????MySQL??

??????????????????MySQL?????????????????????????????????????????????????????

1. ???????????

?????????MySQL??????????????????????????????????????????????

mkdir -p /data/mysql3306{1,2,3}/data
cp /etc/my.cnf /data/mysql33061/

????????tree?????????

tree /data/ -L

2. ??????

????????MySQL??????????vi???????????????

vi /data/mysql33061/my.cnf

?????????????

[mysqld]
basedir=/usr/local/mysqld
datadir=/data/mysql33061/data
socket=/tmp/mysql33061.sock
server_id=61
port=33061
log_bin=/data/mysql33061/mysql-bin
log_error=/data/mysql33061/mysql.log

???????????????????????sed???????????????ID?

cp /data/mysql33061/my.cnf /data/mysql33062/
cp /data/mysql33061/my.cnf /data/mysql33063/
sed -i 's/1/2/g' /data/mysql33062/my.cnf
sed -i 's/1/3/g' /data/mysql33063/my.cnf

3. ????????

??mysqld???????MySQL??????--initialize-insecure??????????????????????????

mysqld --initialize-insecure --user=mysql --datadir=/data/mysql33061/data/ --basedir=/usr/local/mysql
mysqld --initialize-insecure --user=mysql --datadir=/data/mysql33062/data/ --basedir=/usr/local/mysql
mysqld --initialize-insecure --user=mysql --datadir=/data/mysql33063/data/ --basedir=/usr/local/mysql

??????????????????????

tail -f /data/mysql33061/mysql.log

4. ??????

???MySQL????????????????????????????????chown??????????????

chown -R mysql.mysql /data/*

5. ??????????

???MySQL???????????????????61?????sed?????????

cd /etc/systemd/system
cp mysqld.service mysqld61.service
sed -i 's#Server#Server Instance 61#; s#/etc#/data/mysql33061#' mysqld61.service

????????62?63??????????

cp mysqld.service mysqld62.service
sed -i 's#Server#Server Instance 62#; s#/etc#/data/mysql33062#' mysqld62.service
cp mysqld.service mysqld63.service
sed -i 's#Server#Server Instance 63#; s#/etc#/data/mysql33063#' mysqld63.service

???????systemd?????

systemctl daemon-reload

6. ??MySQL??

??systemctl??????MySQL???

systemctl start mysqld
systemctl start mysqld61
systemctl start mysqld62
systemctl start mysqld63

???????????

ss -tuln | grep mysqltcp
ps -ef | grep mysql

7. ???????

???????MySQL????????????61???

mysql -S /tmp/mysql33061.sock -e "SELECT @@server_id"

????????????ID???????62?63?

mysql -S /tmp/mysql33062.sock -e "SELECT @@server_id"
mysql -S /tmp/mysql33063.sock -e "SELECT @@server_id"

??????????????????MySQL??????????????????