Question ubuntu 18 updated to 20, switch from Mysql 8 to MariaDB?

[TauTaude]

Server operating system version

ubuntu 20

Plesk version and microupdate number

18.0.48

Hi,

I've read a few times, that ubuntu 20 comes with MariaDB as default. I updated my server via plesk to ubuntu 20 from 18, but now have MySQL 8 and no mariaDB. Is it possble to migrate to MariaDB?

 

[Peter Debik]

https://support.plesk.com/hc/en-us/articles/360012376313-Is-it-possible-to-replace-MySQL-with-MariaDB-and-vice-versa-

 

[TauTaude]

thanks a lot... I already followed a plesk guide and failed at some final steps, so I thought there's something specific for current versions to watch out for (the guide is quite old). Also every guide mentions I should add a mariadb repository to my sources list, but my provider also provides packages:
mariadb-server-10.3 - MariaDB database server binaries
mariadb-server-core-10.3 - MariaDB database core server files
so I'm not sure which route to go

 

[TauTaude]

tried again, it just doesn't like me

root@xxxxxxxx:~# systemctl status mariadb.service
● mariadb.service - MariaDB 10.3.37 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
     Active: failed (Result: exit-code) since Thu 2022-12-29 15:40:16 CET; 5s ago
       Docs: man:mysqld(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 2603 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
    Process: 2604 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 2605 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl>
    Process: 2653 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
   Main PID: 2653 (code=exited, status=1/FAILURE)
     Status: "MariaDB server is down"

Dez 29 15:40:15 xxxxxxxx.stratoserver.net systemd[1]: Starting MariaDB 10.3.37 database server...
Dez 29 15:40:15 xxxxxxxx.stratoserver.net mysqld[2653]: 2022-12-29 15:40:15 0 [Note] /usr/sbin/mysqld (mysqld 10.3.37-MariaDB-0ubuntu0.20.04.1) starting as process >
Dez 29 15:40:16 xxxxxxxx.stratoserver.net systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Dez 29 15:40:16 xxxxxxxx.stratoserver.net systemd[1]: mariadb.service: Failed with result 'exit-code'.
Dez 29 15:40:16 xxxxxxxx.stratoserver.net systemd[1]: Failed to start MariaDB 10.3.37 database server.
Dez 29 15:40:21 xxxxxxxx.stratoserver.net systemd[1]: Starting MariaDB 10.3.37 database server...
Dez 29 15:40:22 xxxxxxxx.stratoserver.net mysqld[2721]: 2022-12-29 15:40:22 0 [Note] /usr/sbin/mysqld (mysqld 10.3.37-MariaDB-0ubuntu0.20.04.1) starting as process >
lines 1-19/19 (END)

 

[Monty]

What's in /var/log/mysql/error.log?