This is the Lab exercise about building InnoDB Cluster
Environment : The provided VM instance has already installed with MySQL enterprise edition binary.
The /usr/local folder contains the binaries from corresponding tar packages.
The soft links are built to standardize the paths to the corresponding tar folders.
MySQL Home : /usr/local/mysql
MySQL Shell : /usr/local/shell
MySQL Router : /usr/local/router
3310 : /home/mysql/data/3310
3320 : /home/mysql/data/3320
3330 : /home/mysql/data/3330
Ensure there is no mysqld service running. By default with the provided VM instance, there are 4 active mysql services running.
Please login as opc and stop those services
- login as opc
- Stop the services
sudo systemctl stop mysqld@mysql01
sudo systemctl stop mysqld@mysql02
sudo systemctl stop mysqld@mysql03
sudo systemctl stop mysqld
- Check if any mysqld is running
- Switch user to mysql
- Using git to clone InnoDB Cluster environment (mysql as user)
cd /home/mysql
mkdir lab
cd lab
git clone https://github.com/ivanxma/InnoDBClusterLab
cd ~/lab/InnoDBClusterLab
- Initialization of 3 servers (3310,3320, 3330) on the same VM
- Configuration for GTID
- Using MySQL Shell and Configuring Group Replication Admin User & settings
- Creating InnoDB Cluster - 1 member, and add 2nd node using Incremental, and add 3rd node usign Clone
- Administrating InnoDB Cluster
- Bootstraping MySQL Router with InnoDB Cluster
- Creating another 3 servers (3340, 3350, 3360) and building clusterset to link mycluster and mycluster2(3340,3350,3360)