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

  • 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 '18 at 4:15

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.

  • 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 '18 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 Jun 16 '18 at 18:40
  • @JesusUzcanga - That is a MySQL document; the Question refers to MariaDB. – Rick James Jun 18 '18 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 Jun 19 '18 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.