{"id":5900,"date":"2017-07-03T02:23:04","date_gmt":"2017-07-03T09:23:04","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=5900"},"modified":"2023-12-29T06:28:31","modified_gmt":"2023-12-29T13:28:31","slug":"mariadb-vs-mysql","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mariadb-vs-mysql\/","title":{"rendered":"MariaDB vs. MySQL"},"content":{"rendered":"\n

The following table illustrates the main differences between MariaDB and MySQL:<\/p>\n\n\n\n

<\/th>MySQL<\/strong><\/th>MariaDB<\/strong><\/th><\/tr><\/thead>
Developer<\/strong><\/td>Oracle Corporation<\/td>MariaDB Corporation AB (MariaDB Enterprise),
\nMariaDB Foundation (community MariaDB Server)<\/td><\/tr>
Protocols<\/strong><\/td>MySQL<\/td>MySQL + MariaDB<\/td><\/tr>
Source code<\/strong><\/td>Open Source + Proprietary<\/td>Open Source<\/td><\/tr>
Development<\/strong><\/td>Closed<\/td>Open<\/td><\/tr>
Collaboration<\/strong><\/td>Limited<\/td>Extensive<\/td><\/tr>
Storage Engines<\/strong><\/a><\/td>InnoDB
\nMyISAM
\nBLACKHOLE
\nCSV
\nMEMORY
\nARCHIVE
\nMERGE<\/td>		InnoDB
\nMyISAM
\nBLACKHOLE
\nCSV
\nMEMORY
\nARCHIVE
\nMERGE
\nColumnStore
\nMyRocks
\nAria
\nSphinxSE
\nTokuDB
\nCONNECT
\nSEQUENCE
\nSpider
\nCassandra<\/td><\/tr>
CHECK constraint<\/strong><\/td>No<\/td>Yes<\/td><\/tr>
DEFAULT expression<\/strong><\/td>No<\/td>Yes. Also, support DEFAULT values for BLOB<\/code> and TEXT<\/a><\/code> columns<\/td><\/tr>
Virtual columns<\/strong><\/a><\/td>Yes<\/td>Yes<\/td><\/tr>
Dynamic columns<\/strong><\/td>No<\/td>Yes<\/td><\/tr>
Roles<\/strong><\/a><\/td>Yes<\/td>Yes<\/td><\/tr>
DELETE \u2026 RETURNING<\/strong><\/td>Yes<\/td>No<\/td><\/tr>
GIS support<\/strong><\/td>Yes<\/td>Yes<\/td><\/tr>
Progress Reporting for ALTER TABLE<\/a><\/code> and LOAD DATA INFILE<\/a><\/code> statement<\/strong><\/td>No<\/td>Yes<\/td><\/tr>
Table Elimination<\/strong><\/td>No<\/td>Yes<\/td><\/tr>
SQL Management<\/strong><\/td>MySQL Workbench<\/td>SQLyog<\/td><\/tr>
Monitoring<\/strong><\/td>MySQL Enterprise Monitor<\/td>Monyog<\/td><\/tr>
Backup<\/strong><\/td>MySQL Enterprise Backup<\/td>MariaDB Backup<\/td><\/tr>
SQL Common Table Expressions (CTE<\/a>)<\/strong><\/td>Yes (since version 8.0)<\/td>Yes<\/td><\/tr>
SQL Window Functions<\/strong><\/td>Yes (since version 8.0)<\/td>Yes<\/td><\/tr>
JSON Support<\/strong><\/td>Yes<\/td>Yes<\/td><\/tr>
Data Masking<\/strong><\/td>No<\/td>Yes. (MariaDB MaxScale)<\/td><\/tr>
Encryption<\/strong><\/td>MySQL Enterprise Encryption<\/td>MariaDB Encryption<\/td><\/tr>
Database firewall<\/strong><\/td>MySQL Enterprise Firewall<\/td>MaxScale Firewall<\/td><\/tr>
Auditing<\/strong><\/td>MySQL Enterprise Audit<\/td>MariaDB Audit<\/td><\/tr>
Analytics<\/strong><\/td>No<\/td>MariaDB ColumnStore<\/td><\/tr>
Partitioning<\/strong><\/td>MySQL Partitioning<\/td>MariaDB Partitioning<\/td><\/tr>
Routing<\/strong><\/td>MySQL Router<\/td>MariaDB MaxScale<\/td><\/tr>
Replication<\/strong><\/td>MySQL Replication<\/td>MariaDB Replication<\/td><\/tr><\/tbody><\/table><\/figure>\n
\n\t
\n\t\t
Was this tutorial helpful? <\/div>\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
\n\t\t
\n\t\t\t
<\/div>\n\t\t\t\n\t\t\t