Upgrade Mysql server

  • oussk

    (@oussk)


    6 years, 7 months ago

    Hello i get a message in the WP health say, it’s better if i upgrade my Mysql server to V5.6 or higher,
    right now i run the latest update of WP with MyAQL 5.5 and i have the ability to upgrade the MySQL server in one click from my service provider so i can get V5.6 and 5.7 and even Maria DB 10.0 and 10.1,
    so my question what is the best thing i can upgrade MySQL or Maria and which version?
    did i will face any issue with plugin is i do upgrade? i have EDD plugin plus other add-on in total around 35 plugin? so did plugins support some version of MySQL and other version no or it only related to WP?

    thanks for your help

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    6 years, 7 months ago

    My server is running Maria 10.3.18 and is quite happy. Your plugins and WP won’t care so install the latest version available of either MySQL or MariaDB. Of course, backup first!

    Thread Starter oussk

    (@oussk)

    6 years, 7 months ago

    Thanks steve for your reply,, did you prefer mariadb over MySQL?
    and is 10.1 enough? since it’s the highest version available for me to upgrade

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    6 years, 7 months ago

    At the time, there was a controversy about Oracle acquiring MySQL so I went with Maria to support the FOSS fork. Either will work for you and 10.1 is enough.

    Dion

    (@diondesigns)

    6 years, 7 months ago

    THe information in Site Health is a recommendation based on what the WP developers think is best for WordPress. It does not take into account anything else running on your site, nor does it take into account the resources available in your hosting plan. (Recommendations also take a somewhat-fear-mongering approach…for example, MySQL 5.5 is equally as secure as MySQL 5.6 or MariaDB 10.1, despite what is said in the recommendation.)

    Since you can update MySQL, I suspect you have a VPS. How much memory does your VPS have? If it has 2GB or less, you are actually better off sticking with MySQL 5.5 since it uses half the memory of MySQL 5.6 or MariaDB 10.1. MariaDB 5.5 would be much better than MySQL 5.5 since it’s faster with InnoDB tables, and it includes support for some collations not supported by MySQL 5.5.

    In terms of whether to choose MySQL 5.6 or MariaDB 10.1 (10.0 does not include all the features of MySQL 5.6 so avoid it), that is a personal decision. MariaDB 10.1 is slightly faster then MySQL 5.6 with InooDB tables, but it uses more memory. I’d recommend MySQL 5.6 for servers with 2-3GB memory, and MariaDB 10.1 for servers with more than 3GB memory.

    Thread Starter oussk

    (@oussk)

    6 years, 7 months ago

    Thanks Steve,,

    Thanks Dion,, really your reply is very helpful i totally appreciated, in fact i have a server from cloudways and yes it’s has low ram configuration, really because right now i’m under construction purpose so no need to have high ram, even i’m able to upgrade the ram easily as you know, so i think i will stick with current version until i finish my website and ready to upgrade the server ram so i can also upgrade the MySQL server to 5.6 or go with MariaDB 10.1

    thanks…

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Upgrade Mysql server’ is closed to new replies.