Has anyone upgraded from MariaDB 5.5 to 10?

[StealthJoe]

Is it worth upgrading to 10 from 5.5?
Is there any drawbacks?
Did anyone run into any issues?
Will I lose the partitioning I just setup?

[tim.mooney]

I haven't performed that exact upgrade yet, but it's on my todo list to do.

Based on comments from a couple of Zabbix support people in a ticket I had opened last year, they definitely encouraged my to upgrade from 5.5 to 10.2. I believe one of them even specifically commented on improved performance for some operations that was beneficial for how Zabbix uses the database.

For my Zabbix install, which is on RHEL 7.x, I get my MariaDB packages from Red Hat. This also means that the move from 5.5 to 10 and eventually 10.2 is going to be complicated, because for RHEL 7.x I will have to switch from the base OS mariadb packages to the Red Hat Software Collections Library (SCL) packages. This also means the path to the database files changes, and for my particular install, because of installation (partitioning) choices I made, the mount point for the volume is going to have to change. If it weren't for these complications, I probably already would have switched.

[BSDUKJ]

I am also looking for any information on this as want to do this in prep for eventually upgrading Zabbix to 5.0.0 as MariaDB 5.5 is not supported.

I am on CentOS 7 and running MariaDB 5.5 and from advice I've seen should upgrade to 10.1 before doing further upgrades.

I can find plenty on upgrades via google but nothing Zabbix specific.

Would be useful in the 5.0.0 documentation if there was a section on how to upgrade MariaDB from the version supported in previous Zabbix versions (5.5) to 10.1 or even a youtube video on it as this is such a big change for any Zabbix user.

If anyone knows of blogs or info out there let us know.