Jump to content
MoritzLost

MySQL 8 compatibility and MariaDB replacements

Recommended Posts

I'm searching for some information regarding supported MySQL versions, since we need to prepare for an update to MySQL 8 (Hosteurope is updating their servers ...). All I can find is the software requirements for ProcessWire which lists MySQL 5.0.15 or newer. There's also at least one issue regarding the DateTime field, but not much beyond that.

Is anyone running ProcessWire (current dev or master version) with MySQL 8? Is anything working as expected? Any errors / potential bugs I should be aware of?

Also, does anyone know if ProcessWire supports newer MariaDB versions? I'm currently using MariaDB 10.1 (comes with Plesk), which mostly replaces 5.6, but seems that starting with MariaDB 10.3 those versions are not really compatible with any MySQL version. Is there even a version of MariaDB that's compatible with MySQL 8? The official compatibility table doesn't suggest there is ...

Share this post


Link to post
Share on other sites
12 hours ago, MoritzLost said:

Is anyone running ProcessWire (current dev or master version) with MySQL 8? Is anything working as expected? Any errors / potential bugs I should be aware of?

@adrian has an experience or two with this. Hopefully he reads this 🙂 

  • Like 2

Share this post


Link to post
Share on other sites

I preffer Mysql . One my site uses version 8.0.19 , another - 8.0.17. 
No problems.
 

  • Thanks 1

Share this post


Link to post
Share on other sites
11 hours ago, MoritzLost said:

Is anyone running ProcessWire (current dev or master version) with MySQL 8? Is anything working as expected? Any errors / potential bugs I should be aware of?

There have actually been quite a lot of issues. Ryan has fixed several of them, but there are still some outstanding issues and I expect more will continue to surface and AFAIK Ryan still hasn't upgraded his dev environment so he's not seeing them and not being able to replicate so there has been some guesswork and back and forward with me on them.

That said, I do have several sites running on MySQL 8 / MariaDB 10 so I am reporting new things as they come up. Not ideal, but hopefully they'll all be sorted sooner than later. However if I were you, I wouldn't upgrade yet.

 

  • Like 4

Share this post


Link to post
Share on other sites

Thanks @adrian! Unfortunately Hosteurope is forcing the upgrade, so we'll have to either migrate those sites to a different host or wait and hope everything works 😕

Which version of MariaDB are you on? We're using mostly MariaDB 10.1 for development, which should be a sort-of replacement for MySQL 5.5, and this version works fine with the current master / dev branch. Can't speak for newer MariaDB versions though.

Share this post


Link to post
Share on other sites

@MoritzLost

I am running: MySQL Server: 5.5.5-10.3.22-MariaDB-0+deb10u1

This is the default version with Debian these days, although the reported numbers for these are always a bit confusing - I have no idea why there is 5.5.5 before the 10.3.22.

Honestly I think hosts should be upgrading - these versions of MySQL have been the stable release for a couple of years now - I think Ryan is lagging behind on this so having hosts upgrade might prompt him to also upgrade his environment.

  • Like 1

Share this post


Link to post
Share on other sites

@adrian

Thanks, good to know that this version works. I think the reported version number has to do with the replication compatibility as outlined on their compatibility page, to indiciate which MySQL version the MariaDB version is compatible with. Though the whole drop-in replacement thing doesn't seem to be what they're aiming for anymore.

Well Hosteurope is definitely updating our managed server, can't speak to their other products, but I guess some hosts are following suit now. I've tested one of the sites running on Hosteurope with a docker image of MySQL 8 and a database dump – so far everything seems to be working! I'll report back if I find any bugs or errors 🙂

Share this post


Link to post
Share on other sites
1 minute ago, MoritzLost said:

Thanks, good to know that this version works.

This is the version I am experiencing the issues with. I actually assumed (wrongly now that I look at that Maria page) that I was running a version that was compatible with MySQL8. Maybe the issues I've been having are not specific to "8" but rather default settings that come with MariaDB that don't come with MySQL? Not sure at this point. The main issues that have shown up are cases where PW was not setting the value for the table's sort field or other similar instances where a value is required. Maybe it's even just the way Maria throws errors - maybe it throws errors where MySQL doesn't bother. Really not sure without spending more time which I don't have at the moment - sorry!

  • Like 1

Share this post


Link to post
Share on other sites

I've been running MariaDB 10.2 on CentOS with Plesk for a while, and I don't think I recall any issues.

  • Like 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...