- 配置数据目录
mkdir -p /data/330{7,8,9}/data - 配置文件
cat > /data/3307/my.cnf <<EOF [mysqld] basedir=/app/mysql datadir=/data/3307/data socket=/data/3307/mysql.sock log_error=/data/3307/mysql.log port=3307 server_id=7 log_bin=/data/3307/mysql-bin EOF cat > /data/3308/my.cnf <<EOF [mysqld] basedir=/app/mysql datadir=/data/3308/data socket=/data/3308/mysql.sock log_error=/data/3308/mysql.log port=3308 server_id=8 log_bin=/data/3308/mysql-bin EOF cat > /data/3309/my.cnf <<EOF [mysqld] basedir=/app/mysql datadir=/data/3309/data socket=/data/3309/mysql.sock log_error=/data/3309/mysql.log port=3309 server_id=9 log_bin=/data/3309/mysql-bin EOF - 初始化实例
mysqld --initialize-insecure --user=mysql --datadir=/data/3307/data --basedir=/app/mysql mysqld --initialize-insecure --user=mysql --datadir=/data/3308/data --basedir=/app/mysql mysqld --initialize-insecure --user=mysql --datadir=/data/3309/data --basedir=/app/mysql - systemd管理多实例
touch /etc/systemd/system/mysql330{7,8,9}.service cat > /etc/systemd/systemd/mysql3307.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/mysql/bin/mysqld --defaults-file=/data/3307/my.cnf LimitNOFILE = 5000 EOF # 重载systemd配置 systemctl daemon-reload - 目录授权
chown -R mysql:mysql /data/* - 启动
systemctl status mysql3307 systemctl status mysql3308 systemctl status mysql3309 systemctl start mysql3307 systemctl start mysql3308 systemctl start mysql3309 - 验证
netstat -tunpl | grep 330 mysql -uroot -p -h localhost -S /data/3307/mysql.sock -P 3307 mysql -uroot -p -h localhost -S /data/3308/mysql.sock -P 3308 mysql -uroot -p -h localhost -S /data/3309/mysql.sock -P 3309
网友评论