EspoCRM 5.8.0 released

[yuri]

You can switch to MariaDB w/o problems. No any actions required.

[esforim]

I been talking to some of these host, and it seem some of them only install MariaDB.

If I most hosting to them, will my current database that use MySQL be usable on MariaDB? Or will I need to do some Database conversion?

[telecastg]

Thanks murugappan

[yuri]

mysql 5.6: end of support: Feb 2018; ext. support end: Feb 2021

5.6 and 5.7 have some differences and it was hard for us to support 5.6. We often had bugs because of that.

[esforim]

Refer to this post for end of 5.6: https://forum.espocrm.com/forum/anno...5667#post55667

There may have been warning on the Git but I don't monitor it so not sure, perhaps there are many code that is reliance on mySQL 5.7 already and with the release of 5.8 it become mandatory.

Or there may be virtually no code at all but a decision need to be make for the upcoming 5.9 or v6.0 where mySQL 5.7 is required.

[esforim]

Will check them out. I made a post here that might interest people who are struck with 5.6 MySQL and need to look for new host.

https://forum.espocrm.com/forum/general/54706-learning-espocrm-and-design?p=55658#post55658

It too bad they don't have Live chat. I want to ask them about their Shared Hosting.

[murugappan]

This is my recommendation records MySQL Servers.

(1) Do not migrate to version 8.x. Lots of migration issues plus Oracle wants to nail us for licensing. That's my take on it.
(2) I am not sure if there is a version 5.8. Oracle jumped to version 8.x solely to take us to the licensing part . If you are small to medium size this does not really matter. Enterprise level is good to migrate to 8.0 but lots of testing to be done with the irritation of Oracle releasing updates in between.
(3) We were thinking either migrate 5.7 or MariaDB. Your code will not change (not that i am aware of) in either case.
(4) If you are on 5.6, its good to migrate but need to do lots of testing. We wanted to do that last year and really didnt do anything except to switch over into another VPS and tested it live for 1 month. We stopped it mid way due lots of projects at hand.

One thing puzzles me. Why stop support of MySQL 5.6 when the end of life is only February 2021 which 2 years from now? Isnt this too premature and also without lead time? Its going to be a big decision for us to make when we have so much going on now.

[murugappan]

Just found out that my hosting service siteground.com doesn't have yet MySql 5.7 and no timeline to support it, any suggestions on other providers and has anyone installed EspoCRM on Azure or Amazon AWS ? I am considering migrating to cloud services.

Hi,

Try out the following provider: We have been using them for 3 years and absolutely no problem, fantastic support, always maintains your servers effectively, We have 4 dedicated servers with them and 6 vps servers for public use. Contact: https://www.exabytes.com

[dimyy]

I see version 5.8.1 with 0 tickets closed. What's this?

[esforim]

Notice the update. Thank you.

Yes it is a shame but at least this way I look for a better alternative hosting which I been delaying for far too long.

[esforim]

Is MySQL 8 the same as MySQL 5.8? Was going to be my question but then I read the Wiki page. What happen to v6 and v7, funny.

That good to hear regarding MySQL 8, what the plan for EspoCRM regarding that? Is EspoCRM 6+ will be MySQL 8 as requirement? Or it more like EspoCRM 7+?

Guess we are stuck with 5.7 for a while, which is the latest version anyway. 8 is too new for most people to support.

[dev77]

I had (and have) the option to go to MySQL 8 but I use a photo gallery server called Piwigo https://piwigo.org/ and that system has had some difficulties with MySQL 8. When Espo requires version 8 that is when I'll go to it... and I read somewhere in one of the forums here that Espo has a few issues with it.

[yuri]

There were major performance improvements in MySQL 8.

[yuri]

It's a shame that so many hosting providers keep their environment outdated. I recommend to stay away from such. Both mysql 5.6 and php 7.1 are not supported by vendors anymore. And both used to impede a development process of EspoCRM. By dropping their support it makes our work much easier.

[dev77]

I updated to MySQL 5.7 and the install went just fine and everything works as it should. So far I've not seen any speed improvement from the previous database server version to this one... or any difference between Espo 5.8 and the previous version.