MariaDB is a free and community-driven relational database system that serves as a fully compatible drop-in replacement for the widely used MySQL database management system.

It originated as a fork of MySQL following concerns from the original developers regarding MySQL’s acquisition by Oracle. Since its inception, MariaDB has been committed to staying free and open-source under the GNU license.

MariaDB is highly favored for its exceptional performance, scalability, reliability, and resilience. It supports a broad array of operating systems such as Linux, FreeBSD, Mac, and Windows.

With a wide variety of storage engines, plugins, and other advanced tools, it offers a versatile solution suitable for many applications including data analytics, data warehousing, and transactional processing. Furthermore, it plays an essential role in both LAMP & LEMP stacks, commonly used for deploying web applications.

MariaDB Features

Some notable features of MariaDB include:

• Galera clustering support.
• A range of new storage engines like InnoDB, XtraDB, Aria, TokuDB, CONNECT, and SEQUENCE.
• Enhanced and faster replication capabilities.
• An advanced thread pool capable of handling up to 200,00 simultaneous connections.
• Additional features such as system-versioned tables, anchored data types, and UNIX socket authentication.

In this guide, we will walk you through the steps required to install the MariaDB database server on Rocky Linux 8 and AlmaLinux 8.

Step 1: Add MariaDB Repository in Rocky Linux

By default, the Rocky Linux AppStream repository includes MariaDB 10.3, which is not the most recent stable version currently available. At the time of writing, the latest stable release is MariaDB 10.6.

To proceed with installing the newer version, create a MariaDB repository file using the command below.

<code>$ sudo vim /etc/yum.repos.d/mariadb.repo</code>

Insert the following lines into the file:

<code>[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.6/rhel8-amd64
module_hotfixes=1
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1 </code>

Save your changes and exit the editor.

Next, refresh the package list so that the new repository is recognized.

<code>$ sudo dnf update</code>

Step 2: Install MariaDB in Rocky Linux

Once the repository is properly configured, install the MariaDB database server using the command below.

<code>$ sudo dnf install mariadb-server mariadb</code>

After installation completes, enable the MariaDB service to start automatically at boot and then manually start the service with the commands:

<code>$ sudo systemctl enable mariadb
$ sudo systemctl start mariadb</code>

Check the current status of the MariaDB service to ensure everything is functioning correctly.

<code>$ sudo systemctl status mariadb</code>

The output should indicate that the service is active and running without errors.

Step 3: Secure MariaDB in Rocky Linux

By default, MariaDB ships with insecure settings that may expose the system to potential threats. To mitigate these risks, additional configuration is necessary.

Run the following script to improve security.

<code>$ sudo mysql_secure_installation</code>

You will first be prompted to set a strong root password.

For the rest of the prompts, press ‘Y’ to remove anonymous users, disable remote root login, eliminate the test database, and save the updated settings.

To access the MariaDB shell, run the following command:

<code>$ sudo mysql -u root -p</code>

Enter the root password you previously set and hit ENTER to log in to the MariaDB console.

That's it. You have successfully installed the MariaDB database server on Rocky Linux 8. Keep in mind that you can also use the version provided by the AppStream repository if you don’t require the latest features. However, adding the official MariaDB repository ensures you get the most up-to-date release.

The above is the detailed content of How to Install MariaDB on Rocky Linux and AlmaLinux. For more information, please follow other related articles on the PHP Chinese website!