Upgrading from 5.21.0: need advice

1

Hi everyone,
I may be in charge of updating a Mattermost v5.21 instance – I’m trying to confirm what I’ve deduced from the official documentation about updates, and I have a few more questions.

Starting version is an old one: 5.21.0, on Ubuntu 18.04, w/ mysql 5.7.
(The server is virtualized, so I will be able to test/work on a copy at each step)

If I’ve understood correctly, migrations from ESR to ESR+1 are fully supported.
AFAICT the migration plan would therefore be:

  • 5.21 to next ESR:
    • v5.22.3
    • v5.23.2
    • v5.24.3
    • v5.25.7 (ESR)
  • then from ESR to ESR:
    • v5.25.7
    • v5.31.9
    • v5.37.10
    • v6.3.10
    • v7.1.9
    • v7.8.15
    • v8.1.13
    • v9.5.8
    • v9.11.0 (latest, 2024/08/19)
      is this correct?

I also noted that “From Mattermost v8.0, PostgreSQL is our database of choice for Mattermost”: should we consider migrating to postgresql after updating to MM v8.1.13, or can we do the mysql→postgresql migration after the switch to MM 9.11?

Last question: is it possible to do all this before migrating to Ubuntu 24.04?
In particular, I haven’t been able to find out from which version of mattermost you need to upgrade from mysql 5.7 to mysql 8.0.

Thank you in advance for any useful information you may have on what could be a rather intricate upgrade.
__ Sébastien.

2

MySQL is still supported (deprecated in 11.x) so I don’t know that there’s a “best time” to handle that migration.

Unsupported legacy releases - Mattermost documentation has lots of mentions of MySQL. Then I found Removed and deprecated features - Mattermost documentation which tells us that 9.5 is the last version to support MySQL 5.7

1 Like
3

Thank you John for this information and the links, very useful. It allows me to consider making the transition mysql→postgresql as a second step.

The installation guide for Ubuntu lists Ubuntu 20.04 as the minimum system requirements. I understand that this applies to new installation, but as far as upgrading is concerned, should I expect any problems when upgrading to MM 9.11 on Ubuntu 18.04? Or to put it differently, should I consider migrating the MM 5.21 to Ubuntu 20.04+ first ?
__ Sébastien.

4

Mattermost doesn’t really care all that much about the underlying OS. You could literally copy-and-paste your/opt/mattermost directory from Ubunto to RHEL or vice-versa.

In your case, I’d probably get the OS upgraded first. It isn’t a huge deal to us… we just dropped official support because Ubuntu 18 is EOL. But if you run into odd issues, it’s easier to help with a newer, supported OS.

1 Like
5

Thank you very much John, these informations & advice help me to plan the update in an informed manner.