MySQL InnoDB Cluster

Purpose

To attempt installing a 3 node cluster.

Process

Started with downloading and installing mysql80-community-release-el7-3.noarch.rpm on each node, and the workstation I used for the admin API.

• Install and configure mysql server on first node. In my case this is Amazon Linux 2

sudo yum install mysql-server
sudo systemctl enable --now mysqld.service

• Grab the temp password from /var/log/mysqld.log and run secure setup. I allowed remote root user for cluster purposes, this should be restricted later to just the cluster hosts and the adminapi host.

• Installed mysql shell on my Fedora 33 workstation.

sudo dnf install -y mysql-shell