Pages

MySQL vs MariDB

MySQL: MySQL is an open-source relational database management system (RDBMS). Just like all other relational databases, MySQL uses tables, constraints, triggers, roles, stored procedures and views as the core components that you work with. A table consists of rows, and each row contains a same set of columns. MySQL uses primary keys to uniquely identify each row (a.k.a record) in a table, and foreign keys to assure the referential integrity between two related tables.

MariaDB: Since MariaDB is a fork of MySQL, the database structure and indexes of MariaDB are the same as MySQL. This allows you to switch from MySQL to MariaDB without having to alter your applications since the data and data structures will not need to change. This means that: data and table definition files are compatible client protocols, structures, and APIs are identical MySQL connectors will work with MariaDB without modification


Developer

Oracle Corporation

MariaDB Corporation AB (MariaDB Enterprise),
MariaDB Foundation (community MariaDB Server)

Protocols

MySQL

MySQL + MariaDB

Source code

Open Source + Proprietary

Open Source

Development

Closed

Open

Collaboration

Limited

Extensive

InnoDB
MyISAM
BLACKHOLE
CSV
MEMORY
ARCHIVE
MERGE

InnoDB
MyISAM, BLACKHOLE, CSV, MEMORY, ARCHIVE, MERGE, ColumnStore, MyRocks, Aria, SphinxSE, TokuDB, CONNECT, SEQUENCE, Spider, Cassandra

CHECK constraint

No

Yes

DEFAULT expression

No

Yes. Also, support DEFAULT values for BLOB and TEXT> columns

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 LOAD DATA INFILE statement

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