Updated July 4, 2023
Definition of MariaDB Versions
MariaDB is one of the most popular servers in the world. It is open resource relational database management with Oracle database management such as transparent sharding, instant schema changes, rollback, and advanced features like JSON. MariaDb is available for all repositories of major repositories for the UNIX operating system. Another way we can say it is another child version of MySql with some limitations. The MariaDB is a very easy upgrade,. The MariaDB creates binary files that are compatible with the MySql version, wherein the path and file names generally remain the same as the record and table, ensuring binary compatibility.
Top 11 MariaDB Version
Basically, MariaDB has different versions as follows.
1. MariaDB Server 10.6
This is the main current development version of MariaDB, but yet not been released. MariaDB 10.5 is the current and stable version. In 10.6, they improve some functionality as well as it has new features.
2. MariaDB Server 10.5
Actually, 10.5 is a current version of MariaDB. This version is a stable version of MariaDB, and it was released in June 2020 and will be supported up to June 2025. MariaDB included a Columnstore storage engine with a series of different release versions in this release.
3. MariaDB Server 10.4
10.4 is a previous version of MariaDB and its stable version, it was released in June 2019 and is valid up to, or we can say, it is supported until June 2024. The main feature of this version is that authentication means it provides different functions to users, such as password expiry, account locking facility, and another authentication plug-in, and has a series of different release versions.
4. MariaDB Server 10.3
The 10.3 is a previous version of the MariaDB server. The first stable version of the MariaDB server was released in May 2018. It remained valid until May 2023 and underwent a series of different release versions during its lifespan. This version basically focuses on syntax and general features of the MariaDB server as follows.
- It provides AS OF functionality.
- Row type supported by local SP variable.
- It also supported aggregate.
- It also supports the LIMIT clause and FOR statement.
- Create sequence, show sequence, alter sequence, and drop sequence.
- It supported the DDL command, delete statement, and update statement.
- As well as order by clause and date format.
- It also allows us to create packages, drop packages, show packages, create package body, drop package body, and show package bodies, etc.
5. MariaDB Server 10.2
The 10.2 version of MariaDB Server, released in May 2017, is considered an older version. It remained valid until May 2022 and went through a series of different release versions during its lifecycle. In this version of the MariaDB server, the default storage engine is InnoDB as well as it also introduces some new features as follows.
- It supports checkpoint, creates a user, alters the user, and shows it.
- In this version, decimal numbers are increased from 30 to 38.
- It supports executing immediate statements
6. MariaDB Server 10.1
This is also one version of MariaDB; it was released in Oct 2014 and is valid until Oct 2020. The feature of this version is Galera. The Galera is a one type cluster in the MariaDB server; It is a virtually synchronous multi-master solution in MariaDB server; it runs only on Linux operating system platform statements and has a series of different release versions.
7. MariaDB Server 10.0
In March 2014, one of the versions of the MariaDB server was released. It remained valid until January 2019 and underwent a series of different release versions during its lifespan. Some key features added in this version are as follows
- System Variable added.
- Parallel Replication was also added in this version.
- Connect Storage is also available in this version.
- Global Transaction ID is also available in this version.
- Multi Resource introduced in this version means the single server has a multiple masters.
- Show Explain Statement.
- Shutdown statement etc.
8. MariaDB Server 5.5
The oldest version of MariaDB is 5.5, which was released in April 2012. This version remained valid until April 2020 and underwent a series of different release versions. It introduced the main comparison matrix features, and it also introduced some other features as follows.
- This version is more suitable for thread pools.
- This version of MariaDB supports Non-Blocking Operations.
- The status variable command is also available in this version, and it is useful to take user feedback.
9. MariaDB Server 5.3
The very first version of the MariaDB server, released in April 2010, marked the beginning of a series of release versions. However, its support was valid only until January 2013 and is no longer supported. MariaDB introduced new storage engines in this version, namely OQGRAPH, and SphinxSE. The OQGRAPH engine is particularly beneficial for managing tree structures and handling complex graphs. On the other hand, SphinxSE specifically enhances text search capabilities within the MariaDB server. It enables users to execute search queries directly within MariaDB, making it a powerful tool for efficient and integrated full-text search functionality.
10. MariaDB Server 5.2
The earliest version of the MariaDB server, released in April 2010, represents the initial release in a series of versions. The final release of this particular version occurred in January 2013, encompassing a series of different release versions. Key version of this version is the same as version 5.3, as well as some other features as follows.
- Extended User Statistics.
- Pluggable Authentication.
- Group Commit.
11. MariaDB Server 5.1
The very first version of the MariaDB server, released in Oct 2009, marked the beginning of a series of releases. However, the last series release occurred in Jan 2013, signifying a different set of releases. It has different storage engines such as XtraDB, Aria, and FederatedX, etc.
Conclusion- MariaDB Versions
We hope from this article; you understand the MariaDB Server’s version. The article above taught us about a different version of the MariaDB Server. We also learned the key point of each version in MariaDB. From this article, we learned how and when we use MariaDB Server.
Recommended Articles
We hope that this EDUCBA information on “MariaDB Versions” was beneficial to you. You can view EDUCBA’s recommended articles for more information.