All Linux HowTo's

Upgrade MariaDB to 10.3 on CentOS 7

Everything you see here is found more formally at “https://mariadb.com/docs/operations/upgrades/upgrade-community-server-cs103-centos7/”. This page is basically just my notes in case I can’t find the other site when I need it in future.

We’re using CentOS 7 and upgrading from “MariaDB 5.5” to “MariaDB 10.3”. Backup your DB and config files first.

Stop and remove the current MariaDB software. The DB remains untouched:

systemctl stop mariadb
yum remove "MariaDB-*"

Download and verify the new version:

wget https://downloads.mariadb.com/MariaDB/mariadb_repo_setup
echo "fc84b8954141ed3c59ac7a1adfc8051c93171bae7ba34d7f9aeecd3b148f1527 mariadb_repo_setup"     | sha256sum -c -

Install the new version:

chmod +x mariadb_repo_setup
./mariadb_repo_setup    --mariadb-server-version="mariadb-10.3"
yum install MariaDB-server MariaDB-backup

Enable and start the new version:

systemctl enable mariadb
systemctl start mariadb

Upgrade the DB:

mysql_upgrade -u root -p

Log in and validate it:

mysql -h localhost -u root -p

At this point you should be done.

Similar Posts:

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.