inchirags@gmail.com MariaDB DBA Tutorial https://www.chirags.in
*****************************************************************************************
* Configure MariaDB Galera Cluster in ubuntu 24.04 LTS *
*****************************************************************************************
YouTube Video
Here's a step-by-step guide to configure a MariaDB Galera Cluster on Ubuntu 24.04 LTS:
Server Details:
+---------+-------------------+
| Server | Server IP |
+---------+-------------------+
| Server1 | 192.168.224.129 |
| Server2 | 192.168.224.130 |
| Server3 | 192.168.224.131 |
+---------+-------------------+
Step 1: Firewall Configuration
sudo ufw status
sudo ufw allow ssh
sudo ufw allow 3306/tcp
sudo ufw allow 4567/tcp
sudo ufw allow 4568/tcp
sudo ufw allow 4444/tcp
sudo ufw enable
Step 2: Update and Install Required Packages
Run these commands on all cluster nodes:
sudo apt update
sudo apt upgrade -y
sudo apt install mariadb-server mariadb-client rsync -y
sudo systemctl start mariadb
sudo systemctl enable mariadb
sudo systemctl status mariadb
Step 3: Configure MariaDB on All Nodes
Edit the MariaDB configuration file:
#Primary Node
sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf
Add or update the following configuration under [mysqld]:
Add # before
# bind-address=127.0.0.1
# add to last line
[galera]
wsrep_on=ON
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_cluster_address="gcomm://192.168.224.129,192.168.224.130,192.168.224.131"
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
# any cluster name
wsrep_cluster_name="MariaDB_Cluster"
# own IP address
wsrep_node_address="192.168.224.129"
#Secondary Node1
sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf
Add or update the following configuration under [mysqld]:
Add # before
# bind-address=127.0.0.1
# add to the end
[galera]
wsrep_on=ON
wsrep_provider=/usr/lib/galera/libgalera_smm.so
# specify all nodes in cluster
wsrep_cluster_address="gcomm://192.168.224.129,192.168.224.130,192.168.224.131"
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
# any cluster name
wsrep_cluster_name="MariaDB_Cluster"
# specify this host's IP address
wsrep_node_address="192.168.224.130"
#Secondary Node2
sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf
Add or update the following configuration under [mysqld]:
Add # before
# bind-address=127.0.0.1
# add to the end
[galera]
wsrep_on=ON
wsrep_provider=/usr/lib/galera/libgalera_smm.so
# specify all nodes in cluster
wsrep_cluster_address="gcomm://192.168.224.129,192.168.224.130,192.168.224.131"
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
# any cluster name
wsrep_cluster_name="MariaDB_Cluster"
# specify this host's IP address
wsrep_node_address="192.168.224.131"
Save and exit the all the files.
Step 4: Start the Cluster
On the first node only:
#in Node 1 (Primary Node)
sudo systemctl stop mariadb
sudo galera_new_cluster
sudo systemctl start mariadb
#On the other nodes:
sudo systemctl stop mariadb
sudo systemctl start mariadb
Verify cluster status:
MariaDB [(none)]> SHOW STATUS LIKE 'wsrep_cluster_size';
MariaDB [(none)]> SHOW STATUS LIKE 'wsrep_local_state_comment';
MariaDB [(none)]> SHOW STATUS LIKE 'wsrep_cluster_status';
-- wsrep_cluster_size should match the number of nodes.
-- wsrep_cluster_status should be Primary.
-- wsrep_local_state_comment should show Synced.
Step 5: Create a Test Database
On any node:
Run the following SQL commands:
-- Create a Test Database
CREATE DATABASE galera_test;
-- Use the Test Database
USE galera_test;
-- Create a Test Table
CREATE TABLE test_table (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
-- Insert Sample Data
INSERT INTO test_table (name) VALUES ('Node1 Test'), ('Node2 Test'), ('Node3 Test');
Step 6: Verify Data on All Nodes
On Node1:
Connect directly to Node1:
mysql -u root -p
Check the data:
MariaDB [(none)]> USE galera_test;
MariaDB [galera_test]> SELECT * FROM test_table;
Output:
+----+------------+---------------------+
| id | name | created_at |
+----+------------+---------------------+
| 1 | Node1 Test | 2025-01-01 15:59:58 |
| 4 | Node2 Test | 2025-01-01 15:59:58 |
| 7 | Node3 Test | 2025-01-01 15:59:58 |
+----+------------+---------------------+
3 rows in set (0.001 sec)
On Node2 and Node3:
Repeat the same steps on each node (192.168.224.130, 192.168.224.131).
Check if the database replicates on other nodes.
Your MariaDB Galera Cluster is now successfully set up on Ubuntu 24.04 LTS! Let me know if you encounter any issues.
For any doubts and query, please write on YouTube video comments section.
Note : Flow the Process shown in video.
Please, Subscribe and like for more videos:
https://www.youtube.com/@chiragstutorial
Don't forget to, Follow, Like, Share &, Comment
Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_________________________________________________________________________________________
Note: All scripts used in this demo will be available in our website.
Link will be available in description.
