Question Updating mariadb 10.3 to 10.11 on rockylinux?

[charmainebell]

Server operating system version

Rocky Linux 8.8 (Green Obsidian)

Plesk version and microupdate number

18.0.54 Update #3

Hey all, i wish to upgrade my current mariadb version 10.3.35 to 10.11 on rocky linux 8.8. what is best possible way to do it?

 

[Strangelove]

Hi,
I'd strongly recommend performing something like this in a maintenance timeframe if the server is in a production environment.

Actions performed as root.
1. Create dump backup folder:
# mkdir /root/dbBackups
2. Dump databases, just in case(don't proceed if this action failed):
# plesk db -Ne 'show databases' | egrep -vE '(information_schema|performance_schema|mysql)' | xargs -l bash -c 'mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` $0 > /root/dbBackups/$0.sql'
3. Create /etc/yum.repos.d/mariadb.repo with the following contents:

[mariadb]
name = MariaDB
baseurl = http://mirror.mariadb.org/yum/11.3.1/rhel8-amd64/
module_hotfixes=1
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

4. Stop mariadb server:
# systemctl stop mariadb
5. Remove it:
# rpm -e --nodeps `rpm -qf /usr/libexec/mysqld`
6. Create repository cache and install new MariaDB from it:
# yum makecache
# yum install mariadb-server
(will be prompted to hit "Y" a number of times)

7. Adjust config's bind_address value:
# sed -i 's/::ffff://' /etc/my.cnf

8. Start MariaDB 10.11:
# systemctl start mariadb

9. Upgrade tables:
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin

Done.

 

[Lightyear]

Hello!

Thank you for the instructions, I keep running into the following errors:





Do you have any idea?

Many thanks in advance and greetings Olaf

 

[Strangelove]

Do you have any idea?

Many thanks in advance and greetings Olaf

Could you show the contents of the mariadb repo file from /etc/yum.repos.d/ ?

 

[Lightyear]

Hello!

Good point... that corresponds to one of my attempts, even with lower versions I run into the same problem:

[mariadb-main]
name = MariaDB Server
baseurl = https://dlm.mariadb.com/repo/mariadb-server/10.11.5/yum/rhel/8/x86_64
gpgkey = file:///etc/pki/rpm-gpg/MariaDB-Server-GPG-KEY
gpgcheck = 1
enabled = 1
module_hotfixes = 1

[mariadb-maxscale]
# To use the latest stable release of MaxScale, use "latest" as the version
# To use the latest beta (or stable if no current beta) release of MaxScale, use "beta" as the version
name = MariaDB MaxScale
baseurl = https://dlm.mariadb.com/repo/maxscale/latest/yum/rhel/8/x86_64
gpgkey = file:///etc/pki/rpm-gpg/MariaDB-MaxScale-GPG-KEY
gpgcheck = 1
enabled = 1

[mariadb-tools]
name = MariaDB Tools
baseurl = Tools/rhel/8/x86_64/ - MariaDB
gpgkey = file:///etc/pki/rpm-gpg/MariaDB-Enterprise-GPG-KEY
gpgcheck = 1
enabled = 1

Best regards

 

[Strangelove]

All I can see here is 404: https://dlm.mariadb.com/repo/mariadb-server/10.11.5/yum/rhel/8/x86_64

Latest MariaDB release is 11.3: MariaDB Server - All releases - MariaDB.org

What's the currently installed MariaDB version?
/usr/sbin/mariadbd -V
or
/usr/sbin/mysqld -V

 

[Lightyear]

I changed the repo to:

[mariadb]
name = MariaDB
baseurl = Index of /yum/11.3.1/rhel8-amd64/
module_hotfixes=1
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

My version of MariaDB is 10.3.39

After changing the repo file and restart the installation, i got the following error: