Updating mySQL from5.5 to 5.7

Hoops78 · Mar 2nd 2019

Hi

I need to update mySQL on our server from 5.5 to 5.7. I've asked a few questions on the cPanel forum, trying to get an idea of what might change and they've mentioned that strict mode will be enabled by default. We're checking sites with custom script if this will be an issue. Would any Perch sites need any additional changes or will the Strict mode be OK?

Thanks

Wayne

drewm · Mar 3rd 2019

As long as your sites are up to date it should be fine.

Hoops78 · Mar 3rd 2019

Thanks

I might have to suck it and see and they’re are several sites that aren’t on the latest version as I have too many sites to update them all straight away. I normally only update them if there’s an issue or I’m working on the site.

Quick question. If there is an issue, would it show at the first stage when the site connects to the database? Or could it connect ok and have an issue on another function?

drewm · Mar 3rd 2019

Any issues will be with things that use GROUP BY functions. I believe all these are patched now - I’ve not had any reported in quite a while.

So no, it’s not obvious breakage, it’s subtle.

Hoops78 · Mar 4th 2019

OK, thanks. I might disable Strict mode to be safe.

btw. Am I doing something wrong in this forum as I don't get email notifications of thread updates, even though I'm select watching of thread.

drewm · Mar 4th 2019

You'd need to check your forum notification settings for that.

Hoops78 · Mar 4th 2019

Thanks. I'd missed the notifications settings and now turned on the email notifications

drewm Mar 3rd 2019