Upgrading from MariaDB 10.3 to MariaDB 10.4

How to Upgrade

For Windows, see Upgrading MariaDB on Windows instead.

For MariaDB Galera Cluster, see instead.

Before you upgrade, it would be best to take a backup of your database. This is always a good idea to do before an upgrade. We would recommend mariadb-backup.

The suggested upgrade procedure is:

1. Modify the repository configuration, so the system's package manager installs . For example,

• On Debian, Ubuntu, and other similar Linux distributions, see for more information.

• On RHEL, CentOS, Fedora, and other similar Linux distributions, see for more information.

• On SLES, OpenSUSE, and other similar Linux distributions, see for more information.

1. .

2. Uninstall the old version of MariaDB.

• On Debian, Ubuntu, and other similar Linux distributions, execute the following:sudo apt-get remove mariadb-server

• On RHEL, CentOS, Fedora, and other similar Linux distributions, execute the following:sudo yum remove MariaDB-server

• On SLES, OpenSUSE, and other similar Linux distributions, execute the following:sudo zypper remove MariaDB-server

1. Install the new version of MariaDB.

• On Debian, Ubuntu, and other similar Linux distributions, see for more information.

• On RHEL, CentOS, Fedora, and other similar Linux distributions, see for more information.

• On SLES, OpenSUSE, and other similar Linux distributions, see for more information.

1. Make any desired changes to configuration options in , such as my.cnf. This includes removing any options that are no longer supported.

2. .

3. Run .

• mysql_upgrade does two things:

  1. Ensures that the system tables in the are fully compatible with the new version.

  2. Does a very quick check of all tables and marks them as compatible with the new version of MariaDB .

Incompatible Changes Between 10.3 and 10.4

On most servers upgrading from 10.3 should be painless. However, there are some things that have changed which could affect an upgrade:

Options That Have Changed Default Values

Options That Have Been Removed or Renamed

The following options should be removed or renamed if you use them in your :

Authentication and TLS

• See for an overview of the changes.

• The is now default on Unix-like systems.

• TLSv1.0 is disabled by default in . See and .

Major New Features To Consider

You might consider using the following major new features in :

• has been upgraded from 3 to 4.

• extended with support for .

See Also

_{This page is licensed: CC BY-SA / Gnu FDL}