> 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-6-to-mariadb-10-11.md).

# Upgrading from MariaDB 10.6 to MariaDB 10.11

### 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.6 to MariaDB 10.11 with Galera Cluster](/docs/galera-cluster/galera-management/upgrading-galera-cluster/upgrading-from-mariadb-10-6-to-mariadb-10-11-with-galeracluster.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.11](/docs/release-notes/community-server/10.11/what-is-mariadb-1011.md). For example,

* 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.
* 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.
* 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.

1. [Stop MariaDB](/docs/server/server-management/starting-and-stopping-mariadb/starting-and-stopping-mariadb-automatically.md).
2. 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`
3. 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) 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.
4. 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.
5. [Start MariaDB](/docs/server/server-management/starting-and-stopping-mariadb/starting-and-stopping-mariadb-automatically.md).
6. 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.6 and 10.11

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](/docs/server/server-usage/storage-engines/innodb.md) or [Mroonga](/docs/server/server-usage/storage-engines/mroonga.md) before upgrading to 10.11, those tables will be unreadable until the appropriate compression library is installed. See [Compression Plugins#Upgrading](/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-tuning-compression/compression-plugins.md#upgrading).

#### Options That Have Changed Default Values

| Option                                                                                                                                         | Old default | New default         |
| ---------------------------------------------------------------------------------------------------------------------------------------------- | ----------- | ------------------- |
| [innodb\_buffer\_pool\_chunk\_size](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_buffer_pool_chunk_size) | 134217728   | Autosized           |
| [spider\_auto\_increment\_mode](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                   | -1          | 0                   |
| [spider\_bgs\_first\_read](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                        | -1          | 2                   |
| [spider\_bgs\_mode](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                               | -1          | 0                   |
| [spider\_bgs\_second\_read](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                       | -1          | 100                 |
| [spider\_bka\_mode](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                               | -1          | 1                   |
| [spider\_bka\_table\_name\_type](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                  | -1          | 1                   |
| [spider\_buffer\_size](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                            | -1          | 16000               |
| [spider\_bulk\_size](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                              | -1          | 16000               |
| [spider\_bulk\_update\_mode](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                      | -1          | 0                   |
| [spider\_bulk\_update\_size](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                      | -1          | 16000               |
| [spider\_casual\_read](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                            | -1          | 0                   |
| [spider\_connect\_timeout](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                        | -1          | 6                   |
| [spider\_crd\_bg\_mode](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                           | -1          | 2                   |
| [spider\_crd\_interval](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                           | -1          | 51                  |
| [spider\_crd\_mode](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                               | -1          | 1                   |
| [spider\_crd\_sync](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                               | -1          | 0                   |
| [spider\_crd\_type](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                               | -1          | 2                   |
| [spider\_crd\_weight](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                             | -1          | 2                   |
| [spider\_delete\_all\_rows\_type](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                 | -1          | 1                   |
| [spider\_direct\_dup\_insert](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                     | -1          | 0                   |
| [spider\_direct\_order\_limit](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                    | -1          | 9223372036854775807 |
| [spider\_error\_read\_mode](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                       | -1          | 0                   |
| [spider\_error\_write\_mode](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                      | -1          | 0                   |
| [spider\_first\_read](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                             | -1          | 0                   |
| [spider\_init\_sql\_alloc\_size](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                  | -1          | 1024                |
| [spider\_internal\_limit](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                         | -1          | 9223372036854775807 |
| [spider\_internal\_offset](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                        | -1          | 0                   |
| [spider\_internal\_optimize](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                      | -1          | 0                   |
| [spider\_internal\_optimize\_local](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                               | -1          | 0                   |
| [spider\_load\_crd\_at\_startup](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                  | -1          | 1                   |
| [spider\_load\_sts\_at\_startup](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                  | -1          | 1                   |
| [spider\_low\_mem\_read](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                          | -1          | 1                   |
| [spider\_max\_order](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                              | -1          | 32767               |
| [spider\_multi\_split\_read](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                      | -1          | 100                 |
| [spider\_net\_read\_timeout](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                      | -1          | 600                 |
| [spider\_net\_write\_timeout](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                     | -1          | 600                 |
| [spider\_quick\_mode](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                             | -1          | 3                   |
| [spider\_quick\_page\_byte](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                       | -1          | 10485760            |
| [spider\_quick\_page\_size](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                       | -1          | 1024                |
| [spider\_read\_only\_mode](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                        | -1          | 0                   |
| [spider\_reset\_sql\_alloc](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                       | -1          | 1                   |
| [spider\_second\_read](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                            | -1          | 0                   |
| [spider\_selupd\_lock\_mode](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                      | -1          | 1                   |
| [spider\_semi\_split\_read](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                       | -1          | 2                   |
| [spider\_semi\_split\_read\_limit](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                | -1          | 1                   |
| [spider\_semi\_table\_lock\_connection](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                           | -1          | 1                   |
| [spider\_semi\_table\_lock](/docs/server/server-usage/storage-engines/spider/spider-system-variables.md)                                       | 1           | 0                   |

#### 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\_log\_write\_ahead\_size](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_log_write_ahead_size) | On Linux and Windows, the physical block size of the underlying storage is instead detected and used.    |
| [innodb\_version](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_version)                              | Redundant                                                                                                |
| [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. |

#### 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                                                                       |
| ----------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------- |
| [keep\_files\_on\_create](/docs/server/server-management/variables-and-modes/server-system-variables.md#keep_files_on_create) | MariaDB now deletes orphan files, so this setting should never be necessary. |

### See Also

* [Features in MariaDB 10.11](/docs/release-notes/community-server/10.11/what-is-mariadb-1011.md)
* [Features in MariaDB 10.10](/docs/release-notes/community-server/old-releases/10.10/what-is-mariadb-1010.md)
* [Features in MariaDB 10.9](/docs/release-notes/community-server/old-releases/10.9/what-is-mariadb-109.md)
* [Features in MariaDB 10.8](/docs/release-notes/community-server/old-releases/10.8/what-is-mariadb-108.md)
* [Features in MariaDB 10.7](/docs/release-notes/community-server/old-releases/10.7/what-is-mariadb-107.md)
* Upgrading from MariaDB 10.6 to MariaDB 10.7 with Galera Cluster
* [Upgrading from MariaDB 10.7 to MariaDB 10.8](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-to-unmaintained-mariadb-releases/upgrading-from-mariadb-10-7-to-mariadb-10-8.md)
* [Upgrading from MariaDB 10.6 to MariaDB 10.7](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-to-unmaintained-mariadb-releases/upgrading-from-mariadb-10-6-to-mariadb-10-7.md)
* [Upgrading from MariaDB 10.5 to MariaDB 10.6](/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-from-mariadb-10-5-to-mariadb-10-6.md)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}