MariaDB is a community-driven MySQL relational database management system intended to remain free under the GNU / GPL. The development is driven by some original MySQL developers who have taken it out of Oracle Corporation after concerns regarding its acquisition. Contributors must share their copyright with the MariaDB Foundation.
MariaDB intends to maintain high compatibility with MySQL, providing a drop-in replacement capacity with binary library equivalence and accurate matching with MySQL APIs and commands. This includes the XtraDB storage engine to replace InnoDB, as well as a new storage engine, Aria, which is intended to be both a transactional and non-transactional engine, even included in future versions of MySQL.
The beginning of the end of MySQL was in January 2008, when Sun Microsystems bought MySQL for $ 1 billion. Oracle then acquired Sun Microsystems after receiving approval from the European Commission in 2009. Oracle made a public promise to the European Commission to keep MySQL alive and competitive until December 14, 2014, a term that has passed.
After Oracle took over MySQL, MySQL’s main developers left and created MariaDB in 2009.
Main reasons to choose MariaDB instead of MySQL
1. The main Oracle competitor acquired MySQL and no longer wants to be open source
2. Better Performance
3. MariaDB currently has more developers than MySQL and is open source
4. MariaDB is faster and security policy is better
5. MariaDB More New Technologies, Storage Engines, Extensions & New Features
6. Tests better
7. Active-active master clustering
8. MariaDB has gained popularity and is currently distributed by major Linux distributions
9. MariaDB is compatible with MySQL.
Migration can be done by running:
apt-get install mariadb-server
An example of the MariaDB.repo file for CentOS 7 is:
[MariaDB]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey = https: //yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck = 1
Install MariaDB with YUM
With the repo file instead, you can now install MariaDB as follows:
sudo yum install MariaDB-server MariaDB-client
By default, MariaDB is not secure. You can secure MariaDB using the mysql_secure_installation script. You should carefully read the steps that will determine the root password, remove anonymous users, allow remote root authentication, and remove the test database and access the Secure MariaDB section:
Configure it as follows:
– Set root password? [Y / n] y
– Remove anonymous users? [Y / n] y
– Disallow root login remotely? [Y / n] y
– Remove test database and access to it? [Y / n] y
– Reload privilege tables now? [Y / n] y
After installation is complete, start MariaDB with:
sudo systemctl start mariadb
MariaDB will include Maria DBMS and Prime XT, and according to Widenius’s statements, it will have fewer errors, a better test line, high performance, all compared to the Sun version of MySQL 5.1, which it said publicly unusable in the production environment, so MariaDB and Open Database Alliance are cherishing and being the most suitable alternative as a derivative of MySQL.