Difference between revisions of "MySQL InnoDB Cluster"
Jump to navigation
Jump to search
Michael.mast (talk | contribs) (Created page with "==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 workst...") |
Michael.mast (talk | contribs) |
||
| Line 8: | Line 8: | ||
sudo systemctl enable --now mysqld.service | sudo systemctl enable --now mysqld.service | ||
</pre> | </pre> | ||
| + | *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. | ||
<ref>https://dev.mysql.com/doc/mysql-shell/8.0/en/deploying-new-production-cluster.html</ref> | <ref>https://dev.mysql.com/doc/mysql-shell/8.0/en/deploying-new-production-cluster.html</ref> | ||
*Installed mysql shell on my Fedora 33 workstation. | *Installed mysql shell on my Fedora 33 workstation. | ||
Revision as of 11:37, 25 April 2021
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
