Teguh Triharto Learning Center: .::: Install MariaDB 10.6, Maxscale, Keepalived in Suselinux SLES 15 :::.

1. enable repo

teguhth01suse:~ # cat /etc/zypp/repos.d/mariadb.repo
[mariadb]
enabled=1
autorefresh=1
baseurl=https://yum.mariadb.org/10.6/sles/15/x86_64
gpgcheck=1
teguhth01suse:~ #

2. Prepare packages

rpm --import https://downloads.mariadb.com/MariaDB/MariaDB-Server-GPG-KEY
rpm --import https://downloads.mariadb.com/MariaDB/RPM-GPG-KEY-MariaDB

wget https://ftp.lysator.liu.se/pub/opensuse/update/leap/15.6/sle/x86_64/socat-1.8.0.0-150600.20.6.1.x86_64.rpm
zypper install socat-1.8.0.0-150600.20.6.1.x86_64.rpm

wget https://ftp.lysator.liu.se/pub/opensuse/update/leap/15.6/sle/x86_64/libasan8-14.3.0+git11799-150000.1.11.1.x86_64.rpm
zypper install libasan8-14.3.0+git11799-150000.1.11.1.x86_64.rpm

3. log

teguhth01suse:/data # zypper install socat-1.8.0.0-150600.20.6.1.x86_64.rpm
Looking for gpg key ID C74CD1D8 in cache /var/cache/zypp/pubkeys.
Repository mariadb does not define additional 'gpgkey=' URLs.
Warning: File 'repomd.xml' from repository 'mariadb' is signed with an unknown key 'F1656F24C74CD1D8'.

Note: Signing data enables the recipient to verify that no modifications occurred after the data
were signed. Accepting data with no, wrong or unknown signature can lead to a corrupted system
and in extreme cases even to a system compromise.

Note: File 'repomd.xml' is the repositories master index file. It ensures the integrity of the
whole repo.

Warning: We can't verify that no one meddled with this file, so it might not be trustworthy
anymore! You should not continue unless you know it's safe.

File 'repomd.xml' from repository 'mariadb' is signed with an unknown key 'F1656F24C74CD1D8'.
Continue? [yes/no] (no): yes
Retrieving repository 'mariadb' metadata ...................................................................................................................[done]
Building repository 'mariadb' cache ........................................................................................................................[done]
Loading repository data...
Reading installed packages...
Resolving package dependencies...

The following NEW package is going to be installed:
socat

The following package has no support information from its vendor:
socat

1 new package to install.

Package download size: 281.3 KiB

Package install size change:
| 864.5 KiB required by packages that will be installed
864.5 KiB | - 0 B released by packages that will be removed

Backend: classic_rpmtrans
Continue? [y/n/v/...? shows all options] (y): y
Retrieving: socat-1.8.0.0-150600.20.6.1.x86_64 (Plain RPM files cache) (1/1), 281.3 KiB

Checking for file conflicts: ...............................................................................................................................[done]
(1/1) Installing: socat-1.8.0.0-150600.20.6.1.x86_64 .......................................................................................................[done]
teguhth01suse:/data #

teguhth01suse:/data # wget https://ftp.lysator.liu.se/pub/opensuse/update/leap/15.6/sle/x86_64/libasan8-14.3.0+git11799-150000.1.11.1.x86_64.rpm
--2025-10-28 14:37:26-- https://ftp.lysator.liu.se/pub/opensuse/update/leap/15.6/sle/x86_64/libasan8-14.3.0+git11799-150000.1.11.1.x86_64.rpm
Resolving ftp.lysator.liu.se (ftp.lysator.liu.se)... 130.236.254.253, 130.236.254.251, 2001:6b0:17:f0a0::fd, ...
Connecting to ftp.lysator.liu.se (ftp.lysator.liu.se)|130.236.254.253|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 453532 (443K) [application/x-redhat-package-manager]
Saving to: ‘libasan8-14.3.0+git11799-150000.1.11.1.x86_64.rpm’

