# MariaDB 与 MySQL 比较

下表说明了MariaDB和MySQL之间的主要区别：

| \~                                      | MySQL                                            | MariaDB                                                                                                                     |
| --------------------------------------- | ------------------------------------------------ | --------------------------------------------------------------------------------------------------------------------------- |
| **开发商**                                 | Oracle公司                                         | `MariaDB Corporation AB (MariaDB Enterprise)`,`MariaDB基金会(社区MariaDB Server)`                                                |
| **协议**                                  | MySQL                                            | MySQL + MariaDB                                                                                                             |
| **源代码**                                 | 开源+专有                                            | 开源                                                                                                                          |
| **开发**                                  | 关闭                                               | 开放                                                                                                                          |
| **合作**                                  | 有限                                               | 广泛                                                                                                                          |
| **存储引擎**                                | InnoDB,MyISAM,BLACKHOLE,CSV,MEMORY,ARCHIVE,MERGE | InnoDB,MyISAM,BLACKHOLE,CSV,MEMORY,ARCHIVE,MERGE,ColumnStore,MyRocks,Aria,SphinxSE,TokuDB,CONNECT,SEQUENCE,Spider,Cassandra |
| **检查约束**                                | No                                               | Yes                                                                                                                         |
| **DEFAULT表达式**                          | No                                               | Yes,此外，还支持`BLOB`和[TEXT](http://www.yiibai.com/mysql/text.html)列的DEFAULT值                                                    |
| **虚拟列**                                 | Yes                                              | Yes                                                                                                                         |
| **动态列**                                 | No                                               | Yes                                                                                                                         |
| **角色**                                  | Yes                                              | Yes                                                                                                                         |
| **DELETE … RETURNING**                  | Yes                                              | No                                                                                                                          |
| **GIS支持**                               | Yes                                              | Yes                                                                                                                         |
| **ALTER TABLE和LOAD DATA INFILE语句的进度报告** | No                                               | Yes                                                                                                                         |
| **表消除**                                 | No                                               | Yes                                                                                                                         |
| **SQL管理**                               | MySQL Workbench                                  | SQLyog                                                                                                                      |
| **监控**                                  | MySQL Enterprise Monitor                         | Monyog                                                                                                                      |
| **备份**                                  | MySQL Enterprise Backup                          | MariaDB Backup                                                                                                              |
| **SQL公用表表达式(CTE)**                      | Yes(MySQL8.0+)                                   | Yes                                                                                                                         |
| **SQL窗口函数**                             | Yes(MySQL8.0+)                                   | Yes                                                                                                                         |
| **JSON支持**                              | Yes                                              | Yes                                                                                                                         |
| **数据屏蔽**                                | No                                               | 是(MariaDB MaxScale)                                                                                                         |
| **加密**                                  | MySQL Enterprise Encryption                      | MariaDB Encryption                                                                                                          |
| **数据库防火墙**                              | MySQL Enterprise Firewall                        | MaxScale Firewall                                                                                                           |
| **审计**                                  | MySQL Enterprise Audit                           | MariaDB Audit                                                                                                               |
| **Analytics(分析)**                       | No                                               | MariaDB ColumnStore                                                                                                         |
| **分区**                                  | MySQL Partitioning                               | MariaDB Partitioning                                                                                                        |
| **路由**                                  | MySQL Router                                     | MariaDB MaxScale                                                                                                            |
| **复制**                                  | MySQL Replication                                | MariaDB Replication                                                                                                         |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://hezhiqiang-book.gitbook.io/mysql/di-er-zhang/mariadb-yu-mysql-bi-jiao.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.