MySQL InnoDB Cluster

From Michael's Information Zone
Jump to navigation Jump to search

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 [1] 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.

[2]

  • Installed mysql shell on my Fedora 33 workstation.
sudo dnf install -y mysql-shell