libasan8-14.3.0+git11799-150000.1.11.1.x 100%[================================================================================>] 442.90K 510KB/s in 0.9s

2025-10-28 14:37:28 (510 KB/s) - ‘libasan8-14.3.0+git11799-150000.1.11.1.x86_64.rpm’ saved [453532/453532]

teguhth01suse:/data # zypper install libasan8-14.3.0+git11799-150000.1.11.1.x86_64.rpm
Loading repository data...
Reading installed packages...
Resolving package dependencies...

The following NEW package is going to be installed:
libasan8

The following package has no support information from its vendor:
libasan8

1 new package to install.

Package download size: 442.9 KiB

Package install size change:
| 1.6 MiB required by packages that will be installed
1.6 MiB | - 0 B released by packages that will be removed

Backend: classic_rpmtrans
Continue? [y/n/v/...? shows all options] (y): y
Retrieving: libasan8-14.3.0+git11799-150000.1.11.1.x86_64 (Plain RPM files cache) (1/1), 442.9 KiB

Checking for file conflicts: ...............................................................................................................................[done]
(1/1) Installing: libasan8-14.3.0+git11799-150000.1.11.1.x86_64 ............................................................................................[done]
teguhth01suse:/data #

4. enable package for galera

zypper search-packages libboost_program_options

teguhth01suse:/data # zypper search-packages libboost_program_options
Following packages were found in following modules:

Package Module or Repository SUSEConnect Activation Command
---------------------------------------- ----------------------------------------------------- -------------------------------------------------------
libboost_program_options1_66_0 Basesystem Module (sle-module-basesystem/15.7/x86_64) SUSEConnect --product sle-module-basesystem/15.7/x86_64
libboost_program_options1_66_0-devel Basesystem Module (sle-module-basesystem/15.7/x86_64) SUSEConnect --product sle-module-basesystem/15.7/x86_64
libboost_program_options1_66_0-debuginfo Basesystem Module (sle-module-basesystem/15.7/x86_64) SUSEConnect --product sle-module-basesystem/15.7/x86_64
libboost_program_options1_66_0 Available in repo Basesystem-Module_15.7-0
libboost_program_options1_66_0-devel Available in repo Basesystem-Module_15.7-0

To activate the respective module or product, use SUSEConnect --product.
Use SUSEConnect --help for more details.

teguhth01suse:/data #

5. enable repo opensuse-oss
zypper ar -f https://download.opensuse.org/distribution/leap/15.1/repo/oss/ opensuse-oss-15.1

teguhth01suse:/data # zypper ar -f https://download.opensuse.org/distribution/leap/15.1/repo/oss/ opensuse-oss-15.1
Adding repository 'opensuse-oss-15.1' ......................................................................................................................[done]
Repository 'opensuse-oss-15.1' successfully added

URI : https://download.opensuse.org/distribution/leap/15.1/repo/oss/
Enabled : Yes
GPG Check : Yes
Autorefresh : Yes
Priority : 99 (default priority)

Repository priorities are without effect. All enabled repositories share the same priority.
teguhth01suse:/data #

teguhth01suse:/data # more /etc/zypp/repos.d/opensuse-oss-15.1.repo
[opensuse-oss-15.1]
enabled=1
autorefresh=1
baseurl=https://download.opensuse.org/distribution/leap/15.1/repo/oss/
teguhth01suse:/data #

6. Install libboost_program_options1_66_0

zypper install libboost_program_options1_66_0

teguhth01suse:/data # zypper install libboost_program_options1_66_0

New repository or package signing key received:

