MariaDB 11.x
10.19.25
sudo apt-get install mariadb-backup
sudo rm -Rf mariadb_backup_files
sudo mariadb-backup –backup
sudo apt list --installed | grep "^mariadb" | grep -v automatic
mariadb-backup/unknown,now 1:11.8.3+maria~ubu2404 amd64 [installed]
mariadb-client/unknown,now 1:11.8.3+maria~ubu2404 amd64 [installed]
mariadb-server/unknown,now 1:11.8.3+maria~ubu2404 amd64 [installed]
# download latest repo setup for 11.8
curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=11.8
# upgrade the components
sudo apt upgrade mariadb-server mariadb-client mariadb-backup
The latest MariaDB LTS version
Installation of Mariadb
utf8mb4_general_ci is a simplified set of sorting rules which aims to do as well as it can
while taking many short-cuts designed to improve speed. It does not
follow the Unicode rules and will result in undesirable sorting or
comparison in some situations, such as when using particular languages
or characters.
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
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