选择哪个MySQL分支/版本? [英] Which MySQL Fork/Version to Pick?

问题描述

众所周知，Sun收购了MySQL(后来Oracle收购了Sun)，在这些收购过程中，MySQL社区中存在许多FUD，从而产生了各种分叉.

As most of you know, Sun acquired MySQL (and later Oracle acquired Sun), and during these acquisitions, there were a lot of FUD in MySQL community which resulted in creation of various forks.

今天，我们有来自MySQL的MySQL，Percona(XtraDB)MySQL，OurDelta MySQL，MariaDB，Drizzle等.这将我们带到问题的根源.

Today we have MySQL from MySQL, Percona (XtraDB) MySQL, OurDelta MySQL, MariaDB, Drizzle to name a few. Which brings us to the source of the problem.

我们正在升级数据库(硬件/软件)，我想知道我应该使用哪一个分支.每个人都有自己的一套优点/缺点.我们目前正在8核计算机上使用MySQL/Linux上的MySQL5.0.x.我们的新硬件是具有 32核和32GB内存的怪兽，可以通过FC连接到快速的NetApp存储.

We are in the process of upgrading our databases (hardware/software) and I would like to know which one of the forks should I go with. Each has their own set of pros/cons. We are currently using MySQL 5.0.x from MySQL/Linux on an 8-core machine. Our new hardware is a monster with 32 cores and 32GB of memory connecting to a fast NetApp Storage via FC.

我想坚持使用MySQL中的MySQL，但我听到过恐怖的故事，说明MySQL 5.1在许多内核上的表现如何.我还听说MySQL 5.4在多核计算机上的性能更好，但这还没有做好生产准备.此外，我还听说过有关Percona构建的很多好处.

I would like to stick with MySQL from MySQL but I have heard horror stories on how badly MySQL 5.1 performs on many cores. I have also heard that MySQL 5.4 performs better on multi-core machines but that's still not production ready. In addition, I have also heard a lot of good things about Percona builds.

这是我到目前为止所知道的:

This is what I know so far:

MySQL 5.1中的MySQL 5.1 :可靠的选择，但在大型计算机上无法很好地扩展

MySQL 5.1 from MySQL: Reliable choice, but doesn't scale well on a big machine

Percona:可以很好地扩展，很好的支持公司.我没有太多经验

Percona: Scales well, good backing company. I don't have much experience with it

MariaDB:除了它是由原始MySQL开发人员(包括Monty)创建的以外，对其了解不多.

MariaDB: Don't know much about it besides that it was founded by Original MySQL developers (including Monty)

OurDelta:不太了解

毛毛雨:主要针对云计算进行了优化

Drizzle: Mostly optimized for cloud computing

我想知道这个问题的一般概念是什么.我应该使用哪个版本/版本?你们如何选择您的版本/版本?

I would like to know what's the general notion about this problem. Which build/version should I go with? How are you guys picking your builds/versions?

谢谢！

推荐答案

只需对此进行更新.我们选择和Percona一起去，我们再也不能快乐了. Percona的家伙肯定知道他们的知识并紧跟新技术.只需结帐 http://www.mysqlperformanceblog.com/一流的软件以及一流的人员和强大的支持，您不会出错.

Just an update on this. We chose to go with Percona and we can't be happier. Percona guys definitely know their stuff and keep up with the new technologies. Just checkout http://www.mysqlperformanceblog.com/ Top notch software plus top notch people and great support, you can't go wrong.

这篇关于选择哪个MySQL分支/版本?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！