| Year of creation |
1995 |
2009 |
| Current version |
MySQL |
MariaDB 10.3.8 |
| Developer |
Oracle |
MariaDB Corporation Ab (MariaDB Enterprise)MariaDB Foundation (MariaDB Server) |
| License |
Dual licensing system (proprietary and GPL 2) |
LPG 2 |
| Operating systems |
Oracle LinuxRed HatCentOSOracle SolarisUbuntuDebian SUSE Enterprise LinuxMicrosoft WindowsMicrosoft Windows ServerApple macOSFreeBSDSolaris |
Red Hat / CentOSUbuntuDebianMint SUSE Enterprise Linux openSUSEMicrosoft Windows ServerMicrosoft WindowsManjaroFedoraArch Linux Apple macOS |
| Programming language |
C and C++ |
C, C++, Bash and Perl |
| Primary Database Model |
Relational database model |
Relational database model |
| Secondary database models |
Document-oriented database model Key-value database |
Document-oriented database model Key-value database Graph-oriented database |
| SQL interface |
Yes |
Yes |
| NoSQL interfaces |
Yes |
Yes |
| Protocol |
MYSQL protocol |
MYSQL protocol |
| Replications |
Replication with GTID (Global Transaction Identifier) - Master-master replication – Master-slave replication |
Replication with GTID (Global Transaction Identifier) - Master-master replication – Master-slave replication |
| Memory support |
Yes |
Yes |
| Routing |
MySQL Router (GPLv2) |
MariaDB MaxScale (BSL) |
| Sharding |
Horizontal partitioning, sharding with MySQL Cluster or MySQL Fabric |
Horizontal partitioning, sharding with Spider, CONNECT or Galera |
| SQL management |
MySQL Workbench (Microsoft Windows, macOS and Linux) |
SQLyog by Webyog (Microsoft Windows, Linux) |
| Supervision |
MySQL Enterprise Monitor (proprietary) |
Monyog by Webyog (Microsoft Windows and Linux) (proprietary) |
| Encryption |
Data at Rest Encryption – Tablespaces InnoDB |
Data At Rest Encryption- InnoDB Tablespaces – InnoDB Tables – InnoDB Log Files- Aria Tables- Temporary Data- Binlogs |
| Role-based access controls |
No |
Yes |
| Authentication |
Authentication via SHA-256 |
Authentication via ed25519 plugin |
| Data Masking |
Via ProxySQL |
Via MariaDB MaxScale (BSL) |
| Firewall |
Via MySQL Enterprise Firewall (proprietary) |
Via MariaDB MaxScale (BSL) |
| Audit |
Via MySQL Enterprise Audit plugin (proprietary) |
Via MariaDB Audit plugin |
| Analysis |
No |
Via MariaDB ColumnStore |
| Routing and load balancing |
Via MySQL Router |
Via MariaDB MaxScale (BSL) |
| Backup |
Via MySQL Enterprise Backup (proprietary) |
Via MariaDB Backup (Fork of Percona XtraBackup) |
| Common Table Expressions – Common Table Expression (CTE) |
Yes |
Yes |
| Window function |
Yes |
Yes |
| Temporal tables with versioning |
No |
Yes |
| Rewriting queries |
Yes |
No |
| Data types |
String (CHAR, VARCHAR, TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT, ENUM, SET, BINARY, VARBINARY, JSON)Numeric (BIT, TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT, DECIMAL, FLOAT, DOUBLE, BOOLEAN)Date/Time (DATE, DATETIME, TIMESTAMP, TIME, YEAR)Types of large object data (TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB) |
String (CHAR, VARCHAR, TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT, ENUM, SET, BINARY, VARBINARY, JSON)Numeric (BIT, TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT, DECIMAL, FLOAT, DOUBLE, BOOLEAN)Date/Time (DATE, DATETIME, TIMESTAMP, TIME, YEAR)Types of large object data (TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB) |
| Spatial Data Types |
GEOMETRYPOINTLINESTRINGPOLYGON MULTIPOINTMULTILINESTRINGMULTIPOLYGONGEOMETRYCOLLECTION |
GEOMETRYPOINTLINESTRINGPOLYGONMULTIPOINTMULTILINESTRINGMULTIPOLYGONGEOMETRYCOLLECTION |
| Database Engines |
InnoDBMyISAMMEMORYCSVArchiveBLACKHOLE MergeFederated |
InnoDB/XtraDBMyISAMMEMORYCSVArchiveBLACKHOLE MergeFederatedXColumnStoreAriaCassandra CONNECTMroongaMyRocksOQGRAPHSequence SphinxSESpiderTokuDB |
| Official connectors |
ODBCC++CADO.NETJDBCPHPPythonPerlRuby Node.js |
ODBCC++CADO.NETJDBCPHPPythonPerlRubyExcelJavaScriptSwiftR |
