Upgrading MySQL version of Linux Plesk server 12.5

[AlejandroL]

Hello, I recently purchased a Linux VPS that came with version Plesk 12 and MySQL 5.1.73.
Is there a way to upgrade it to more recent version of MySQL or maybe change it to MariaDB?
I have read that it has better performance than MySQL.

 

[bulent]

So what I did is:
1. Install clean Centos 7.1 (Core)
2. yum update
3. add Mariadb 10 repo to the repo list

vim /etc/yum.repos.d/MariaDB10.repo

# MariaDB 10.0 CentOS repository list - created 2015-10-12 20:25 UTC
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

sudo rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

4. Install Plesk
wget autoinstall.plesk.com/plesk-installer
chmod +x plesk-installer
./plesk-installer

do exactly like explained here and you'll have new install with mariadb 10

 

[trialotto]

Hello, I recently purchased a Linux VPS that came with version Plesk 12 and MySQL 5.1.73.
Is there a way to upgrade it to more recent version of MySQL or maybe change it to MariaDB?
I have read that it has better performance than MySQL.

It is not necessary to use MariaDB, one can use a more recent version of MySQL (or even PostgreSQL, MariaDB, Percona etc. etc.).

In essence, every organisation maintaining a MySQL based server has it´s own version: MySQL, PostgreSQL, MariaDB, Percona etc. (view them as "mysql flavours", if you will).

The differences are negligible and, in the case of a normal Plesk workload, the performance is more or less the same amongst the various MySQL (based) servers.

One exception is PostgreSQL server, that has a low resource usage (memory and disk space), but I would not advice you to implement that.

And sure, every now and then, one of the servers is just a little bit ahead of the other servers, implying that pursuing optimal performance would require a constant change of the stack.

In short, just do not worry about the "brand and name of the server", stick to the normal MySQL server as provided by Plesk.

What you DO have to do is to UPDATE the Plesk installation!

With an update of the Plesk installation (being either Plesk version 12.0.18 or even an upgrade to Plesk version 12.5.30), the MySQL server will be updated to a fairly recent (stable) one.

That is all......

Hope the above helps!

Regards....

 

[AlejandroL]

I have already finished the MySQL upgrade to MySQL 5.5
Is it possible to move to MariaDB after the upgrade to MySQL 5.5?

 

[trialotto]

@AlejandroL,

Yes, it is possible, but it would require some manual migration of database data to MariaDB.

I would strongly advice to continue using the MySQL server, at least in your case.

Regards....