MySQL xtradb 与 innodb
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/12037363/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
xtradb vs innodb
提问by thedethfox
I was asked to check Mariadb as Centos does not provider MySQL 5.5 for the moment. I have read that xtradb servers as a drop in for innodb.
我被要求检查 Mariadb，因为 Centos 目前不提供 MySQL 5.5。我已经读过 xtradb 服务器作为 innodb 的替代品。
What are the advantages of using one or the other because if they were equal, they would not have been called the same name?
使用一个或另一个有什么好处，因为如果它们相等，它们就不会被称为同名？
Do you think that I should switch to Mariadb? What kind of problems I might face in the future because of updates if any.
你认为我应该改用 Mariadb 吗？如果有更新，我将来可能会遇到什么样的问题。
I know that the founder of MySQL is behind Mariadb, and Oracle is managing MySQL now. It seems a bit tricky as a tricky decision.
我知道 MySQL 的创始人在 Mariadb 的背后，而 Oracle 现在在管理 MySQL。作为一个棘手的决定，这似乎有点棘手。
Thank you in advance for your opinion,
预先感谢您的意见，
Update,I asked the question here, because google did not display any recent updates. Only some old comparisons published prior to 2012
更新，我在这里问了这个问题，因为谷歌没有显示任何最近的更新。仅在 2012 年之前发布的一些旧比较
采纳答案by Axel
XtraDB is InnoDB with several patches added. The patches themselves stem from Google, Facebook and others. XtraDB is maintained by Perconaand the heart of Percona Server.
XtraDB 是 InnoDB，添加了几个补丁。补丁本身来自谷歌、Facebook 和其他公司。XtraDB 由Percona维护，也是 Percona Server 的核心。
You may think of Percona as a distributor who collects, coordinates and maintains patches and distributes an enhanced version of the MySQL server.
您可能会将 Percona 视为收集、协调和维护补丁并分发 MySQL 服务器的增强版本的分发者。
A feature comparison between stock MySQL and Percona Server can be seen here:
可以在此处查看库存 MySQL 和 Percona Server 之间的功能比较：
http://www.percona.com/software/percona-server/feature-comparison
http://www.percona.com/software/percona-server/feature-comparison
The XtraDB engine is also shipped as default InnoDB implementation in MariaDB. MariaDB includes also stock InnoDB as pluggable storage engine, so you can chose.
XtraDB 引擎也作为MariaDB 中的默认 InnoDB 实现提供。MariaDB 还包括库存 InnoDB 作为可插拔存储引擎，因此您可以选择。
Benchmarks show that XtraDB scales better on massively parallel architectures and especially XtraDB is much better suited for write-heavy workload. The InnoDB engine in MySQL 5.6 will incorporate many of the features and advantages that have so far been available in XtraDB only.
基准测试表明 XtraDB 在大规模并行架构上的扩展性更好，尤其是 XtraDB 更适合写入繁重的工作负载。MySQL 5.6 中的 InnoDB 引擎将整合迄今为止仅在 XtraDB 中可用的许多特性和优势。
回答by alien
xtradb is a fork of innodb (mariadb also provides an original copy of innodb ), but patches with several improvements (among others also the Google and Facebook patches which never had been accepted into MySQL before)
xtradb 是 innodb 的一个分支（mariadb 还提供了 innodb 的原始副本），但是补丁有一些改进（其中还有以前从未被 MySQL 接受的 Google 和 Facebook 补丁）
