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

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
    Jun 18, 2018 at 4:15

1 Answer 1

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.

4
  • Thanks for your answer. Is there any place in the official documentation where it states is not supported? (needed for a report)
    – vegatripy
    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. Jun 16, 2018 at 18:40
  • @JesusUzcanga - That is a MySQL document; the Question refers to MariaDB.
    – Rick James
    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/… Jun 19, 2018 at 14:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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