Resolved How to update MariaDB

[WhiteTiger]

There is a guide to update MariaDB, from the native release in Plesk Onyx to 10.x?
I tried some guide in Internet, but are not for Plesk.

Thanks in advance.

 

[UFHH01]

Hi WhiteTiger,

did you know, that the Forum has as well a powerfull SEARCH engine? I found quite a lot of threads, regarding the update of your MariaDB - server:

=> Search Results for Query: "update" "MariaDB" | Plesk Forum​

If you experience any issues/errors/problems, pls. don't hesitate to open a new thread with your issues/errors/problems and don't forget to mention your actual operating system on your server, the Plesk version ( incl. #MU ) in use and when you provide depending entries from your logs, you can be sure, that people willing to help are able to assist you with investigations and solutions.

 

[WhiteTiger]

Sorry, you are right.
I did the research from Google and I read several pages on this Forum, but not recent.
I should have started from here.

 

[WhiteTiger]

For any reference about upgrade to 10.2:

1) I have created the file: /etc/yum.repos.d/MariaDB.repo with:

# MariaDB 10.2 CentOS repository list - created 2017-07-02 09:18 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.2/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

2) # service mariadb stop
3) # yum install MariaDB-server MariaDB-client
4) # service mariadb start
5) mysql -V

 

[UFHH01]

Hi WhiteTiger,

about upgrade to 10.2

Sorry, but upgrades to NON - supported DB - servers are never recommended, as they may cause unexpected issues/errors/problems.

Pls. consider to check the existent supported DB - servers for Plesk Onyx at => Software Requirements for Plesk

Database servers and tools:

• MySQL 5.1 - 5.7
• MySQL community edition 5.5, 5.6, 5.7
• PostgreSQL 8.4-9.5
• MariaDB 5.5, 10.0, 10.1

 

[WhiteTiger]

I did not see this, but version 10.2 was considered stable.
But why this update can not be managed from within the plesk?

Now what should I do?
Just change the repo and do yum install again?
Otherwise, I'll restore the image I saved.

Anyway, thank you very much for your support.

 

[UFHH01]

Hi WhiteTiger,

but version 10.2 was considered stable

Even that third - party components could be declared as "stable", this doesn't mean that they are compatible with your current Plesk version. Plesk must be sure, that the new component works as expected, which included quite a lot of tests and compatibility checks, before Plesk changes the official software requirements.

But why this update can not be managed from within the plesk?

Even that you have the possibility to set at => HOME > Tools & Settings > Update and Upgrade Settings the option => "Automatically install system package updates", this will not automatically upgrade a "declared as stable" third-party component. Pls. be patient and keep in mind, that it will ALWAYS take some time for the Plesk developers to check the compatibility for third-party components!

Just change the repo and do yum install again?
Otherwise, I'll restore the image I saved.

Due to the fact that you have both possibilities, just consider to test the first one and if you experience issues/errors/problems, you should consider to choose the second option to restore your backup - image afterwards, to solve your issues/errors/problems.