[How-To] Configure Virtual IP for MariaDB servers with Keepalived
Purpose
This How-To serves as documentation on how to add keepalived to your MariaDB servers so they can all share a virtual IP or a VIP.
Prerequisites
List of prerequisites:
- Sudo user
- Galera cluster of MariaDB servers on Ubuntu 24.04 LTS
Instructions
Step 1: Update and Install Software
Run commands below to update os and install keepalived:
sudo apt update
sudo apt install -y keepalived
Step 2: Configure Keepalived
With keepalived freshly installed, we can open the configuration file on each server with this command:
sudo nano /etc/keepalived/keepalived.conf
Here, you'll want to configure the master like this:
vrrp_instance VI_1 {
state MASTER
interface eth0 # Replace with your actual network interface
virtual_router_id 51
priority 100 # Higher priority on the master
advert_int 1
authentication {
auth_type PASS
auth_pass securepassword
}
virtual_ipaddress {
192.168.1.100 # Replace with your VIP
}
track_script {
chk_mariadb
}
}
vrrp_script chk_mariadb {
script "/usr/local/bin/check_mariadb.sh"
interval 2
weight -20
}
Then, you'll want to configure the backups like this:
vrrp_instance VI_1 {
state BACKUP
interface eth0
virtual_router_id 51
priority 90 # Lower priority on the backup
advert_int 1
authentication {
auth_type PASS
auth_pass securepassword
}
virtual_ipaddress {
192.168.1.100
}
track_script {
chk_mariadb
}
}
vrrp_script chk_mariadb {
script "/usr/local/bin/check_mariadb.sh"
interval 2
weight -20
}
Step 3: Enable and Start Keepalived
Now we're ready to start the service. Run the following to enable it at startup and then start the service once now:
sudo systemctl enable keepalived
sudo systemctl start keepalived
Check the status of the service to verify its running:
sudo systemctl status keepalived
Step 4: Test the VIP
Finally, test that the VIP is there:
ip addr show
No Comments