Repository: opensuse-oss-15.1
Key Fingerprint: 22C0 7BA5 3417 8CD0 2EFE 22AA B88B 2FD4 3DBD C284
Key Name: openSUSE Project Signing Key <opensuse@opensuse.org>
Key Algorithm: RSA 2048
Key Created: Mon May 5 15:37:40 2014
Key Expires: Thu May 2 15:37:40 2024 (EXPIRED)
Rpm Name: gpg-pubkey-3dbdc284-53674dd4

Note: Signing data enables the recipient to verify that no modifications occurred after the data
were signed. Accepting data with no, wrong or unknown signature can lead to a corrupted system
and in extreme cases even to a system compromise.

Note: A GPG pubkey is clearly identified by its fingerprint. Do not rely on the key's name. If
you are not sure whether the presented key is authentic, ask the repository provider or check
their web site. Many providers maintain a web page showing the fingerprints of the GPG keys they
are using.

Do you want to reject the key, trust temporarily, or trust always? [r/t/a/?] (r): a
Warning: The gpg key signing file 'repomd.xml' has expired.
Repository: opensuse-oss-15.1
Key Fingerprint: 22C0 7BA5 3417 8CD0 2EFE 22AA B88B 2FD4 3DBD C284
Key Name: openSUSE Project Signing Key <opensuse@opensuse.org>
Key Algorithm: RSA 2048
Key Created: Mon May 5 15:37:40 2014
Key Expires: Thu May 2 15:37:40 2024 (EXPIRED)
Rpm Name: gpg-pubkey-3dbdc284-53674dd4
Retrieving repository 'opensuse-oss-15.1' metadata .........................................................................................................[done]
Building repository 'opensuse-oss-15.1' cache ..............................................................................................................[done]
Loading repository data...
Reading installed packages...
Resolving package dependencies...

The following NEW package is going to be installed:
libboost_program_options1_66_0

The following package has no support information from its vendor:
libboost_program_options1_66_0

1 new package to install.

Package download size: 139.3 KiB

Package install size change:
| 500.6 KiB required by packages that will be installed
500.6 KiB | - 0 B released by packages that will be removed

Backend: classic_rpmtrans
Continue? [y/n/v/...? shows all options] (y): y
Retrieving: libboost_program_options1_66_0-1.66.0-lp151.4.5.x86_64 (opensuse-oss-15.1) (1/1), 139.3 KiB
Retrieving: libboost_program_options1_66_0-1.66.0-lp151.4.5.x86_64.rpm .......................................................................[done (307.0 KiB/s)]

Checking for file conflicts: ...............................................................................................................................[done]
(1/1) Installing: libboost_program_options1_66_0-1.66.0-lp151.4.5.x86_64 ...................................................................................[done]
teguhth01suse:/data #

7. install mariadb

zypper install MariaDB-server MariaDB-backup MariaDB-client MariaDB-common MariaDB-shared galera-4

8. enable mariadb

systemctl restart mariadb
systemctl status mariadb

9. install maxscale

teguhth01suse:/data # cat /etc/zypp/repos.d/mariadb-maxscale.repo
[mariadb-maxscale]
enabled=1
autorefresh=0
baseurl=https://downloads.mariadb.com/MaxScale/24.08.0-debug/sles/15server/x86_64/
teguhth01suse:/data #

zypper install maxscale keepalived

10. enable maxscale, keepalived

systemctl restart maxscale
systemctl status maxscale

systemctl restart keepalived
systemctl status keepalived

11. check status maxscale keepalived

teguhth01suse:/data # maxctrl --version
24.08.0
teguhth01suse:/data # maxctrl list servers
+--------------------------------------------------------------------------------------+
¦ Server ¦ Address ¦ Port ¦ Connections ¦ State ¦ GTID ¦ Monitor ¦
+---------+-----------+------+-------------+------------------+------+-----------------¦
¦ server1 ¦ 127.0.0.1 ¦ 3306 ¦ 0 ¦ Auth Error, Down ¦ ¦ MariaDB-Monitor ¦
+--------------------------------------------------------------------------------------+
teguhth01suse:/data #