Upgrade to MariaDB Enterprise Server 10.5 on Ubuntu 20.04 LTS¶
These instructions detail the upgrade from a previous version of MariaDB Enterprise Server to MariaDB Enterprise Server 10.5 on Ubuntu 20.04 LTS.
When MariaDB Enterprise Server is upgraded, the old version needs to be uninstalled, and the new version needs to be installed.
Occasionally, issues can be encountered during upgrades. These issues can even potentially corrupt the database's data files, preventing you from easily reverting to the old installation. Therefore, it is generally best to perform a backup prior to upgrading. If an issue is encountered during the upgrade, you can use the backup to restore your MariaDB Server database to the old version. If the upgrade finishes without issue, then the backup can be deleted.
Take a full backup:
$ sudo mariadb-backup --backup \ --user=mariabackup_user \ --password=mariabackup_passwd \ --target-dir=/data/backup/preupgrade_backup
Confirm successful completion of the backup operation.
The backup must be prepared:
$ sudo mariadb-backup --prepare \ --target-dir=/data/backup/preupgrade_backup
Confirm successful completion of the prepare operation.
Backups should be tested before they are trusted.
Audit Plugin Considerations¶
If you have the MariaDB Audit Plugin installed and if you are upgrading to MariaDB Enterprise Server 10.4 or later, then the audit plugin should be removed prior to the upgrade to prevent conflict with the MariaDB Enterprise Audit Plugin that is present in MariaDB Enterprise Server 10.4 or later.
It can be removed by using the UNINSTALL SONAME statement:
UNINSTALL SONAME 'server_audit';
And if you load the plugin in a configuration file using the
plugin_load_add option, then the option should also be removed.
The MariaDB Enterprise Audit Plugin will automatically be installed after installing MariaDB Enterprise Server 10.4 or later.
Uninstall the Old Version¶
When upgrading to a new major release of MariaDB Enterprise Server, it is necessary to remove the existing installation of MariaDB Enterprise Server, before installing the new version of MariaDB Enterprise Server. Otherwise, the package manager will refuse to install the new version of MariaDB Enterprise Server.
Stop the MariaDB Server Process¶
Before the old version can be uninstalled, we first need to stop the current MariaDB Server process.
Stop the server process using the
$ sudo systemctl stop mariadb
Uninstall via APT (Debian/Ubuntu)¶
Uninstall all of the MariaDB Enterprise Server packages. Note that a wildcard character is used to ensure that all MariaDB Enterprise Server packages are uninstalled:
$ sudo apt remove "mariadb-*"
Be sure to check that this wildcard does not unintentionally refer to any of your custom applications.
Uninstall the Galera package as well.
The name of the package depends on the specific version of MariaDB Enterprise Server.
When upgrading from MariaDB Enterprise Server 10.4 or later, the package is called
$ sudo apt remove galera-enterprise-4
When upgrading from MariaDB Enterprise Server 10.3 or earlier, the package is called
$ sudo apt remove galera
Before proceeding, verify that all MariaDB Enterprise Server packages are uninstalled. The following command should not return any results:
$ apt list --installed | grep -i -E "mariadb|galera"
Install the New Version¶
MariaDB Corporation provides a APT package repository for Ubuntu 20.04 LTS.
Install via APT (Debian/Ubuntu)¶
Retrieve your Customer Download Token at https://customers.mariadb.com/downloads/token/ and substitute for
customer_download_tokenin the following directions.
Configure the APT package repository.
To configure APT package repositories:
$ sudo apt install wget $ wget https://dlm.mariadb.com/enterprise-release-helpers/mariadb_es_repo_setup $ echo "eeebe9e08dffb8a4e820cc0f673afe437621060129169ea3db0790eb649dbe9b mariadb_es_repo_setup" \ | sha256sum -c - $ chmod +x mariadb_es_repo_setup $ sudo ./mariadb_es_repo_setup --token="customer_download_token" --apply \ --mariadb-server-version="10.5" $ sudo apt update
Install MariaDB Enterprise Server and package dependencies:
$ sudo apt install mariadb-server mariadb-backup
Installation only loads MariaDB Enterprise Server to the system. MariaDB Enterprise Server requires configuration before the database server is ready for use.
Starting the Server¶
MariaDB Enterprise Server includes configuration to start, stop, restart, enable/disable on boot, and check the status of the Server using the operating system default process management system.
Ubuntu 20.04 LTS uses systemd. You can manage the Server process using the
Enable during startup
Disable during startup
Upgrading the Data Directory¶
MariaDB Enterprise Server 10.5 ships with the mariadb-upgrade utility which can be used to identify and correct compatibility issues in the new version. After you upgrade your Server and start the server process, run this utility to upgrade the data directory:
$ sudo mariadb-upgrade
When MariaDB Enterprise Server is up and running on your system, you should test that it is working and there weren't any issues during startup.
Connect to the server using MariaDB Client using the
$ sudo mariadb Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 9 Server version: 10.5.5-3-MariaDB-Enterprise MariaDB Enterprise Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>
MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'version'; +---------------+------------------------------+ | Variable_name | Value | +---------------+------------------------------+ | version | 10.5.5-3-MariaDB-Enterprise | +---------------+------------------------------+ 1 row in set (0.001 sec)
You can also verify the server version by calling the VERSION() function:
MariaDB [(none)]> SELECT VERSION(); +------------------------------+ | VERSION() | +------------------------------+ | 10.5.5-3-MariaDB-Enterprise | +------------------------------+ 1 row in set (0.000 sec)