Galera Manager Mysql8.0 Cluster Deployment

in mysql •  11 months ago 

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>&nbsp;</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.


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.


Deploy Cluster

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.


SSH Key

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.


Finish Setup

Click on the cluster just created and then select Add nodes.


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.

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!