mysql - MySQL 和 MariaDB 之间到底有什么区别？

Question

XAMPP 的先前版本将包括 MySQL。现在它们包括 MariaDB。
我曾经使用以前的版本，但现在我升级了 XAMPP，它有 MariaDB。

那么它们之间究竟有什么区别呢？还是两者相似？

我应该对我的编程方法进行哪些更改？

我应该切换到以前的版本吗？

Answer 1

根据MariaDB documentation :

Until MariaDB 5.5, MariaDB versions functioned as a "drop-in replacement" for the equivalent MySQL version, with some limitations. From MariaDB 10.0, it is usually still very easy to upgrade from MySQL.

[...]

This means that for many cases, you can just uninstall MySQL and install MariaDB and you are good to go. There is not generally any need to convert any data files.

另请注意，根据同一文档页面:

However, the implementation differences continue to grow in each new MariaDB version.

要了解 MySQL 和 MariaDB 版本之间的确切区别，请参阅文档中的特定页面:

Incompatibilities and Feature Differences Between MariaDB 10.5 and MySQL 8.0

Incompatibilities between MariaDB 10.4 and MySQL 8.0

Incompatibilities between MariaDB 10.3 and MySQL 5.7

Incompatibilities between MariaDB 10.2 and MySQL 5.7

您也可以查看 this answer on Software Engineering Stack Exchange