Question Upgrade MySql 5.7 to MySql 8

[KZM]

Server operating system version

Ubuntu 18.04.6 LTS

Plesk version and microupdate number

Plesk Obsidian 18.0.65 Update #2

How can I upgrade MySQL 5.7.4.4 to MySQL 8x via Plesk UI?

If that's not possible, how to install MariaDB 10x in addition to MySQL 5.7.4.4 thus leaving this intact.

 

[scsa20]

MariaDB is meant as a drop in replacement and trying to install it side by side requires being in the terminal anyways. The instructions for installing MariaDB alongside MySQL can be found at Installing MariaDB Alongside MySQL and once installed you just add it as another database server with the proper info.

If you just want to upgrade MySQL 5.7.x to MySQL 8x, you can refer to https://support.plesk.com/hc/en-us/...9-Which-MySQL-versions-are-supported-by-Plesk and MySQL :: MySQL 8.0 Reference Manual :: 3 Upgrading MySQL

 

[KZM]

MariaDB is meant as a drop in replacement and trying to install it side by side requires being in the terminal anyways. The instructions for installing MariaDB alongside MySQL can be found at Installing MariaDB Alongside MySQL and once installed you just add it as another database server with the proper info.

If you just want to upgrade MySQL 5.7.x to MySQL 8x, you can refer to https://support.plesk.com/hc/en-us/...9-Which-MySQL-versions-are-supported-by-Plesk and MySQL :: MySQL 8.0 Reference Manual :: 3 Upgrading MySQL

Thanks. Since I run Ubuntu do you have similar guidance on how to install Mariadb alongside MySQL?

 

[scsa20]

Because you'll be download the compiled binaries the instructions is the same regardless of what Linux flavor you're using. You just need to download the latest version from Download MariaDB Server - MariaDB.org

 

[KZM]

Because you'll be download the compiled binaries the instructions is the same regardless of what Linux flavor you're using. You just need to download the latest version from Download MariaDB Server - MariaDB.org

Ok. I noticed the commands are a bit different in your post hence this follow-up question.
I am not an expert Linux admin but I can manage with a decent instruction.

 

[scsa20]

With Linux, the common tools is universal. The location for where things gets installed to might be different depending on flavor when installing from a repository and installing packages from a repository might be different as well (e.g., Ubuntu and other Debian based flavors uses apt, RHEL uses either yum or dnf, etc.) but for the most part to get the job done manually is the same.

 

[scsa20]

Also one thing I highly recommend that you do, which you should be do anyways, is making sure you have a good backup of your server and/or a snapshot before making any major changes. Since you're making changes to a SQL server, even if you're doing it side by side, you want to make sure you have a backup that you can roll back to in case anything happens.

 

[KZM]

With Linux, the common tools is universal. The location for where things gets installed to might be different depending on flavor when installing from a repository and installing packages from a repository might be different as well (e.g., Ubuntu and other Debian based flavors uses apt, RHEL uses either yum or dnf, etc.) but for the most part to get the job done manually is the same.

One more question: it can't be done in the Plesk UI?

Thanks. I appreciate your time.

 

[KZM]

Also one thing I highly recommend that you do, which you should be do anyways, is making sure you have a good backup of your server and/or a snapshot before making any major changes. Since you're making changes to a SQL server, even if you're doing it side by side, you want to make sure you have a backup that you can roll back to in case anything happens.

Definitely! The whole machine is backed up.

 

[scsa20]

it can't be done in the Plesk UI?

For this no. Plesk is testing out the ability to upgrade MariaDB but it's only for MariaDB since it's generally more stable and better performance compared to MySQL. You can, however, install Postgess through the UI but anything out of the norm like what you're doing can only be done through the terminal.

 

[KZM]

Doing this via the terminal, this new db server will be manageable in Plesk though?

 

[scsa20]

Once you add it via Tools & Settings > Database Servers, yes. You'll add it as a new database server using localhost but the new port that you assign to it. Then you can assign that database accordingly throughout plesk.