IP.Board Does anyone uses Invision forums 4.x with MariaDB 11.4.x or 11.8?

Invision 4.x user here though I'm currently at 10.6 as that was at the limit of centminmod the last time I was looking to update the database.

From this thread it looks like 11.x version of mariadb have been successful though Invision is built for MySQL.
https://invisioncommunity.com/forum...s-and-hosting-considerations/#comment-3020096

Are you aware that Invision 4.x EOF is the end of the year? 5.x is currently available.

I'll probably go to Maria 10.11 and sit there for a while unless i find some compelling reason to upgrade to Maria 11.x

 

I've been running MariaDB 11.4 on a few Centmin Mod instances with IPS 4.7, and honestly, the performance gains in query optimization are noticeable, especially on larger posts tables.

A few things to keep in mind:

Compatibility: IPS 4.x handles 11.4 fine, but 11.8 is still very bleeding edge. I’d stick with 11.4 (LTS) for a production forum to keep things stable.

Config: Make sure you re-run centmin.sh menu option 4 after upgrading to ensure your my.cnf settings are tuned for the new version's memory handling.

Backups: Before you jump, do a full mysqldump. MariaDB 11.x changes some defaults regarding authentication and grants that can occasionally trip up older connection scripts.

Overall, it's a solid upgrade if you're looking for better indexing efficiency, but definitely go the 11.4 route.

 

It doesn't seem like the current betas of centminmod (140.00, 141.00) support upgrading to 11.4

 

Yes you can, add this to your custom_config:

Code (Text):

ENABLE_MARIADBELEVENFOURUPGRADE='y'

Then run centmin(141) -> 11 -> 12

 

That enable code did the trick. Thank you!

 

I was able to successfully upgrade from MariaDB 10.6.x to 11.4.x on a couple of instances but for both my CPU load averages are running much higher than previously to the point where they spiral out of control. I've tried going through the config to the best of my ability but hasn't seemed to help. I'll take any suggestions/help.

If you're on a version of MariaDB that works for you, don't move.

 

Hmm, I did the same but no problems with high loads here...

 

It turns out that about the same time I decided to upgrade database versions, I was getting scraped by bots.
At the end of the day, I was able to successfully update both of my sites with no issues, besides going nuts for a day.