MySQL v5.6 to v8 or compatible v10 MariaDB ?

[Ryo Saeba]

hello IPS, 

we have our forum hosted with Informanik in Switzerland and our DB is MySQL version 5.6 and you recommend to upgrade to version 8 or higher for the next IVP update.

Informanik recommend we migrate our MySQL 5.6 DB to MariaDB version 10, can we upgrade to that DB and have no problems with your update soon please ?

I understand that MarieDB is recommended for for speed, but I don't know if IVP software is compatible because it is on MySQL. Or is there no difference between the two types of DB for our forum to function correctly ?
 
Also our database has InnoDB Compact tables and we want to make them Dynamic if possible without worrying about memory space. Can you update it or tell me how to proceed please ? 

thank you for your help and attention,

anthony

[Jim M]

We recommend MySQL 8 over MariaDB but MariaDB is a drop in replacement for MySQL. So long as you're running a compatible version MariaDB to MySQL.

You would need to have your hosting provider convert the tables from InnoDB compact to Dynamic. This is a hosting provider responsibility to manage row formats like this.

[Ryo Saeba]

thanks for the fast reply jim,

so your recommended option is 1 but 2 works fine ?

1. i will ask if possible to run MySQL but upgrade to v8 or higher.

2. if not possible optin 1 i will ask to migrate to MariaDB 10.

when the DB is updated complet the update for our IVP forum.

i will ask them to sort the tables out as well.

thanks,

anthony

 

[Jim M]

At this time we only support MySQL 8 (or the MariaDB compatible version of that). Any future releases would be assessed at that time. 

[Afrodude]

Using MariaDB v11.4.4, and everything running fine.

[Marc]

The software is optimised to work efficiently on mysql 8.0. There are many people who use mariadb and use it fine. There are others who are using it (particularly in a recent topic) who are finding that not to be the case. What I would do is to ask yourself, if you arent using what we specifically optimise for, why would you be doing that? Of course you may have good reason 🙂 

[bearback]

Recommending to use MySQL over mariadb seems to have changed, i clearly remember mariadb being recommended. 

[Marc]

46 minutes ago, bearback said:

Recommending to use MySQL over mariadb seems to have changed, i clearly remember mariadb being recommended. 

We would always recommend mySQL

[Ryo Saeba]

thanks for all the advice and ill ask for MySQL 8 update if possible.

if not we will have to go with MariaDB 10 and take it from there.

cheers,

anthony

 

[Miso]

On 11/23/2024 at 9:26 PM, Afrodude said:

Using MariaDB v11.4.4, and everything running fine.

Same here.

Actually prefer MariaDB for speed and faster updates + error logging plugin... 

[SeNioR-]

On 11/26/2024 at 3:31 PM, Miso said:

Same here.

Actually prefer MariaDB for speed and faster updates + error logging plugin... 

MariaDB is undoubtedly more effective. Google, Amazon and Microsoft are using this fork and these are not small companies 👀

https://mariadb.org/how-mariadb-and-mysql-performance-changed-over-releases/

[Gary]

They're small compared to Invision Community...