.::: Install MariaDB 11.4, 12, 13 In Ubuntu 24.04.5 LTS :::.

 

 

1. check OS 

grep '^PRETTY_NAME=' /etc/os-release | cut -d= -f2- | tr -d '"'

2. install curl mariadb & maxscale

curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash

curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version="mariadb-11.4" --mariadb-maxscale-version="24"

3. after install, check mariadb.source 

root@teguhth:~# cat /etc/apt/sources.list.d/mariadb.sources

# MariaDB Server
# To use a different major version of the server, or to pin to a specific minor version, change URI below.
X-Repolib-Name: MariaDB Server
Enabled: yes
Types: deb
#URIs: https://dlm.mariadb.com/repo/mariadb-server/11./repo/ubuntu
#URIs: https://dlm.mariadb.com/repo/mariadb-server/12.rolling/repo/ubuntu
URIs: https://dlm.mariadb.com/repo/mariadb-server/13.rolling/repo/ubuntu
Suites: noble
Components: main main/debug
Architectures: amd64 arm64
Signed-By: /etc/apt/keyrings/mariadb-keyring.gpg
 
# MariaDB MaxScale
# To use the latest stable release of MaxScale, use "latest" as the version
# To use the latest beta (or stable if no current beta) release of MaxScale, use "beta" as the version
X-Repolib-Name: MariaDB MaxScale
Enabled: yes
Types: deb
URIs: https://dlm.mariadb.com/repo/maxscale/24/apt
Suites: noble
Components: main
Architectures: amd64 arm64
Signed-By: /etc/apt/keyrings/mariadb-keyring.gpg

root@teguhth:~#
 

4. install default tool

apt install rsync htop nmon nload net-tools sysstat -y

5. install mariadb 11.8

apt install mariadb-server mariadb-client mariadb-common -y

# for downgrade 

apt install mariadb-server mariadb-client mariadb-common -y --allow-downgrades

6. enable booting & automatic booting 

systemctl enable mariadb
systemctl start mariadb

7. login mariadb

mariadb
mariadb -uroot -p 

8. check version

select @@hostname,@@version;

systemctl status mariadb | grep -i database
 

9. install maxscale 

apt install maxscale -y 

10. enable booting & automatic booting 

systemctl enable maxscale
systemctl start maxscale

11. cek maxscale 

maxctrl --version
maxctrl list servers