Starting from CentOS/RHEL 7, standard MySQL (Oracle) package is no longer available and has been replaced by MariaDB. There will be almost no difference when managing MariaDB since it is basically a drop-in replacement for MySQL. Certainly, MariaDB has attracted huge attention and many of existing MySQL users have been switching to MariaDB, this includes Google and Tumblr.
To install MySQL/MariaDB on CentOS 7 box, just use following command:
$ yum install mariadb mariadb-server |
In RHEL, when you run yum install mysql, it will automatically install mariadb 5.5. The MySQL configuration still located in the familiar location: /etc/my.cnf, the MySQL error log is located at /var/log/mariadb/mariadb.log while the data directory is still located at /var/lib/mysql.
CentOS 7 runs on systemd, thus to start the service (similar to service mysqld start):
$ systemctl start mariadb.service |
** Other options are: restart, stop, status
To enable the service to start on boot (similar to chkconfig mysqld on):
$ systemctl enable mariadb.service |
Above are the only differences when managing MySQL running on CentOS/RHEL 7. To retrieve the list of services with the status, use following command:
$ systemctl list-units |
Or:
$ systemctl list-unit-files |
That’s it. Having MariaDB as replacement for MySQL is definitely a great choice. You would have no regret using it!