MariaDB 11.x -

Upgrade Mariadb
Mariadb 11.1.2

echo "deb [arch=amd64,arm64,ppc64el signed-by=/usr/share/keyrings/mariadb.gpg] http://mirror.mariadb.org/repo/11.1/ubuntu/ $(lsb_release -cs) main" | sudo tee /etc/apt/sources.list.d/mariadb.list

Copy the /etc/apache2/ssl to /etc/mysql/ssl

cd/etc/mysql/mariadb.conf.d/50-server.cnf

ssl-ca=/etc/mysql/ssl/gd_bundle-g2-g1.crt
ssl-ca-path=/etc/mysql/ssl
ssl-cert=/etc/mysql/ssl/xxxxxxxxxxx.pem
ssl-key=/etc/mysql/ssl/xxxx.key
## Set up TLS version here. For example TLS version 1.2 and 1.3 ##
tls_version = TLSv1.2,TLSv1.3

Downloads Setting up MariaDB Repositories
latest: 11.0.3

It will update the databases for you.

sudo mysql_upgrade -u root -p to verify it is updated. It will install the repositories for future dist-upgrades.

/etc/mysql/mariadb.conf.d/50-server.cnf
[mysqld]

general_log_file = /var/log/mysql/mysql.log
log_error = /var/log/mysql/error.log
log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M binlog_format = mixed
expire_logs_days = 10

tmp_table_size=64M
max_heap_table_size=64M
query_cache_size=64M

[mariadb]
plugin_load_add = feedback
feedback=on
innodb_temp_data_file_path=ibtmp1:32M;ibtmp2:32M:autoextend

sudo apt update
sudo apt list –upgradable -a
sudo apt dist-upgrade
sudo reboot

You start by stopping mariadb and removing it.

sudo systemctl stop mariadb

sudo apt remove mariadb-server

Next you setup the new repository

sudo apt-get install software-properties-common dirmngr apt-transport-https
sudo apt-key adv –fetch-keys ‘https://mariadb.org/mariadb_release_signing_key.asc‘
sudo add-apt-repository ‘deb [arch=amd64,arm64,ppc64el,s390x] https://mirror.jaleco.com/mariadb/repo/10.11/ubuntu focal main’

echo "deb [arch=amd64,arm64,ppc64el signed-by=/usr/share/keyrings/mariadb.gpg]

http://mirror.mariadb.org/repo/11.0/ubuntu/ $(lsb_release -cs) main" | sudo tee /etc/apt/sources.list.d/mariadb.list

sudo apt update sudo apt install mariadb-server

Then I run the upgrade commands again to get any patches

sudo apt update
sudo apt list –upgradable -a
sudo apt dist-upgrade