Can we update MySQL 5.5 to MySQL 5.7?


#1

Currently Running: Ununtu nginx 1.13.9, PHP 7.2.2-3+ubuntu16.04.1+deb.sury.org+1 and MySQL 5.5.5-10.1.31-MariaDB-1~xenial.

My question in can we update this MySQL version from 5.5 to 5.7.

According to the update:

v5.7 is 3x faster than 5.6.

I think that would really benefit WordPress too.

Will it be possible to do so ?

Or is it that EE was compiled with 5.5 so we are stuck with that version?

There are also newer versions of MariaDB; can they be updated?

@virtubox @portofacil


#2

Hello @ashishdungdung,

If you have installed MySQL with EasyEngine, you are not running MySQL 5.5, EE install MariaDB 10.1 (based on MySQL 5.6).

And it’s not easy to switch between MariaDB 10.1 and MySQL 5.7 without issues.
You can still try to upgrade MariaDB to the latest release 10.2.


#3

Yes I upgraded on production but not yet noticed any improvement. Even I don’t know how to measure mysql performance and optimizing running queries with wp.

If you want to upgrade add repo to source list. https://dev.mysql.com/downloads/repo/apt/

Apt update a

sudo apt update 3 packages can be upgraded. Run ‘apt list --upgradable’ to see them.

sudo apt upgrade apt install mysql-server

You will get some errors to fix

cd ERROR 2002 (HY000): Can’t connect to local MySQL server through socket '/var/run

Error: Plugin ‘unix_socket’ is not loaded