3

We have a database running in MariaDB 5.5.60 and we want to upgrade it to the last 10.3.7 version.

However I'm looking at MariaDB knowledge base ( https://mariadb.com/kb/en/library/upgrading/ ) and I'm not sure if we can perform a direct in-place upgrade from 5.5 to 10.3, or we should perform a "step by step" upgrade (5.5 > 10.0 > 10.1 > 10.2 > 10.3 ).

All the documentation I see in the oficial MariaDB knowledge base seems to suggest to do a in-place step by step upgrade (furthermore, looks like a logical upgrade with mysqldump cannot be permormed from 10.2 to 10.3), however I've seen some other examples in blogs where a direct in-place upgrade from 5.5 to 10.2 seems possible ( http://www.linuxtopic.com/2017/10/upgrade-mariadb-5.2-to-10.2.html ).

Any help? Regards

Improve this question
1
  • Try mysql_upgrade for update using the 10.3 version of mysql_upgrade. My notes say that MariaDB node not require the step-by-step process, but I have no proof.
    – Rick James
    Commented Jun 18, 2018 at 4:15

1 Answer 1

Reset to default
4

The whole jump it is possible (depends on your data structure) but is not recommended and based on official documentation is not supported.

The best option is to perform and step-by-step IN-PLACE upgrade so you will only do a mysqldump before start to backup everything then just install every version and run mysql_upgrade then continue with next version and so on.

Improve this answer
4
  • Thanks for your answer. Is there any place in the official documentation where it states is not supported? (needed for a report)
    – vegatripy
    Commented Jun 15, 2018 at 9:58
  • Of course... The official docs link: dev.mysql.com/doc/refman/8.0/en/upgrading-strategies.html Upgrade that skips versions is not supported. For example, upgrading directly from MySQL 5.6 to 8.0 is not supported.
    – Jesus Uzcanga
    Commented Jun 16, 2018 at 18:40
  • @JesusUzcanga - That is a MySQL document; the Question refers to MariaDB.
    – Rick James
    Commented Jun 18, 2018 at 4:03
  • MySQL and MariaDB still share same principles about upgrading because MariaDB must remain open doors for MySQL to MariaDB crossovers. If you're looking for a most MariaDB answer: mariadb.com/kb/en/library/…
    – Jesus Uzcanga
    Commented Jun 19, 2018 at 14:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.