Are you looking to install mariaDB on CentOS 7 operating system?, or are you facing any error while installing it. Well, don’t need to worry at all, here is a definitive guide to all your problems related to installation of mariaDB on your centOS operating system. We will cover all the technical terms which you might not be familiar with, and will be discussing the installation process in detail so that you may not find any error.
What is CentOS?
Community Enterprise Operating System or popularly known as CentOS is a free distribution of linux which is derived from the RHEL or Red hat enterprise linux.
It is a stable distribution of the linux operating system which is one the popular operating systems for the web hosting servers. Let us see, what are the features that made CentOS widely popular amongst the users.
Features of CentOS
- Extended support: While running an application, the most important thing is, support for the platform and stability. Suppose, the application stack is assumed to last for 7 years, and the operating system on which the application is built will be receiving updates for the next four years. Once the operating system reaches its life, you might run into some security issues.
With the CentOS operating system, the major versions get support for 10 years. This means that the CentOS which was released on 7th July 2014, will be supported for 10 years, i.e till 30th June 2024.
Since, the release cycle is longer, and as CentOS uses a very stable version of it’s software, updating applications is not needed often.
- Security: Security is one of the most important issues that every software, operating system, mobile application etc. should provide. Talking about the centOS operating system, it comes with multiple built-in security features. By utilizing Security enhanced linux (SElinux), centOS protects it’s users from cyber attacks.
[su_label type=”info”]Also check[/su_label] Mongodb vs Mysql : Better based on performance
MariaDB and what is so special about it?
Many people who have worked on databases might be familiar with the popular RDBMS, “mariaDB”. However, if you have never heard about databases, mysql, mariaDB earlier, then no need to worry, we will cover everything in easy terms. To begin with let us first have a look at what is Relational database management system or RDBMS.
In simple terms, a RDBMS is a digital database, which is based on the relational model of the data. It is a database management system, that is designed specially for the relational databases. Relational databases store the data in the form of relations, tables, rows and columns.
Now coming to MySQL. MySQL is a relational database management system, which is made in SQL or the structured query language. But what about MariaDB?
Well, MariaDB is also an open source relational database management system. However, MariaDB intends to have a high compatibility with MySQL. Basically, MariaDB is a fork of mySQL.
An amazing fact about mariaDB is that, it permits you to change from MySQL to mariaDB without changing the applications. This is because the data and data structures do not require change.
The technical support, consulting, certification and training for MySQL is provided by Oracle. While MariaDB has its own support services.
MySQL is used by some of the popular organisations and companies like, facebook, netflix, github,etc. MariaDB is used by centOS, archlinux, wikipedia, etc.
[su_label type=”info”]Also check[/su_label] How To Install MongoDB Windows 10 Easiest Way
How to install mariaDB on centOS 7
Well, till now you might have got an idea about, CentOS and mariaDB. Now let’s move to the guide to install mariaDB on centOS 7.
Step 1:
The first step to install mariaDB on centos 7 is adding the mariaDB YUM repository. Write the following command to enable the MariaDB 10 repository on your centOS operating system.
sudo nano /etc/yum.repos.d/MariaDB.repo
After executing the above command you have to write the following code to your respective linux version.
[mariadb]
name=MariaDB
baseurl=http://yum.mariadb.org/10.1\centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
Once you are done with performing all the steps shown above, let’s now move to step 2, where we will be adding installing it.
Step 2:
Now let us move forward to installing the mariaDB client packages and the mariaDB server on your centOS 7 operating system. This can be done using the simple command given below.
sudo yum install MariaDB-server MariaDB-client
Now that you have installed it, let’s start the mariaDB service using the simple command given below:
sudo systemctl start mariadb
If you installed mariaDB correctly on centOS 7, then you can easily check it by running the command given below:
sudo systemctl status mariadb
The output would be something like this:
- mariadb.service – MariaDB 10.3.8 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: inactive (dead)
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Type the following command in your terminal, to start mariaDB after the boot process.
sudo systemctl enable mariadb
Step 3:
Well, you have installed mariaDB on centOS 7 correctly. But wait, there is still one final step remaining i.e security. This includes, disabling the remote root login, setting the root password, removing the test databases, etc.
sudo mysql_secure_installation
To view the version of MariaDB installed you can write the following command:
Mysql -v
You can also log in to the MariaDB by writing the following code:
Mysql -u root -p
[su_label type=”info”]Also check[/su_label] Download CentOS 7 : working links and how to install ?
Secure and strong databases are one of the most important factors for running any organization, or business. However, it depends on your need which kind of database you need.
We have discussed all the steps that are needed to install mariaDB on centOS 7 operating system. In case you find any error, then you can surely drop a comment below to know your problem.