What is MariaDB and How to Install MariaDB On Windows
Today, We will learn the basics of MariaDB and Will also Download and install MariaDB on Windows.
What is MariaDB?
MariaDB is a fork of the MySQL database management system. It is created by its original developers. This DBMS tool offers data processing capabilities for both small and enterprise tasks.
MariaDB is an improved version of MySQL. It comes with numerous inbuilt powerful features and many usabilities, security, and performance improvements that you cannot find in MySQL.
Here are the features of MariaDB:
- It operates under GPL, BSD or LGPL licenses.
- MariaDB supports a popular and standard querying language.
- It comes with many storage engines, including the high-performance ones that can be integrated with other relational database management systems.
- It provides the Galera cluster technology.
- MariaDB supports PHP, a popular language for web development.
- MariaDB can run on different operating systems, and it supports numerous programming languages.
- MariaDB comes with additional commands that are not available in MySQL. MySQL has features which have a negative impact on the performance of the DBMS. Such features have been replaced in MariaDB.
MariaDB vs. MySQL
| Parameter | MariaDB | MySQL |
|---|---|---|
| More Options for Storage Engines | MariaDB has 12 new storage engines that you won’t find in MySQL. | It has fewer options for storage compared to MariaDB. |
| Speed Improvements | MariaDB shows an improved speed when compared to MySQL. It comes with numerous features for optimizing speed. Such features include derived views/tables, subquery, execution control, disk access, and optimizer control. | MySQL exhibits a slower speed when compared to MariaDB. It relies on only a few features for speed optimization, for example, hash indexes. |
| Faster cache/indexes | With the Memory storage engine of MariaDB, an INSERT statement can be completed 24% than in the standard MySQL. | The memory storage engine of MySQL is slower compared to that MariaDB. |
| Larger and Faster Connection Pool | MariaDB comes with an advanced thread pool capable of running faster and supporting up to 200,000+ connections. | The thread pool provided by MySQL cannot support up to 200,000 connections per time. |
| Improved Replication | In MariaDB, replication can be done safer and faster. Updates can also be done 2x faster compared to the traditional MySQL. | MySQL’s community edition allows a static number of threads to be connected. MySQL’s enterprise plan comes with thread capabilities. |
| New Features/Extensions | MariaDB comes with new features and extensions including the JSON, WITH, and KILL statements. | The new MariaDB features are not provided in MySQL. |
| Missing Features | MariaDB lacks some of the features provided by the MySQL enterprise edition. To address this, it offers alternative open-source plugins. Hence, MariaDB users are able to enjoy the same functionalities as MySQL Enterprise Edition users. | The Enterprise Edition of MySQL uses a proprietary code. Only users of MySQL Enterprise Edition have access to this. |
Installation of MariaDB
Install as a Standalone Application
In order to use MariaDB, you have to install it on your computer.
The installation can be done by following the steps given below:
Step 1) Download the installation file from the following URL:
https://downloads.mariadb.org/
Step 2) Once the download is complete, double-click the file to start the installation.
Step 3) On the window that pops up, click the Next button:
Step 4) Next, accept the license agreement by activating the checkbox then click the Next button:
Step 5) Next, choose the features that are to be installed and click the Next button.
Step 6) In the next window, you will be required to change the password for the root user.
- Enter the password and confirm it by retyping the same password. If you want to permit access from remote machines, activate the necessary checkbox.
- Once done, click the Next button.
Step 7) In the next window, type a name for the instance, choose the port number, and set the necessary size. Click the Next button:
Step 8) In the next window, simply click the Next button.
Step 9) Launch the installation by clicking the Install button.
Step 10) A progress bar showing the progress of the installation will be shown:
Step 11) Once the installation is complete, you will see the Finish button. Click the button to close the window:
