MariaDB Upgrade to 10.3

To upgrade MariaDB from version 10.2 to 10.3, follow these steps:

Note: Before upgrading, always make sure to take backup of your database.

1. Update your server: Before upgrading MariaDB, it’s important to make sure your server is up to date with the latest patches. You can do this using the following command:

 sudo apt-get update

2. Stop MariaDB service: Stop MariaDB service before upgrading by using the following command:

sudo systemctl stop mariadb

3. Remove current version MariaDB: Remove the current version MariaDB before upgrading to the new version using the following command:

sudo add-apt-repository --remove 'deb [arch=amd64,arm64,ppc64el] http://sfo1.mirrors.digitalocean.com/mariadb/repo/10.2/ubuntu bionic main'
sudo apt-get remove mariadb-server

 4. Install the new version: Install the new version (10.3) of MariaDB using the following command:

sudo apt-get install software-properties-common
sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://sfo1.mirrors.digitalocean.com/mariadb/repo/10.3/ubuntu bionic main'
sudo apt-get install mariadb-server
sudo apt update

5. Upgrade the database: Once the installation is complete, run the following command to upgrade your database:

 sudo mysql_upgrade -u root -p

6. Verify the new version: Verify the new version of MariaDB using the following command:

 mysql --version

  You should see the version number of MariaDB 10.3.

7. Restart MariaDB service: Restart MariaDB service using the following command:

sudo systemctl restart mariadb

Congratulations! Your MariaDB database has been successfully upgraded to version 10.3.