Support » Fixing WordPress » RE: Should I upgrade MySQL to v5.6?

  • I am running approximately 30 sites, currently using MySQL v5.1 (and PHP 5.4).

    I noticed that after installing something, it stated (on screen) that I should upgrade my MySQL version. And the newest version is approximately 5.6.

    My host can upgrade my MySQL without any issue, but I’m curious if this would break things on my sites, either WordPress itself or themes or plugins.

    I was hoping to get some input from people who have upgraded their MySQL version (on a Linux server) to 5.6. Any issues after upgrading? Anything at all?

    Or, should I not upgrade MySQL from 5.1 to anything at this time.

    Please let me know your thoughts.

    Thanks,
    Gary

Viewing 4 replies - 1 through 4 (of 4 total)
  • I don’t have same experience, but I would upgrade without doubt.

    Just like PHP 5.2 was forced upgraded to 5.3 or 5.4 at many hosting server, I personally believe MySQL upgrade will be the same in the future.

    You’ve already received the message to upgrade MySQL database, it is a good time to do so. I believe next version of the same plugin/theme update will elevate warning message level.

    Unless all your 30 sites are on the same server, starting from just one site and get some first-hand experience is always helpful.

    Thread Starter Gary Gordon

    (@garymgordon)

    @2bearstudio,

    Thanks.

    All 30 sites are on the same server, and many of the sites run different plugins. (Some the same, but some different.)

    So I’m just nervous .. because I can’t just test it on one site. I’d have to make the change for all of my sites.

    But you think there will be NO issues in upgrading?

    PS: I did have issues with some things when I upgraded PHP from an earlier version to the newer version. That’s just part of why I’m a bit nervous.

    Gary

    If 30 sites are on the same server, and all live sites, I would have to be cautious.

    Although your chance of having troubles is very low, I would run the test on other testing environment with the target version of MySQL installed.

    My point is, the upgrade is inevitable. Do it sooner than later.

    Thread Starter Gary Gordon

    (@garymgordon)

    🙂 Thanks.
    I do very much appreciate your comments and suggestions.
    I’m going to coordinate the upgrade with my network server administrators so they can roll back (immediately) if there’s any tremendous issue that I can’t resolve quickly.

    🙂
    Gary

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘RE: Should I upgrade MySQL to v5.6?’ is closed to new replies.