Developer |
Oracle Corporation |
MariaDB Corporation AB (MariaDB Enterprise), |
Protocols |
MySQL |
MySQL + MariaDB |
Source code |
Open Source + Proprietary |
Open Source |
Development |
Closed |
Open |
Collaboration |
Limited |
Extensive |
|
InnoDB |
InnoDB |
CHECK constraint |
No |
Yes |
DEFAULT expression |
No |
Yes. Also, support DEFAULT values for |
Virtual columns |
Yes |
Yes |
Dynamic columns |
No |
Yes |
Roles |
Yes |
Yes |
DELETE … RETURNING |
Yes |
No |
GIS support |
Yes |
Yes |
Progress Reporting for ALTER
TABLE and |
No |
Yes |
Table Elimination |
No |
Yes |
SQL Management |
MySQL Workbench |
SQLyog |
Monitoring |
MySQL Enterprise Monitor |
Monyog |
Backup |
MySQL Enterprise Backup |
MariaDB Backup |
SQL Common Table Expressions |
Yes (since version 8.0) |
Yes |
SQL Window Functions |
Yes (since version 8.0) |
Yes |
JSON Support |
Yes |
Yes |
Data Masking |
No |
Yes. (MariaDB MaxScale) |
Encryption |
MySQL Enterprise Encryption |
MariaDB Encryption |
Database firewall |
MySQL Enterprise Firewall |
MaxScale Firewall |
Auditing |
MySQL Enterprise Audit |
MariaDB Audit |
Analytics |
No |
MariaDB ColumnStore |
Partitioning |
MySQL Partitioning |
MariaDB Partitioning |
Routing |
MySQL Router |
MariaDB MaxScale |
Replication |
MySQL Replication |
MariaDB Replication |
No comments:
Post a Comment