SQL

MariaDB – excellent relational database system

MariaDB Server is one of the most popular database servers in the world. It’s made by the original developers of MySQL and guaranteed to stay open source. Notable users include Wikipedia, WordPress.com and Google.

MariaDB seeks high compatibility with MySQL, ensuring a drop-in replacement capability with library binary parity and exact matching with MySQL APIs and commands. It includes a new storage engine, Aria, an alternative to MyISAM that intends to be the default transactional and non-transactional engine.

There are millions of installations of MariaDB worldwide, and thousands of downloads a day of MariaDB installation software.

Key Features

  • Very fast in operation.
  • Focus on performance and based on its threading model, MariaDB features scale out technologies.
  • Scalable – able to handle tens of thousands of tables and billions of rows of data.
  • Built-in functions include ones for manipulating and formatting text, business and statistical calculations, recording chronological information, as well as specialty features such ones related to GPS mapping.
  • Several storage engines with different advantages. Some are transaction-safe storage engines that allow for rollback of data
  • Full integration with Galera cluster — an add-on for MariaDB for running multiple database servers for better performance and high availability.
  • Focus on security with encryption.

Website: mariadb.org
Support: Blog
Developer: MariaDB Corporation AB, MariaDB Foundation
License: General Public License v2.0

MariaDB is written in C++ and C. Learn C++ with our recommended free books and free tutorials. Learn C with our recommended free books and free tutorials.


Related Software

Column-Oriented Databases
MariaDB ColumnStoreUses a massively parallel distributed data architecture
DuckDBIn-process SQL OLAP database management system
DruidHigh performance, real-time analytics database
DatabendCloud data warehouse
ClickHouseReal-time analytics database management system
InfluxDB CoreScalable datastore for metrics, events, and real-time analytics
DorisModern data warehouse for real-time analytics
VictoriaMetricsScalable solution for monitoring and managing time series data
StarRocksHigh-performance analytical database
MonetDBHigh performance relational database system for analytics
KuduDistributed data storage engine
QuestDBHigh-performance time-series database
PinotReal-time analytics platform
IoTDBHigh-performance time-series database
GreptimeDBCloud-native database
CrateDBDistributed SQL database management

Read our verdict in the software roundup.

Relational Databases
MariaDBSeeks high compatibility with MySQL, ensuring drop-in replacement capability
PostgreSQLAward winning Object-relational database management system
MySQLMultithreaded, multi-user SQL database management system
SQLiteEmbeddable SQL Database Engine
rqliteDistributed database built on SQLite
MonetDBHigh performance relational database system for analytics
FirebirdRelational database offering many ANSI SQL features
H2Relational database management system written in Java
HSQLDBJDBC interface, client-server version, query tool, grid and more
CUBRIDDatabase engine with built-in enterprise grade features
VirtuosoData Management with Web Application Server and Web Services Platform
Apache DerbyFull-featured relational database implemented entirely in Java

Read our verdict in the software roundup.


Best Free and Open Source Software Explore our comprehensive directory of recommended free and open source software. Our carefully curated collection spans every major software category.

This directory is part of our ongoing series of informative articles for Linux enthusiasts. It features hundreds of detailed reviews, along with open source alternatives to proprietary solutions from major corporations such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk.

You’ll also find interesting projects to try, hardware coverage, free programming books and tutorials, and much more.

Discovered a useful open source Linux program that we haven’t covered yet? Let us know by completing this form.
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments