MariaDB vs. MySQL

Created with Sketch.

MariaDB vs. MySQL

 

The following table illustrates the main differences between MariaDB and MySQL:

MySQLMariaDB
DeveloperOracle CorporationMariaDB Corporation AB (MariaDB Enterprise),
MariaDB Foundation (community MariaDB Server)
ProtocolsMySQLMySQL + MariaDB
Source codeOpen Source + ProprietaryOpen Source
DevelopmentClosedOpen
CollaborationLimitedExtensive
Storage EnginesInnoDB
MyISAM
BLACKHOLE
CSV
MEMORY
ARCHIVE
MERGE
InnoDB
MyISAM
BLACKHOLE
CSV
MEMORY
ARCHIVE
MERGE
ColumnStore
MyRocks
Aria
SphinxSE
TokuDB
CONNECT
SEQUENCE
Spider
Cassandra
CHECK constraintNoYes
DEFAULT expressionNoYes. Also, support DEFAULT values for BLOB and TEXT columns
Virtual columnsYesYes
Dynamic columnsNoYes
RolesYesYes
DELETE … RETURNINGYesNo
GIS supportYesYes
Progress Reporting for ALTER TABLE and LOAD DATA INFILE statementNoYes
Table EliminationNoYes
SQL ManagementMySQL WorkbenchSQLyog
MonitoringMySQL Enterprise MonitorMonyog
BackupMySQL Enterprise BackupMariaDB Backup
SQL Common Table Expressions (CTE)Yes (since version 8.0)Yes
SQL Window FunctionsYes (since version 8.0)Yes
JSON SupportYesYes
Data MaskingNoYes. (MariaDB MaxScale)
EncryptionMySQL Enterprise EncryptionMariaDB Encryption
Database firewallMySQL Enterprise FirewallMaxScale Firewall
AuditingMySQL Enterprise AuditMariaDB Audit
AnalyticsNoMariaDB ColumnStore
PartitioningMySQL PartitioningMariaDB Partitioning
RoutingMySQL RouterMariaDB MaxScale
ReplicationMySQL ReplicationMariaDB Replication

Leave a Reply

Your email address will not be published. Required fields are marked *