MariaDB is a drop-in replacement in MySQL. It is simple to set up and provide many speed and execution changes, It is also simple to coordinate into most MySQL arrangements. Similarity inquiries can be found at: MariaDB vs MySQL – Compatibility. MariaDB offers more memory than MySQL, including Cassandra (NoSQL), XtraDB, and OQGRAPH.
Instructions for installing MariaDB:
These instruction list is useful for installing MariaDB 5.5 in Ubuntu without MySQL.
Step 1: The software-properties-common package should as of now be installed, however in the event of some unforeseen issue use this command in terminal:
sudo apt-get install software-properties-common
Import the MariaDB open key utilized by the package management system:
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
After this you can add the MariaDB repository:
sudo add-apt-repository 'deb http://mirror.jmu.edu/pub/mariadb/repo/5.5/ubuntu trusty main'
Now reload the package database:
sudo apt-get update
Step 2: MariaDB Installation
After all things set up you need to use this command for installing MariaDB:
sudo apt-get install mariadb-server
You may receive some prompt in which you need to Enter Y and continue. Then you will be ask for setting up a password. Use a strong password and continue. You need to stop MariaDB before continuing the process.
sudo service mysql stop
Step 3: Configure MariaDB
Create MariaDB directory structure with following commands:
sudo mysql_install_db
Start program:
sudo service mysql start
Now secure MariaDB by removing testing databases.
sudo mysql_secure_installation
After that Enter your password and continue with entering “Y” in all prompts.
Step 4: Verify Installation
Check MariaDB installation with following command.
Mysql -v
If you want to close MariaDB then use:
Exit
Stop MariaDB with:
sudo service mysql stop
Restart MariaDB with:
sudo service mysql restart
Check the status:
sudo service mysql status