Features of MariaDB
MariaDB can be understood as the advanced version of MySQL, as it provides the same features of MySQL but with some extensions. MariaDB offers some unique features that are listed below.
- Licenced under GPL, LGPL, or BSD.
- Includes a wide selection of storage engines (including high-performance storage engines), for working with other RDBMS data sources.
- Uses a standard and popular querying language.
- Runs on a number of operating systems.
- Supports a wide variety of programming languages.
- Facilitates support for PHP.
- Facilitates Galera cluster technology.
- Facilitates many operations and commands unavailable in MySQL.
- Eliminated and replaced the MySQL features that have a negative impact on the performance.
Versions of MariaDB:
| Latest Version | Release Date | Original Version | Release Date | Status |
| 5.1.67 | 2013-01-30[13] | 5.1 | 2009-10-29[12] | Stable |
| 5.2.14 | 2013-01-30[15] | 5.2 | 2010-04-10[14] | Stable |
| 5.3.12 | 2013-01-30[17] | 5.3 | 2011-07-26[16] | Stable |
| 5.5.56 | 2017-05-03[19] | 5.5 | 2012-02-25[18] | Stable |
| 10.0.31 | 2017-05-23[21] | 10 | 2012-11-12[20] | Stable |
| 10.1.24 | 2017-05-31[23] | 10.1 | 2014-06-30[22] | Stable |
| 10.2.6 | 2017-05-23[25] | 10.2 | 2016-04-18[24] | Stable |
| 10.3.0 | 2017-04-16[27] | 10.3 | 2017-04-16[26] | Alpha |
MariaDB tutorial
- Install MariaDB
- Data Types in MariaDB
- CREATE DATABASE in MariaDB
- SELECT DATABASE in MariaDB
- DROP DATABASE in MariaDB
- DROP TABLE in MariaDB
- CREATE TABLE in MariaDB
- INSERT query in MariaDB
- Comparison Operator in MariaDB
- SELECT Query in MariaDB
- SELECT LIMIT in MariaDB
- UPDATE Query in MariaDB
- DELETE Query in MariaDB
- TRUNCATE TABLE in MariaDB
- WHERE clause in MariaDB
- LIKE Operator in MariaDB
- ORDER BY in MariaDB
- DISTINCT clause in MariaDB
- FROM clause in MariaDB
- SUM function in MariaDB
- MIN function in MariaDB
- COUNT function in MariaDB
- MAX function in MariaDB
- AVG function in MariaDB
- JOINS in MariaDB
- Left Outer join in MariaDB
- Right Outer Join in MariaDB
- UNION operator in MariaDB
- UNION ALL operator in MariaDB
- INTERSECT Operator in MariaDB
- MariaDB Export
- Function in MariaDB
- Procedure in MariaDB
- Regular Expressions in MariaDB
- Conditions in MariaDB
