Upgrading from MariaDB 10.6 to MariaDB 10.7
Contents
Note that MariaDB 10.7 is only maintained for one year. MariaDB 10.6 is currently the latest long-term maintenance release.
How to Upgrade
For Windows, see Upgrading MariaDB on Windows.
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 Mariabackup.
The suggested upgrade procedure is:
- Modify the repository configuration, so the system's package manager installs MariaDB 10.7. For example,
- On Debian, Ubuntu, and other similar Linux distributions, see Updating the MariaDB APT repository to a New Major Release for more information.
- On RHEL, CentOS, Fedora, and other similar Linux distributions, see Updating the MariaDB YUM repository to a New Major Release for more information.
- On SLES, OpenSUSE, and other similar Linux distributions, see Updating the MariaDB ZYpp repository to a New Major Release for more information.
- Stop MariaDB.
- 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
- On Debian, Ubuntu, and other similar Linux distributions, execute the following:
- Install the new version of MariaDB.
- On Debian, Ubuntu, and other similar Linux distributions, see Installing MariaDB Packages with APT for more information.
- On RHEL, CentOS, Fedora, and other similar Linux distributions, see Installing MariaDB Packages with YUM for more information.
- On SLES, OpenSUSE, and other similar Linux distributions, see Installing MariaDB Packages with ZYpp for more information.
- Make any desired changes to configuration options in option files, such as
my.cnf
. This includes removing any options that are no longer supported. - Start MariaDB.
- Run mariadb-upgrade.
mariadb-upgrade
does two things:- Ensures that the system tables in the mysql database are fully compatible with the new version.
- Does a very quick check of all tables and marks them as compatible with the new version of MariaDB .
Incompatible Changes Between 10.6 and 10.7
On most servers upgrading from 10.6 should be painless. However, there are some things that have changed which could affect an upgrade:
Compression
If a non-zlib compression algorithm was used in InnoDB or Mroonga before upgrading to 10.7, those tables will be unreadable until the appropriate compression library is installed. See Compression Plugins#Upgrading.
Options That Have Changed Default Values
Option | Old default | New default |
---|---|---|
spider_auto_increment_mode | -1 | 0 |
spider_bgs_first_read | -1 | 2 |
spider_bgs_mode | -1 | 0 |
spider_bgs_second_read | -1 | 100 |
spider_bka_mode | -1 | 1 |
spider_bka_table_name_type | -1 | 1 |
spider_buffer_size | -1 | 16000 |
spider_bulk_size | -1 | 16000 |
spider_bulk_update_mode | -1 | 0 |
spider_bulk_update_size | -1 | 16000 |
spider_casual_read | -1 | 0 |
spider_connect_timeout | -1 | 6 |
spider_crd_bg_mode | -1 | 2 |
spider_crd_interval | -1 | 51 |
spider_crd_mode | -1 | 1 |
spider_crd_sync | -1 | 0 |
spider_crd_type | -1 | 2 |
Options That Have Been Removed or Renamed
The following options should be removed or renamed if you use them in your option files:
Option | Reason |
---|---|
wsrep_replicate_myisam | Use wsrep_mode instead. |
wsrep_strict_ddl | Use wsrep_mode instead. |