Upgrade MariaDB 10.3 to 10.4 on Ubuntu 18

upgrade-maria-db-on-ubuntu

# https://mariadb.com/kb/en/library/upgrading-from-mariadb-103-to-mariadb-104/
# Add MariaDB APT repo
sudo apt-get update
sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://sfo1.mirrors.digitalocean.com/mariadb/repo/10.4/ubuntu bionic main'
sudo apt-get update

# Stop MariaDB
sudo systemctl stop mysql

# Uninstall old version of MariaDB
sudo apt-get remove mariadb-server

# Install new version of MariaDB
sudo apt-get update
sudo apt-get install mariadb-server galera-4 mariadb-client libmariadb3 mariadb-backup mariadb-common

# check the my.cnf for any configuration changes to options & remove any options no longer supported (see website above)
sudo vi /etc/mysql/my.cnf

# Start MariaDB
sudo systemctl start mysql

# Run upgrade to upgrade the database, tables, etc
sudo mysql_upgrade --verbose --verbose other-options --force