por The server MariaDB is an open source relational database which is very popular within the Linux user community. Its fundamental pillars are the values of performance, stability and openness. Besides, MariaDB Foundation has the license GPL or GNU General Public License (version 2).
It was developed with the objective of providing similar and improved functionalities of MySQL software.
MariaDB allows editing, saving and extracting information from a database, among other tools. Additionally, it should be noted that to use this tool you must first install the client, the server, and some of the development tools.
History of MariaDB
This database manager was developed by one of the founders of the software company MySQL AB: Michael “Monty” Widenius. The MySQL database project was initially acquired by Sun Microsystem towards February 2008, remaining as a platform open source or open source.
However, Michael Widenius feared that the database he had developed could be bought and privatized by another company, so he took the original MySQL source code and created MariaDB as its derivative.
Indeed Sun Microsystem It was acquired around 2010 by the company praycthe Corporationwhich made the MySQL project start working under a dual license of the GPL type and a Commercial License which allows you to possess the copyright of the majority of the code and prevent free access to its source code. Widenius, together with a community of developers forked the project and created a new open source derivative called MariaDB.
This MariaDB server, being a version of MySQL, It has all the functionalities of that database up to version 5.5, in addition to certain extra features such as performing queries of a high level of complexity and being able to store them directly in the cache, and the use of hierarchies of graphs and other structures. Additionally, you may find many references to MySQL in your configuration files.
Currently, MariaDB stands out as one of the most used databases by users of the Linux operating system and Red Hatas well as most distributions that include it within their repositories.
MariaDB Features
The MariaDB database management system server is responsible for converting data into structured information in a large number of applications such as WordPress, MediaWiki, Drupal, ownCloud, Moodle, among others. The features of MariaBD are:
Additionally, MariaDB chas storage engines such as Aria, XtraDBFederateX, SphinxSE, TokuDB, among others, the most important being:
Aria– is MariaDB’s failsafe, transactional and non-transactional storage method and works as an alternative to MySQL’s MyISAM engine. Use the cache to store rows of data instead of writing to disk.
XtraDB– It was developed to replace the InooDB storage engine and helps with MariaDB features.
Using these engines, especially Aria, allows MariaDB run at high speed when performing complex queries. Furthermore, the functions of MariaDB lie in the fact that it has CheckSum Table o Checksum Table, which operates faster. MariaDB also reduced the time of unnecessary character conversions, which, in addition to the previously mentioned features, has made the system run faster.
This database manager also added extensions with new functionalities such as managing up to 32 segments per keyor the use of pool of execution threads or processes, which allows MariaDB to have up to 200,000 connections. Another new feature is the inclusion of –abort-source-on-error to the MySQL client. Furthermore, it adds the use of virtual columnsas well as an increase in the accuracy of the process list.
Another feature of MariaBD is the use of extended statistics for the user, storage engine selection, and segmented key cache. And it stands out for offering better security measures than other databases, because it includes elements such as password verification, PAM and LDAD authentication, user roles and database encryption.
Another feature of MariaBD is that it provides better user assistance, as the user can make use of a notification, patch and error solution service, as well as a help time of a maximum of 30 minutes.
Install MariaDB
To install this database manager, the user will have go to the MariaDB website and select the appropriate installation options according to your device.
Then, the service must be enabled with the command systemctl start mariadb and systemctl enable mariadb.
After installing it, the command must be launched mysql_secure_installationwho will be in charge of apply security optionssuch as the password root or administrator user, the elimination of anonymous users, and the disabling in login or login remote root.
We only have to talk about the advantages and disadvantages of MariaDB.
What is the next step?
Now that you know what the MariaDB database server is, what its history is, its main features and the functions of MariaDB, and how to install it, Do not hesitate to continue your training process through our DevOps & Cloud Computing Full Stack Bootcamp, where in less than 6 months you will be able to learn about this and other tools that will allow you to become an expert in these topics and stand out within the IT sector. Furthermore, with our Boot Camp you will be able to learn methodologies that will help you improve and streamline your technological development processes, thus obtaining an advantage over your competitors.