i have created a tutorial on github few months back regarding Galera Manager Mysql8.0 Cluster Deployment in gitlab , https://gitlab.com/krishiv-g/Galera-manager-mysql8.0-Cluster-Deployment
I would love to re-write this
<h1>Installing Galera Manager and Automatically Deploying MySQL 8.0 Galera Cluster in Multiple Hosts</h1>
<h5>Provided that below is my Setup We will now Install Galera Manager and Deploy Mysql 8.0 Cluster on 3 Nodes</h5>
<p> </p>
<pre>
Mysql1 192.168.1.102
Mysql2 192.168.1.103
Mysql3 192.168.1.104
Galera-Manager 192.168.1.105
Assuming All Servers are Fresh Installed Ubuntu 20.04 Servers
apt update -y
apt install wget -y
wget https://galeracluster.com/galera-manager/gm-installer
chmod +x gm-installer
./gm-installer install
The gm installer will start an interactive shell and will ask for a few options, please give information accordingly. If you need SSL, please give GDM a domain name while installing instead of an IP address, point the domain to the IP address and it will automatically install SSL certificates using Let's Encrypt.
Once the installation finishes please go to the IP address of Galera manager i.e for me http://192.168.1.105
On the main screen, click on Add Cluster.
Click on Deploy Cluster on user-provided hosts.
Give it a name and select the appropriate host OS i.e Ubuntu 20 and click next.
The Galera manager needs root access to the host server i.e., all MySQL nodes we shall use so it will present an SSH key that we need to add to the host servers.
Copy that key and paste it inside /root/.ssh/authorized_keys
, if the folder /root/.ssh
is not present, create it.
mkdir /root/.ssh
nano /root/.ssh/authorized_keys
Once the key is pasted, restart the SSH service using the command:
service sshd restart
Click on "I have added the public key" as shown in the picture below and click finish.
Click on the cluster just created and then select Add nodes.
Give Node IP address and Check Access, if Access is fine then we can deploy the cluster, Repeat to add as many nodes as you want.