> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-from-mariadb-10-5-to-mariadb-10-6.md). # Upgrading from MariaDB 10.5 to MariaDB 10.6 Instructions for upgrading to MariaDB 10.6, noting significant changes like the default character set switch to utf8mb3 and atomic DDL support. ### How to Upgrade For Windows, see [Upgrading MariaDB on Windows](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/platform-specific-upgrade-guides/upgrading-mariadb-on-windows.md). For MariaDB Galera Cluster, see [Upgrading from MariaDB 10.5 to MariaDB 10.6 with Galera Cluster](/docs/galera-cluster/galera-management/upgrading-galera-cluster/upgrading-from-mariadb-10-5-to-mariadb-10-6-with-galera-cluster.md). 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](/docs/server/server-usage/backup-and-restore/mariadb-backup/mariadb-backup-overview.md). The suggested upgrade procedure is: 1. Modify the repository configuration, so the system's package manager installs [MariaDB 10.6](/docs/release-notes/community-server/10.6/what-is-mariadb-106.md). 1. On Debian, Ubuntu, and other similar Linux distributions, see [Updating the MariaDB APT repository to a New Major Release](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-deb-files.md#updating-the-mariadb-apt-repository-to-a-new-major-release) for more information. 2. On RHEL, CentOS, Fedora, and other similar Linux distributions, see [Updating the MariaDB YUM repository to a New Major Release](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/rpm/yum.md#updating-the-mariadb-yum-repository-to-a-new-major-release) for more information. 3. On SLES, OpenSUSE, and other similar Linux distributions, see [Updating the MariaDB ZYpp repository to a New Major Release](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/rpm/installing-mariadb-with-zypper.md#updating-the-mariadb-zypp-repository-to-a-new-major-release) for more information. 2. [Stop MariaDB](/docs/server/server-management/starting-and-stopping-mariadb/starting-and-stopping-mariadb-automatically.md). 3. Uninstall the old version of MariaDB. 1. On Debian, Ubuntu, and other similar Linux distributions, execute the following: `sudo apt-get remove mariadb-server` 2. On RHEL, CentOS, Fedora, and other similar Linux distributions, execute the following: `sudo yum remove MariaDB-server` 3. On SLES, OpenSUSE, and other similar Linux distributions, execute the following: `sudo zypper remove MariaDB-server` 4. Install the new version of MariaDB. 1. On Debian, Ubuntu, and other similar Linux distributions, see [Installing MariaDB Packages with APT](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/installing-mariadb-deb-files.md#installing-mariadb-packages-with-apt) for more information. 2. On RHEL, CentOS, Fedora, and other similar Linux distributions, see [Installing MariaDB Packages with YUM](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/rpm/yum.md#installing-mariadb-packages-with-yum-dnf) for more information. 3. On SLES, OpenSUSE, and other similar Linux distributions, see [Installing MariaDB Packages with ZYpp](/docs/server/server-management/install-and-upgrade-mariadb/installing-mariadb/binary-packages/rpm/installing-mariadb-with-zypper.md#installing-mariadb-packages-with-zypp) for more information. 5. Make any desired changes to configuration options in [option files](/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files.md), such as `my.cnf`. This includes removing any options that are no longer supported. 6. [Start MariaDB](/docs/server/server-management/starting-and-stopping-mariadb/starting-and-stopping-mariadb-automatically.md). 7. Run [mariadb-upgrade](/docs/server/clients-and-utilities/deployment-tools/mariadb-upgrade.md), to: 1. Ensure that the system tables in the [mysql](/docs/server/reference/system-tables/the-mysql-database-tables.md) database are fully compatible with the new version. 2. Perform a very quick check of all tables and marks them as compatible with the new version of MariaDB. ### Incompatible Changes Between 10.5 and 10.6 On most servers upgrading from 10.5 should be painless. However, there are some things that have changed which could affect an upgrade: The behaviour of sorting non-deterministic variables in a Select query can be changed , see ([MDEV-27745](https://jira.mariadb.org/browse/MDEV-27745)) #### Reserved Word * New [reserved word](/docs/server/reference/sql-structure/sql-language-structure/reserved-words.md): `OFFSET`. This can no longer be used as an [identifier](/docs/server/reference/sql-structure/sql-language-structure/identifier-names.md) without being quoted. #### InnoDB COMPRESSED Row Format From MariaDB 10.6.0 until MariaDB 10.6.5, tables that are of the `COMPRESSED` row format are read-only by default. This was intended to be the first step towards removing write support and deprecating the feature. This plan has been scrapped, and from MariaDB 10.6.6, `COMPRESSED` tables are no longer read-only by default. From MariaDB 10.6.0 to MariaDB 10.6.5, set the [innodb\_read\_only\_compressed](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_read_only_compressed) variable to `OFF` to make the tables writable. #### Character Sets From MariaDB 10.6, the `utf8` [character set](/docs/server/reference/data-types/string-data-types/character-sets.md) (and related collations) is by default an alias for `utf8mb3` rather than the other way around. It can be set to imply `utf8mb4` by changing the value of the [old\_mode](/docs/server/server-management/variables-and-modes/server-system-variables.md#old_mode) system variable. #### Options That Have Changed Default Values | Option | Old default value | New default value | | ------------------------------------------------------------------------------------------------------------------------------------ | ----------------- | ----------------- | | [character\_set\_client](/docs/server/server-management/variables-and-modes/server-system-variables.md#character_set_client) | utf8 | utf8mb3 | | [character\_set\_connection](/docs/server/server-management/variables-and-modes/server-system-variables.md#character_set_connection) | utf8 | utf8mb3 | | [character\_set\_results](/docs/server/server-management/variables-and-modes/server-system-variables.md#character_set_results) | utf8 | utf8mb3 | | [character\_set\_system](/docs/server/server-management/variables-and-modes/server-system-variables.md#character_set_system) | utf8 | utf8mb3 | | [innodb\_flush\_method](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_flush_method) | fsync | O\_DIRECT | | [old\_mode](/docs/server/server-management/variables-and-modes/server-system-variables.md#old_mode) | Empty | UTF8\_IS\_UTF8MB3 | #### Options That Have Been Removed or Renamed The following options should be removed or renamed if you use them in your [option files](/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files.md): | Option | Reason | | ------------------------------------------------------------------------------------------------------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | innodb\_adaptive\_max\_sleep\_delay | | | innodb\_background\_scrub\_data\_check\_interval | | | innodb\_background\_scrub\_data\_compressed | | | innodb\_background\_scrub\_data\_interval | | | innodb\_background\_scrub\_data\_uncompressed | | | innodb\_buffer\_pool\_instances | | | [innodb\_checksum\_algorithm](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_checksum_algorithm) | The variable is still present, but the \*innodb and \*none options have been removed as the crc32 algorithm only is supported from [MariaDB 10.6](/docs/release-notes/community-server/10.6/what-is-mariadb-106.md). | | innodb\_commit\_concurrency | | | innodb\_concurrency\_tickets | | | innodb\_file\_format | | | innodb\_large\_prefix | | | innodb\_lock\_schedule\_algorithm | | | innodb\_log\_checksums | | | innodb\_log\_compressed\_pages | | | innodb\_log\_files\_in\_group | | | innodb\_log\_optimize\_ddl | | | innodb\_page\_cleaners | | | innodb\_replication\_delay | | | innodb\_scrub\_log | | | innodb\_scrub\_log\_speed | | | innodb\_sync\_array\_size | | | innodb\_thread\_concurrency | | | innodb\_thread\_sleep\_delay | | | innodb\_undo\_logs | | #### Deprecated Options The following options have been deprecated. They have not yet been removed, but will be in a future version, and should ideally no longer be used. | Option | Reason | | -------------------------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------- | | [wsrep\_replicate\_myisam](/docs/galera-cluster/reference/galera-cluster-system-variables.md#wsrep_replicate_myisam) | Use [wsrep\_mode](/docs/galera-cluster/reference/galera-cluster-system-variables.md#wsrep_mode) instead. | | [wsrep\_strict\_ddl](/docs/galera-cluster/reference/galera-cluster-system-variables.md#wsrep_strict_ddl) | Use [wsrep\_mode](/docs/galera-cluster/reference/galera-cluster-system-variables.md#wsrep_mode) instead. | ### Major New Features To Consider * See also [System Variables Added in MariaDB 10.6](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/community-server/system-variables-added-in-mariadb-10-6.md). ### See Also * [Features in MariaDB 10.6](/docs/release-notes/community-server/10.6/what-is-mariadb-106.md) * [Upgrading from MariaDB 10.5 to MariaDB 10.6 with Galera Cluster](/docs/galera-cluster/galera-management/upgrading-galera-cluster/upgrading-from-mariadb-10-5-to-mariadb-10-6-with-galera-cluster.md) *This page is licensed: CC BY-SA / Gnu FDL* {% @marketo/form formId="4316" %}