I am moving old cpanel server/os to a new Rocky Linux - the default has MariaDB should I switch to MySQL or stick with Maria? ( still on v4 will upgrade once I move )

We advise on mysql 8, as this is what we optimise for

Thanks @Marc

Does v4 work on Maria? I am kind of in a stuck state - I am standing up this new server with a copy of v4 on the site but of course it has Maria on it. when I go to the directory I just see "not supported" My goal is just to move to a new server then upgrade to v5.

When I looked at cpanel they have this big warning that MySQL is not supported, and considered a downgrade.

based on this
https://invisioncommunity.com/forums/topic/481462-maria-db-for-ic-5/#findComment-2989802

was hoping it was promising.

My hosting provider mentioned I could go with some managed database cluster (probably at more expense)

MariaDB is a drop-in replacement for MySQL and it will work with both version 4 and 5. However, we specifically optimize for MySQL so while MariaDB may work, if you have a heavily trafficked site, it may encounter performance issues where our suggestion may just be to switch to MySQL to take advantage of those optimizations which MySQL has.

On 5/9/2025 at 7:37 PM, Ocean West said:

Does v4 work on Maria?

I'm also using MariaDB version 10.11 along with Almalinux 9 and WHM/CPanel, since January 2025, when I made a server migration.

My community is version 4.7 and working fine (except yesterday, I encountered a problem with splitting a topic, but I think it was related to a server problem).

MariaDB is an opensource version of MySQL. It is compatible with MySQL databases. SQL commands, data types are the same. Your MySQL databases can be transferred to MariaDB without any modifications. All you will have to do is restore your backups in CPanel. It worked just fine for my board and a few Joomla websites.

I prefered not to switch to MySQL and gave MariaDB a try, since it was the default installation on my new server. Moreover, trying first to use MySQL instead of MariaDB messed things (I got error messages) and I'm not good enougth to fix this kind of server problems.

Edited Sunday at 07:44 PM2 days by SecondSight

On 5/9/2025 at 7:37 PM, Ocean West said:

When I looked at cpanel they have this big warning that MySQL is not supported

Then, the solution would be to get rid of CPanel/WHM (and save a lot of money). I would have done it if I had been aware of this problem...

On 5/8/2025 at 3:10 AM, Marc said:

We advise on mysql 8, as this is what we optimize for

MariaDB is becoming the standard install for CPanel, Plesk installs.

5 minutes ago, CheersnGears said:

MariaDB is becoming the standard install for CPanel, Plesk installs.

We will optimise for mysql 8 :)

i understand what you're saying, dont get me wrong.