Просмотр новости
Найдите то, что Вас интересует
Спутники
РН
SpaceX
Роскосмос
NASA
СпутникиРНSpaceXРоскосмосNASAOn this page we have summarised information about downgrading a MariaDB/MySQL database. We do not cover migrating from MySQL to MariaDB or vice versa. For migrations (sidegrade) please look here: MySQL - MariaDB migration and here: Migration between MySQL/Percona Server and MariaDB.
The downgrade process tends to be neglected because nobody really wants to do it. So we are in swampy territory here. Unforeseen situations can occur very easily and good preparation is essential.
I can think of the following possible options for the downgrade:
Restore the backup that was made BEFORE the upgrade began.
Binary inplace downgrade (which is NOT supported in many cases).
Dump (mariadb-dump/mysqldump) of the upgraded database and restore (mariadb/mysql) to the old version (logical backup/restore).
Master/slave replication (with Statement Based Replication (SBR) or Row Based Replication (RBR)) and fallback to the slave with the old version.
Partial Backup/Restore with mariadb-backup/xtrabackup (Transportable Tablespace (TTS) method).
All these options have their advantages and disadvantages and must be carefully tested in advance.
Downgrade MariaDB
Downgrade MariaDB
Downgrading between Major Versions of MariaDB
Downgrading MariaDB is not officially supported between major versions.
First sentence in Downgrading between Major Versions of MariaDB by MariaDB Foundation.
FromDual says: But it usually works. Downgrading from minor versions practically always works.
Physical (in-place) downgrade NOT possible:
From version
To version
11.0 or later
to 10.4 or earlier: NOT possible
11.0 or later
to 10.5 or later: Possible with restrictions
10.8 or later
unclear description
10.5
to 10.4: With restrictions
10.5
to 10.3: With restrictions or problems
10.3
to 10.2: With restrictions
In addition:
Andrew Hutchings, MariaDB Foundation, 17. Mai 2024: MariaDB Dump File Compatibility Change
Downgrade …
How to downgrade MariaDB or MySQL appeared first on MariaDB.org
Tue, 2024-05-21 09:54 — Shinguz
On this page we have summarised information about downgrading a MariaDB/MySQL database. We do not cover migrating from MySQL to MariaDB or vice versa. For migrations (sidegrade) please look here: MySQL - MariaDB migration and here: Migration between MySQL/Percona Server and MariaDB.
The downgrade process tends to be neglected because nobody really wants to do it. So we are in swampy territory here. Unforeseen situations can occur very easily and good preparation is essential.
I can think of the following possible options for the downgrade:
mariadb-dump/mysqldump) of the upgraded database and restore (mariadb/mysql) to the old version (logical backup/restore).mariadb-backup/xtrabackup (Transportable Tablespace (TTS) method).All these options have their advantages and disadvantages and must be carefully tested in advance.
Downgrade MariaDBFirst sentence in Downgrading between Major Versions of MariaDB by MariaDB Foundation.Downgrading MariaDB is not officially supported between major versions.
FromDual says: But it usually works. Downgrading from minor versions practically always works.
Physical (in-place) downgrade NOT possible:| From version | To version |
|---|---|
| 11.0 or later | to 10.4 or earlier: NOT possible |
| 11.0 or later | to 10.5 or later: Possible with restrictions |
| 10.8 or later | unclear description |
| 10.5 | to 10.4: With restrictions |
| 10.5 | to 10.3: With restrictions or problems |
| 10.3 | to 10.2: With restrictions |
In addition:
First and only sentence in Downgrading MySQL (8.0) by Oracle Corp.Downgrade from MySQL 8.0 to MySQL 5.7, or from a MySQL 8.0 release to a previous MySQL 8.0 release, is not supported. The only supported alternative is to restore a backup taken before upgrading. It is therefore imperative that you back up your data before starting the upgrade process.
tags:
| # | Наименование новости | Тональность | Информативность | Дата публикации |
|---|---|---|---|---|
| 1 | Upgrading Between Major MariaDB Versions | 0 | 5.48 | 16-04-2020 |
| 2 | Upgrading MariaDB to the pre-latest minor release | 0 | 7.46 | 08-02-2023 |
| 3 | Installing the Latest MariaDB from the Repository on Debian 10 and Downgrading to Older Minor Version | 0 | 5.9 | 29-11-2020 |
| 4 | Partial physical database restore for MariaDB and MySQL | 0 | 5.64 | 02-07-2024 |
| 5 | What mysql_upgrade really does in MariaDB, Part II, Bugs and Missing Features | 0 | 9.8 | 26-01-2021 |
| 6 | Grokking the MariaDB test runner (MTR) | 0 | 6.77 | 19-02-2023 |
| 7 | Sysbench vs MariaDB on a small server: using the same charset for all versions | 0 | 8.32 | 06-04-2026 |
| 8 | FromDual Backup and Recovery Manager for MariaDB and MySQL 2.3.1 has been released | 0 | 3.77 | 12-08-2024 |
| 9 | FromDual Backup and Recovery Manager for MariaDB and MySQL 2.3.2 has been released | 0 | 4.16 | 22-10-2025 |
| 10 | MariaDB has broken the concept of dynamically configurable buffer pools! | 0 | 10.18 | 09-02-2026 |