MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB), and OQGRAPH.
Step #1: Add the MariaDB Repository
Here are the commands to run to install MariaDB on your Ubuntu system:
# sudo apt-get install software-properties-common
We’ll import the MariaDB public key used by the package management system:
# sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
Then we’ll add the MariaDB repository:
# sudo add-apt-repository 'deb http://ftp.osuosl.org/pub/mariadb/repo/10.0/ubuntu trusty main'
# sudo apt-get update
Step #2: Install MariaDB
Next, run the following command to install mariadb server.
# sudo apt-get install mariadb-server
While installation on screen you can see, it is asking for setting MariaDB root password.
Step #3: Configure and Secure MariaDB for Use
When the installation is complete, run the following command to secure your installation:
Step #4: Verify MariaDB Installation
You can check the version of the MariaDB installation with the following command:
# mysql -V
mysql Ver 15.1 Distrib 10.0.21-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
# mysql -u root -p
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 53
Server version: 10.0.21-MariaDB-1~trusty-log mariadb.org binary distribution
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.