Posted May 15May 15 This topic has come up quite a few times regarding MariaDB vs MySQL. I understand that IPS recommends MySQL 8, primarily due to its better performance on larger sites and fewer issues overall, which is why the team leans toward MySQL.That said, isn't MariaDB still a strong contender for the future? It's generally seen as more scalable and often provides faster query performance compared to MySQL.Most hosting providers these days seem to be moving toward MariaDB. In fact, I've been looking into new hosting options, and both providers I contacted are now using MariaDB by default.I also know that many communities are running MariaDB successfully on both IPS v4 and v5, and my site isn't particularly high-traffic.So, my question is: should MariaDB be considered a viable future option here? Since I'm evaluating a new host, I want to make the best long-term decision.
May 15May 15 26 minutes ago, EmpireKicking said:This topic has come up quite a few times regarding MariaDB vs MySQL. I understand that IPS recommends MySQL 8, primarily due to its better performance on larger sites and fewer issues overall, which is why the team leans toward MySQL.That said, isn't MariaDB still a strong contender for the future? It's generally seen as more scalable and often provides faster query performance compared to MySQL.Most hosting providers these days seem to be moving toward MariaDB. In fact, I've been looking into new hosting options, and both providers I contacted are now using MariaDB by default.I also know that many communities are running MariaDB successfully on both IPS v4 and v5, and my site isn't particularly high-traffic.So, my question is: should MariaDB be considered a viable future option here? Since I'm evaluating a new host, I want to make the best long-term decision.I cant say one is better than the other, but our community has 5.2million posts, 220k users, 6k users online at any given moment and we run on MariaDB 11.6 just fine. The DB is busy obviously but nothing it cant handle. If anything our php-fpm consumes a lot more CPU than MariaDB.
May 15May 15 Community Expert 30 minutes ago, EmpireKicking said:should MariaDB be considered a viable future option here?From a support perspective, you kind of mentioned at the beginning what I would state here. If you ever find yourself down that road per chance, if switching at that point to MySQL is perfectly fine with you, then its completely fine to use MariaDB and evaluate it for your needs. If that is going to cause you a lot of headaches, I am not sure you will get significant benefit out of MariaDB than MySQL these days, plus should your community grow and you run into support issues, you're on our recommended engine.
May 16May 16 6 hours ago, maddog107_merged said:I cant say one is better than the other, but our community has 5.2million posts, 220k users, 6k users online at any given moment and we run on MariaDB 11.6 just fine. The DB is busy obviously but nothing it cant handle. If anything our php-fpm consumes a lot more CPU than MariaDB.Same here 1.2 milyon posts 100K users lots of online users. Version 11.4.6-Maria DBAgree above post about Maria DB handling part... I was on MySQL for a while I wanted to try Maria DB and I do not see that much difference between two.
Sunday at 06:52 PM5 days I just upgraded to IC V5 and to do so, I needed to upgrade my MariaDB 10.3 to version 10.11 (my hosting company does not offer MySQL 8 (only MySQL 5.6 and Maria DB 10.3 or 10.11).After reading that Invision generally suggests MySQL, I was a bit worried to upgrade the MariaDB. But it all went fine, the site runs so far smoothly. Edited Sunday at 06:52 PM5 days by evcom
Sunday at 07:18 PM5 days 25 minutes ago, evcom said:my hosting company does not offer MySQL 8 (only MySQL 5.6Kinda odd that they don't offer access to a newer version of MySQL.
Sunday at 07:28 PM5 days Now that I am more into this topic of upgrading databases, I am also a bit surprised. Not so much that they don't offer MySQL, there seem to be quite a few hosting companies only offering MariaDB, but the versions are not so new anymore. 10.3 is quite old by now. 10.11 does the job though and is maintained until Feb 2028.
Sunday at 07:41 PM5 days 11 minutes ago, evcom said:there seem to be quite a few hosting companies only offering MariaDBThat's because most companies don't optimize their software for MySQL so they only offer MariaDB because it's faster out of the box compared to MySQL.
