I can explain this a few ways and coming from me its all going be me being an ahole.
If your support is upgrading entire server DB's, the only question you really need to ask them before going ahead, is whether they are backing up databases prior to upgrading. If they have that, then all is well.Server support informs me that MySQL will become MariaDB 10.0.
MariaDB is a drop-in replacement, totally interchangeable.Will this upgrade work on Xenforo?
You should upgrade to MariaDB 10.1, actually. It has even better performance and stability.Should I upgrade to MariaDB 10.0 and why?
Whilst a little naughty, and this statement was to be cautious and stick with stable versions, I actually use the latest 10.2 MariaDB nowadays, as it has some significant default changes, compression being one. Prior to, you had to configure such at build.You should upgrade to MariaDB 10.1, actually. It has even better performance and stability.