Question How to change from MySQL to MariaDB (Plesk 18.0.65)

[TELLO0815]

Server operating system version

Ubuntu 18.04.6 LTS

Plesk version and microupdate number

Plesk 18.0.65 Update #2

Hi all,
I was reading a lot, but still not getting it.
Under DB Server I have MySQL 8, and no choice to build new DB as MariaDB...???
In "update" I get only MySQL to install as component. No MariaDB to choice.

How can I change to MariaDB, because I want to upgrade Ubuntu18 to 20 with plesk/ubuntu18to20.

Tanks

 

[KZM]

same issue here- not seeing "MariaDB" as an option to add.

 

[TELLO0815]

looks like its only Plesk-Windows possible, to add under components.

add mysql/mariaDB

 

[AYamshanov]

Hi! Have you found/tried the steps suggested in the next links?

• Is-it-possible-to-replace-MySQL-with-MariaDB-and-vice-versa
• MySQL vs MariaDB – Can One Replace The Other?

 

[Maarten]

Hi @AYamshanov: I already noticed there's no recent article on the support page explaining how to replace MySQL with MariaDB. Since this is an essential step for anyone upgrading from Ubuntu 18 to Ubuntu 20, could you ask the support team to create an article on this? It could benefit users who want to upgrade their Ubuntu server.

 

[TELLO0815]

Hi @Maarten yes, this will be a great help.
@AYamshanov yes I was going this steps. Finally on MariaDB installation guide under Ubuntu18 I failed with the installation, because there is only Ubuntu 12 and MariaDB 5.5 ... but I need MariaDB 10, regarding MySQL 8 I guess.
If there will be some better explonation about Ubuntu 18 ... guess there are lot of people locking for help...out there

 

[Daveo]

https://support.plesk.com/hc/en-us/articles/12388091703703-How-to-upgrade-MySQL-5-5-to-5-6-5-7-or-MariaDB-5-5-to-10-x-on-Linux

Click Manual procedure tab then click on Plesk on Ubuntu 18.04

 

[TELLO0815]

@Daveo Im more and more confused. Normally in my Ubuntu 18.0.4 must be MariaDB installed. But following your link point 2 stopping the service, I get:

Failed to stop mariadb.service: Unit mariadb.service not loaded

Point 3 installing 10.2
curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=10.2
I get:

# [error] Ubuntu 18.04 LTS has reached End of Life and is no longer supported.

MB because of PHP 8.1.8 I have installed?
I need PHP 8.2 or 8.3. But for this I need Ubuntu 20, but for this I need MariaDB... I feel little bit in hamsterweel.

 

[Daveo]

@TELLO0815 You will need to upgrade the OS to a version that is not listed as End of Life, that's what is stopping you from installing/upgrading MariaDB.

But there is a version of MariaDB that is compatible with Ubuntu 18.04 LTS...

curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=10.1

MariaDB 10.1 is last supported version on Ubuntu 18.04 LTS.

 

[Daveo]

Also, point 2 error is normal as MariaDB isn't yet installed.