MySQL InnoDB 集群部署操作

Question

下载并配置环境变量

• https://dev.mysql.com/downloads/mysql/
• MySQL Server 5.7
• MySQL Shell 8.0
• MySQL Router 8.0

mkdir -p /usr/local/bin/mysql/server
mkdir -p /usr/local/bin/mysql/shell
mkdir -p /usr/local/bin/mysql/router

cd /usr/local/bin/mysql/server
curl -O https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-server_5.7.28-1ubuntu18.04_amd64.deb-bundle.tar
tar -xvf mysql-server_5.7.28-1ubuntu18.04_amd64.deb-bundle.tar

cd /usr/local/bin/mysql/shell
curl -O https://cdn.mysql.com//Downloads/MySQL-Shell/mysql-shell_8.0.18-1ubuntu18.04_amd64.deb
dpkg -i mysql-shell_8.0.18-1ubuntu18.04_amd64.deb

cd /usr/local/bin/mysql/router
curl -O https://cdn.mysql.com//Downloads/MySQL-Router/mysql-router-community-dbgsym_8.0.18-1ubuntu18.04_amd64.deb
dpkg -i mysql-router-community-dbgsym_8.0.18-1ubuntu18.04_amd64.deb

这里在一台机器上搭建3个数据库实例，开启端口 24801、24802、24803 。配置 /etc/hosts 文件，配置域名 ic-1，ic-2，ic-3，分别对应三个数据库实例。

在 /etc/hosts 文件最后添加一行数据，确保域名之间都可以 ping 通，192.168.220.133 是本机IP：

192.168.220.133 ic-1 ic-2 ic-3

Linux 下创建 mysql 用户，否则下一步会提示出错信息，在 /home/mysql 目录下，创建 data 目录并初始化实例：

mysql-5.7/bin/mysqld --initialize-insecure --basedir=$PWD/mysql-5.7
--datadir=$PWD/data/s1

mysql-5.7/bin/mysqld --initialize-insecure --basedir=$PWD/mysql-5.7
--datadir=$PWD/data/s2

mysql-5.7/bin/mysqld --initialize-insecure --basedir=$PWD/mysql-5.7
--datadir=$PWD/data/s3