2.mysql的多实例

mysql的多实例

0.同版本多实例

1. 规划
   软件1份
   配置文件3份 ：/data/330{7…9}/my.cnf
   初始化数据3次
   数据目录 3份 /data/330{7…9}/data
   日志目录3份 /binlog/33{7…9}
   socket3份 /tmp/mysql330{7…9}.sock
   端口3份 port=3307,3308,3309
   server_id 3份 servier_id=7,8,9
2. 配置过程:如下

1. 创建需要目录

	mkdir -p /data/330{7..9}/data
	mkdir -p /binlog/330{7..9}

2.创建配置文件

cat > /data/3307/my.cnf <<EOF
[mysqld]
basedir=/app/database/mysql
datadir=/data/3307/data/
socket=/tmp/mysql3307.sock
log_error=/data/3307/mysql.log
port=3307
server_id=7
log_bin=/binlog/3307/mysql-bin
EOF

cat > /data/3308/my.cnf <<EOF
[mysqld]
basedir=/app/database/mysql
datadir=/data/3308/data
socket=/tmp/mysql3308.sock
log_error=/data/3308/mysql.log
port=3308
server_id=8
log_bin=/binlog/3308/mysql-bin
EOF

cat > /data/3309/my.cnf <<EOF
[mysqld]
basedir=/app/database/mysql
datadir=/data/3309/data
socket=/tmp/mysql3309.sock
log_error=/data/3309/mysql.log
port=3309
server_id=9
log_bin=/binlog/3309/mysql-bin
EOF

3.初始化数据

chown -R mysql.mysql /data  /binlog 
mv /etc/my.cnf  /etc/my.cnf.bak

mysqld --initialize-insecure  --user=mysql --basedir=/app/database/mysql --datadir=/data/3307/data
mysqld --initialize-insecure  --user=mysql --basedir=/app/database/mysql --datadir=/data/3308/data
mysqld --initialize-insecure  --user=mysql --basedir=/app/database/mysql --datadir=/data/3309/data

4.准备启动脚本

cat > /etc/systemd/system/mysqld3307.service  <<EOF
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/app/database/mysql/bin/mysqld --defaults-file=/data/3307/my.cnf
LimitNOFILE = 5000
EOF

cat > /etc/systemd/system/mysqld3308.service  <<EOF
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/app/database/mysql/bin/mysqld --defaults-file=/data/3308/my.cnf
LimitNOFILE = 5000
EOF

cat > /etc/systemd/system/mysqld3309.service  <<EOF
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/app/database/mysql/bin/mysqld --defaults-file=/data/3309/my.cnf
LimitNOFILE = 5000
EOF

5.启动

chown -R mysql.mysql /data/*
systemctl  start mysqld3307
systemctl  start mysqld3308
systemctl  start mysqld3309
netstat -tulnp

netstat -lnp|grep 330
mysql -S /tmp/mysql3307.sock -e "select @@server_id"
mysql -S /tmp/mysql3308.sock -e "select @@server_id"
mysql -S /tmp/mysql3308.sock -e "select @@server_id"