Question change mysql version (to 5.7)

[itoop]

Hallo,

I'm wondering how to change mysql version to version 5.7 in plesk 17.8.11. At "Tools & Settings > Applications & Databases > Database Servers" MySQL Version 10.1.29 is shown - I think this version cannot be correct; maybe it's the MariaDB version. In a software running on this server version 5.5.5 is shown. What can I do to upgrade to version 5.7? I'm suprised that I can't find anything in the docs of plesk and that it seems that I can't choose the mysql version for each domain in the panel.

Thank you.

 

[IgorG]

What about searching KB article?

How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.0/10.1/10.2 on Linux

 

[itoop]

"For Ubuntu 12.04, 14.04 and Debian 7"
I'm using ubuntu 18.04

 

[AYamshanov]

Hi itoop,

it seems that I can't choose the mysql version for each domain in the panel.

In such case, I suggest using Docker: Let's talk about the Plesk Docker Extension | Plesk. With Docker, you can use different MySQL/MariaDB versions as a remote database.

 

[learning_curve]

....In such case, I suggest using Docker: Let's talk about the Plesk Docker Extension | Plesk. With Docker, you can use different MySQL/MariaDB versions as a remote database.

Great suggestion, especially as we will shortly change from Plesk 17.5.3 / CentOS 7 to Plesk 17.8.11 / Ubuntu 18.04 ourselves (for reasons other than this) but we may also use this too.

One question though is THIS which indicates that this is not supported yet on Plesk 17.8.11 / Ubuntu 18.04 and @itoop has indicated that he is using Plesk 17.8.11 / Ubuntu 18.04. Is that still the case?

 

[itoop]

Thank you for your suggestion, AYamshanov!
@learning_curve : That is also my latest info about that.

I would expect that „of course“ at least the mysql version of the underlying os is supported by default by a proprietary software, which one have to pay for. In other words: Latest version of plesk should support latest version of mysql by default.

 

[virtubox]

Thank you for your suggestion, AYamshanov!
@learning_curve : That is also my latest info about that.

I would expect that „of course“ at least the mysql version of the underlying os is supported by default by a proprietary software, which one have to pay for. In other words: Latest version of plesk should support latest version of mysql by default.

Hello @itoop ,

Plesk "support" the latest version of MySQL, as well as the latest version of MariaDB (10.2 & 10.3) for the testing release, but for the most part of users, MariaDB 10.1 is a good compromise, fully compatible with MySQL < 5.6, and available from ubuntu official repostories (without talking about the fact that MariaDB is open-source and in the most part of case, it provide better performance).
And you can install the MySQL/MariaDB version of your choice, but it should be done before installing Plesk, because switching from MariaDB 10.1 to MySQL 5.7 isn't really easy, due to incompatible table schema.

 

[itoop]

Why does Plesk not use at least the os package for database by default, which is mysql 5.7 at ubuntu 18.04? One big reason for upgrading to ubuntu 18.04 for me was actual software like PHP and mysql. E.g. here you can see, that plesk should support MySQL 5.7! I don't want to use MariaDB. And I think, that at a tool which is commercialised with the slogan "Simplified Web Hosting" one should not have to install databases "by hand" before installing the tool itself to get the latest version of mysql! I want to use plesk primarily for that I don't have to care about things like that. That's finally the reason for using plesk I think.
As a web developer with latest os and latest plesk version I can't update some web projects with mysql 5.7 as requirement now? Incomprehensible for me.

 

[IgorG]

Actually, Plesk doesn't ship SQL server, it only downloads it from original OS vendor repo and it is quite likely it may be outdated there (especially for older OS). If your OS comes with MariaDB 10.x or MySQL5.x, then Plesk would run these versions for clients.

 

[learning_curve]

Plesk provide THIS reference page, which clearly shows MySQL 5.7 is supported, but anything greater than MariaDB 10.1 is not supported. Then again, other forum posters provide references to their own Plesk / Server setup running well with MariaDB 10.2 after a clean install, which relates to your posts @IgorG & @virtubox in some ways

One major #Fail seems to be trying to upgrade MariaDB 10.1 > MariaDB 10.2 within Plesk itself, as nobody seems to have managed that successfully so far.... Plesk also provide THIS guide, but it only relates to the older Debian / Ubuntu OS editions not the ones needed in this thread.

Nobody from Plesk has answered the earlier question we asked: "One question though is THIS which indicates that this is not supported yet on Plesk 17.8.11 / Ubuntu 18.04 ..... Is that still the case? We're therefore assuming that it IS still the case at this point in time...

 

[itoop]

Regarding question "One question though is THIS which indicates that this is not supported yet on Plesk 17.8.11 / Ubuntu 18.04 ..... ": Here also 18.04 is listed. So it would be fine, if anybody of plesk would bring light into the dark!

Again: MariaDB is NOT an option for me yet.

If I run "$ mysql -V" in shell I get "mysql Ver 15.1 Distrib 10.1.29-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2". It's a fresh install, only a few weeks old. So again I think, anything is wrong in Plesk regarding the version of mysql.

So again my question: What can I do to run the mysql version of the underlying os ubuntu 18.04, so mysql version 5.7?

 

[learning_curve]

Regarding question "One question though is THIS which indicates that this is not supported yet on Plesk 17.8.11 / Ubuntu 18.04 ..... ": Here also 18.04 is listed. So it would be fine, if anybody of plesk would bring light into the dark!

Exactly! We have seen quite a few Ubuntu 18.04 users running Docker and also, people posting how to install it etc THIS is an example. It appears that the wording maybe a little awry on the Plesk upgrade post and... it should only have been referring to just the Plesk Docker Extension

Again: MariaDB is NOT an option for me yet. If I run "$ mysql -V" in shell I get "mysql Ver 15.1 Distrib 10.1.29-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2". It's a fresh install, only a few weeks old. So again I think, anything is wrong in Plesk regarding the version of mysql. So again my question: What can I do to run the mysql version of the underlying os ubuntu 18.04, so mysql version 5.7?

Don't know the answer to that one sorry. That's probably a question best answered by @IgorG or @AYamshanov ....

 

[IgorG]

What can I do to run the mysql version of the underlying os ubuntu 18.04, so mysql version 5.7?

I've wasted a lot of time for running Plesk on Ubuntu 18.04 with MySQL 5.7. Tried many different methods but all of them were without success.
But all works fine with MariaDB.
You can experiment on your own and share in your successful way

 

[itoop]

@IgorG : It think you're right - I wasn't aware of that ubuntu 18.04 takes MariaDB as default database server. Now I found this note at support.plesk.com, too:
"Note: Plesk Installer deploys MariaDB by default."

Hmm...now I'm really thinking of using mariadb as default...would be fine, if an upgrade to 10.2 would come soon...

Thank you all guys for your kind support!!