Doubts about Upgrading to Mysql 8

[abisbe]

Hi everyone, I'm thinking to upgrade the DB of m 7.3.4 ESPO from Mysql 7 to Mysql 8. Is this recommended? is it gonna be troublesome?

I'm finding this on the Sites documentation and I'm not fully understanding it. Do I need to change all the passwords of all the users? or is it just something to do once in configuration?

Basically, my question is, would you upgrade it? or the hassle will be greater than the benefit?

Thank you all.

PS: And of course now that I posted it I just understood that this is just for the MYSQL user, so that should be fairly simple and a single operation needed, am I right?

[Vadym]

Hi abisbe,

Please provide screenshot of Administration -> System Requirements to investigate this case in more details.

[abisbe]

Hi Vadym, I think here you have all the info you need.

[yuri]

I recommend upgrading to MariaDB. It has much better performance with some queries: filtering by teams, link-multiple fields, mutli-enums.

[DashingUno]

Does that recommendation apply generally, or is it EspoCRM 7.4.* specific?

In our tests on 7.2.* MySQL outperforms MariaDB, we still opted for MariaDB 10.8.3 though, so for 7.4.* migration we thought we should switch to MySQL, is MariaDB more optimized in 7.4.* ?

[abisbe]

We have this too, since updating to 7.3.4 which is the nº of time these queries are called, and which is a Looot more than what we had previous of update, will this be solved by upgrading to MariaDB?

[yuri]

The first two should be called unless you doing rebuild or checking system requirementse page.

[abisbe]

Just so I understand it correctly, the first two queries would only be called if we are doing a rebuild or checking the system requirements page, so clearly there's something wrong with my system, am I right?

Thank you.