• databases
• mariadb

mariadb

About

• https://mariadb.com/

• https://mariadb.org/

• MariaDB Server – All releases

• MariaDB Docs

• MariaDB Knowledge Base (KB)

  • MariaDB KB - Optimization and Tuning

  • MariaDB KB - Server System Variables

  • MariaDB KB - InnoDB System Variables

• Download a PDF version of the MariaDB Server documentation.

• Existing Ansible Modules and Roles for MariaDB

• MariaDB vs. MySQL

  • IONOS.de - MariaDB vs. MySQL (IONOS Redaktion 18.10.2022)

To learn what is new in 11.8 it is recommended to read all the previous release notes since 10.11:

• https://mariadb.com/kb/en/changes-improvements-in-mariadb-11-0/

• https://mariadb.com/kb/en/changes-improvements-in-mariadb-11-1/

• https://mariadb.com/kb/en/changes-improvements-in-mariadb-11-2/

• https://mariadb.com/kb/en/what-is-mariadb-113/

• https://mariadb.com/kb/en/what-is-mariadb-114/

  • also includes summary of 11.0-11.3

• https://mariadb.com/kb/en/changes-improvements-in-mariadb-11-5/

• https://mariadb.com/kb/en/changes-improvements-in-mariadb-11-6/

• https://mariadb.com/kb/en/changes-improvements-in-mariadb-11-7/

• https://mariadb.com/kb/en/changes-improvements-in-mariadb-11-8/

  • also includes summary of 11.5-11.7

Things to consider when upgrading from 10.11 to 11.8 are listed on the page

• https://mariadb.com/kb/en/upgrading-from-mariadb-10-11-to-mariadb-11-4/ and

• https://mariadb.com/kb/en/upgrading-from-mariadb-11-4-to-mariadb-11-8/.

Installation

   1 

Configure

Some important commands (that are safe to use)

   1 ### PRINT DEFAULTS
   2 mysqld --print-defaults | sed 's/ --/\n--/g'
   3 ### SHOW CONFIGURATION OPTIONS
   4 mysqld --verbose --help | less
   5 ### SHOW CURRENT CONFIGURATION
   6 mysql -e "show variables like 'innodb_%';" | less

Show MariaDB/MySQL roles

   1 SELECT user AS 'role_name' FROM mysql.user where host = '';