# Upgrading from MariaDB 10.6 to MariaDB 10.11 ### How to Upgrade For Windows, see [Upgrading MariaDB on Windows](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/upgrading/platform-specific-upgrade-guides/upgrading-mariadb-on-windows). For MariaDB Galera Cluster, see [Upgrading from MariaDB 10.6 to MariaDB 10.11 with Galera Cluster](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/galera-management/upgrading-galera-cluster/upgrading-from-mariadb-10-6-to-mariadb-10-11-with-galeracluster). 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](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/mariadb-backup-overview). The suggested upgrade procedure is: 1. Modify the repository configuration, so the system's package manager installs [MariaDB 10.11](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.11/what-is-mariadb-1011). For example, * On Debian, Ubuntu, and other similar Linux distributions, see [Updating the MariaDB APT repository to a New Major Release](https://mariadb.com/docs/server/server-management/installing-mariadb/binary-packages/installing-mariadb-deb-files#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](https://mariadb.com/docs/server/server-management/installing-mariadb/binary-packages/rpm/yum#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](https://mariadb.com/docs/server/server-management/installing-mariadb/binary-packages/rpm/installing-mariadb-with-zypper#updating-the-mariadb-zypp-repository-to-a-new-major-release) for more information. 1. [Stop MariaDB](https://mariadb.com/docs/server/server-management/starting-and-stopping-mariadb/starting-and-stopping-mariadb-automatically). 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](https://mariadb.com/docs/server/server-management/installing-mariadb/binary-packages/installing-mariadb-deb-files#installing-mariadb-packages-with-apt) for more information. 2. On RHEL, CentOS, Fedora, and other similar Linux distributions, see [Installing MariaDB Packages with YUM](https://mariadb.com/docs/server/server-management/installing-mariadb/binary-packages/rpm/yum#installing-mariadb-packages-with-yum) for more information. 3. On SLES, OpenSUSE, and other similar Linux distributions, see [Installing MariaDB Packages with ZYpp](https://mariadb.com/docs/server/server-management/installing-mariadb/binary-packages/rpm/installing-mariadb-with-zypper#installing-mariadb-packages-with-zypp) for more information. 4. Make any desired changes to configuration options in [option files](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files), such as `my.cnf`. This includes removing any options that are no longer supported. 5. [Start MariaDB](https://mariadb.com/docs/server/server-management/starting-and-stopping-mariadb/starting-and-stopping-mariadb-automatically). 6. Run [mariadb-upgrade](https://mariadb.com/docs/server/clients-and-utilities/deployment-tools/mariadb-upgrade), to: 1. Ensure that the system tables in the [mysql](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables) 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](https://mariadb.com/docs/server/server-usage/storage-engines/innodb) or [Mroonga](https://mariadb.com/docs/server/server-usage/storage-engines/mroonga) before upgrading to 10.11, those tables will be unreadable until the appropriate compression library is installed. See [Compression Plugins#Upgrading](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-tuning-compression/compression-plugins#upgrading). #### Options That Have Changed Default Values | Option | Old default | New default | | -------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------- | ------------------- | | [innodb\_buffer\_pool\_chunk\_size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_buffer_pool_chunk_size) | 134217728 | Autosized | | [spider\_auto\_increment\_mode](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 0 | | [spider\_bgs\_first\_read](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 2 | | [spider\_bgs\_mode](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 0 | | [spider\_bgs\_second\_read](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 100 | | [spider\_bka\_mode](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 1 | | [spider\_bka\_table\_name\_type](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 1 | | [spider\_buffer\_size](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 16000 | | [spider\_bulk\_size](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 16000 | | [spider\_bulk\_update\_mode](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 0 | | [spider\_bulk\_update\_size](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 16000 | | [spider\_casual\_read](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 0 | | [spider\_connect\_timeout](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 6 | | [spider\_crd\_bg\_mode](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 2 | | [spider\_crd\_interval](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 51 | | [spider\_crd\_mode](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 1 | | [spider\_crd\_sync](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 0 | | [spider\_crd\_type](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 2 | | [spider\_crd\_weight](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 2 | | [spider\_delete\_all\_rows\_type](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 1 | | [spider\_direct\_dup\_insert](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 0 | | [spider\_direct\_order\_limit](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 9223372036854775807 | | [spider\_error\_read\_mode](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 0 | | [spider\_error\_write\_mode](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 0 | | [spider\_first\_read](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 0 | | [spider\_init\_sql\_alloc\_size](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 1024 | | [spider\_internal\_limit](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 9223372036854775807 | | [spider\_internal\_offset](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 0 | | [spider\_internal\_optimize](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 0 | | [spider\_internal\_optimize\_local](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 0 | | [spider\_load\_crd\_at\_startup](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 1 | | [spider\_load\_sts\_at\_startup](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 1 | | [spider\_low\_mem\_read](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 1 | | [spider\_max\_order](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 32767 | | [spider\_multi\_split\_read](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 100 | | [spider\_net\_read\_timeout](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 600 | | [spider\_net\_write\_timeout](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 600 | | [spider\_quick\_mode](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 3 | | [spider\_quick\_page\_byte](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 10485760 | | [spider\_quick\_page\_size](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 1024 | | [spider\_read\_only\_mode](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 0 | | [spider\_reset\_sql\_alloc](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 1 | | [spider\_second\_read](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 0 | | [spider\_selupd\_lock\_mode](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 1 | | [spider\_semi\_split\_read](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 2 | | [spider\_semi\_split\_read\_limit](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 1 | | [spider\_semi\_table\_lock\_connection](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | -1 | 1 | | [spider\_semi\_table\_lock](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | 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](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files): | Option | Reason | | ---------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------- | | [innodb\_log\_write\_ahead\_size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_log_write_ahead_size) | On Linux and Windows, the physical block size of the underlying storage is instead detected and used. | | [innodb\_version](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_version) | Redundant | | [wsrep\_replicate\_myisam](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_replicate_myisam) | Use [wsrep\_mode](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_mode) instead. | | [wsrep\_strict\_ddl](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_strict_ddl) | Use [wsrep\_mode](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#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](https://mariadb.com/docs/server/variables-and-modes/server-system-variables#keep_files_on_create) | MariaDB now deletes orphan files, so this setting should never be necessary. | ### See Also * [Features in MariaDB 10.11](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.11/what-is-mariadb-1011) * [Features in MariaDB 10.10](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.10/what-is-mariadb-1010) * [Features in MariaDB 10.9](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.9/what-is-mariadb-109) * [Features in MariaDB 10.8](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.8/what-is-mariadb-108) * [Features in MariaDB 10.7](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.7/what-is-mariadb-107) * [Upgrading from MariaDB 10.6 to MariaDB 10.7 with Galera Cluster](https://github.com/mariadb-corporation/docs-server/blob/test/server/server-management/getting-installing-and-upgrading-mariadb/upgrading/upgrading-from-mariadb-106-to-mariadb-107-with-galera-cluster/README.md) * [Upgrading from MariaDB 10.7 to MariaDB 10.8](https://mariadb.com/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) * [Upgrading from MariaDB 10.6 to MariaDB 10.7](https://mariadb.com/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) * [Upgrading from MariaDB 10.5 to MariaDB 10.6](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) *This page is licensed: CC BY-SA / Gnu FDL* {% @marketo/form formId="4316" %}