Jump to content
keat

upgrading database

Recommended Posts

I almost took the plunge and upgraded the database from MySql 5.6 to maria 10.2 and then read all the warnings in Cpanel.

Has anyone else done this before I jump in ?

Share this post


Link to post
Share on other sites

Al has mentioned his dev box (and maybe the demo store) runs MariaDB.

I don't know if he started with that or swapped out MySQL for MariaDB at some upgraded version.

Share this post


Link to post
Share on other sites

I've done it and everything was fine. You may need to turn off strict mode afterwards. Otherwise there shouldn't be anything to worry about.

The demo store is currently running on MariaDB 10.2.

Share this post


Link to post
Share on other sites

I'm a little concerned that accrding to Cpanel, there is no rolling back afterwards.

Share this post


Link to post
Share on other sites

The rush to MariaDB was part valid and part "the latest thing" and was just what MySQL needed.  We have stuck with MySQL on all production servers (even the very busiest ones) and I would recommend doing that - both work well and if any form of popular support for MariaDB still continues then they could keep leapfrogging each other so why introduce any complication.  Except on the very busiest high transactional websites, nobody would ever notice any difference anyway

Share this post


Link to post
Share on other sites

Whilst MYSQL5.6 works and I see no point in fixing something which isn't broken, it seems 5.6 is EOL.

This is my only real reason to update.

Share this post


Link to post
Share on other sites

Doesn't time fly.

It's been almost a year since I started this thread and still havn't updated the database.

Does anyone envisage any issues with updating MySQL to 5.7

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...