坚持使用 MySQL 的 5 个理由(5 Reasons to Stick with MySQL)

数据库 William 347浏览 0评论

MySQL’s founder is encouraging people to steer away from his creation. Here’s why he’s wrong.

Schism between the worlds of open source and proprietary software is never going to go away as long as open source remains viable and competitive. Eventually, you have a meeting of both worlds. In the case of MySQL, it was when Sun Microsystems purchased the open source database for $1 billion in 2008, a significant multiple given MySQL was about a $50 million business at the time.

MySQL was the cause of the significant hang-up when Oracle tried to acquire Sun in 2009, as MySQL founder Michael “Monty” Widenius staunchly opposed the deal and complained to the European Commission. The whole $7.5 billion deal was held up almost a year because of this one product, which Oracle made major promises to support in return for getting the European Commission off its back.

MySQL的创始人正在鼓励人们远离他的创作。这些是说明他错了的原因。

在开源仍旧切实可行并具有竞争力的时代中,开源世界与商业软件的分裂将永远不会消失。最终,你可以同时看到两个世界。在MySQL这个例子中,就是2008年Sun Microsystems花费了10亿美元购买了开源数据库,一个重要得多的事情是它同时给了MySQL一个大约5千万美金的商机。

当2009年Oracle试图收购Sun的时候,MySQL带来了重要障碍,正如MySQL的创始人Michael “Monty” Widenius强烈反对这桩交易并向欧盟委员会抱怨的那样。全部75亿美元的交易持续了将近一年,就是因为这一个产品,它使得Oracle做出了郑重承诺要支持它来作为回应,以免欧盟委员会的纠缠。

Monty hasn’t given up his assaults on MySQL, even though he took the entire code base circa the Oracle acquisition, forked it, and made a new product called MariaDB. Monty is welcome to his own opinion, even if he has been on this charge now for four years and looks a little obsessed for it. He’s a successful, respected developer whose complaints can’t be merely dismissed as sour grapes. After all, he got $1 billion out of Sun. He can argue he’s fighting on principle.

Monty has his say, now we have ours. Here are five reasons why you should stick with the open source database. (And for balance, see Rikki Endsley’s article on the reasons you should leave MySQL behind.)

Mysql被Oracle收购后,Monty并没有放弃他对MySQL的攻击,他把整个代码库分支出一个新产品:MariaDBMonty很高兴这样做,尽管他已经在这个项目上投入了四年,痴迷于此。他是一个成功的受人尊敬的开发者,不乱发牢骚吐露酸水。之后,他从Sun离开时得到失意美元。他可以在为他的原则战斗。

Monty有他自己的说法,现在他拥有我们(的支持)。这里有五个你应该坚持开源数据库的原因。(为平衡期间,请看Rikki Endsley的文章:你应该离开MySQL背后的原因。)

1. There is more MySQL investment and innovation than ever before.

The conventional wisdom in the open-source community is that Oracle wanted MySQL so it could throttle the threat to its RDBMS business. This accusation would make sense if Microsoft was the accused firm, but not Oracle. Its flagship database is far and away more advanced and MySQL was at best going to nibble around the edges.

Since the acquisition, Oracle has increased the MySQL staff and given it a more mature engineering process. Rather than the typical open-source project with people scattered around the planet, engineering and planning is driven from Oracle.

In this time, one developer notes, the company has been making the code more modular. That means short-term work but long-term payback. In MySQL 5.6, they split one of the crucial locks in the MySQL Server, the LOCK_open, which could improve top performance by more than 100%.

Plus, the major storage engine for MySQL is InnoDB, and Oracle acquired InnoDB back in 2005. The InnoDB developers, also located within Oracle, work with the MySQL and Oracle database teams for even better integration.

1. MySQL上的投资和创新比以往更多了

开源社区的传统认识是Oracle需要MySQL是为了减少对于他们的关系型数据库(RDBMS)业务的威胁。 如果微软(Microsoft)是被谴责的对象,那么这种谴责是对的,但这里是Oracle。 它的旗舰级数据库显然要高级得多,而MySQL做到最好也只能沾到它的一点边。

自从收购以来,Oracle已经扩大了MySQL团队并且给予他们一个更加成熟的开发过程( engineering process)。相比于传统开源项目由分散在这个星球上的人们协作完成,MySQL的开发和计划更多地由Oracle驱动。

在这段时间里,正如一位开发者所说的那样,这家公司已经在使代码更加模块化(making the code more modular)。这意味着短期的工作,但却有着长期的回报。在MySQL 5.6中,他们拆分了一个MySQL Server中的重要的锁(lock),也就是说,锁开了(the LOCK_open),而这将带来超过一倍的顶级性能提升。 

更何况,MySQL的主存储引擎是InnoDB,而Oracle在2005年收购了InnoDB 。这些同样位于Oracle的InnoDB的开发者们,正在为了更好的集成性能和MySQL与Oracle的数据库团队共同工作。

2. MySQL products remain solid.

MariaDB and open-source advocates complain that new code in MySQL 5.5 doesn’t have test cases and that some of the enterprise features in version 5.5 are closed source. That is a matter of open source purity, of course, and one for any customer to take into consideration.

mysql-database

Still, when it came out in February, MySQL 5.6 was well-received as a solid, well-performing product with a number of new features. Oracle spent two years releasing Development Milestone Releases (DMR) to the MySQL Community for testing and feedback.

2. MySQL产品依然稳固.

MariaDB和开源倡导者抱怨说:新的代码在MySQL 5.5没有测试用例,一些企业5.5内的特性是闭源的。这是一个开源纯度的问题,当然,一个所有用户都关心的事情。

mysql-database

而且,自二月份新版本发布以来,MySQL5.6被认为是一个坚实的、性能良好的产品,包含一些新的特性功能。Oracle花了两年时间将这个里程碑版本放到MySQL社区中测试及获取反馈。

MySQL 5.6 went from 4 CPU threads in prior versions to 64 CPU threads, nearly tripled the number of concurrent connections from the prior version, and saw a four-fold improvement in read speed. There are many more improvements that would take too long to list.

Robert Hodges, president of the database clustering and replication firm, said he has no doubt of the viability of MySQL and has yet to meet a manager who fears MySQL will be ruined by Oracle. The bottom line is that Oracle is growing MySQL into an enterprise-class DBMS.

MySQL 5.6从之前的4个CPU线程到现在的64 CPU线程,并发连接的数量较之前几乎增加了两倍,体现出来的是读速度4倍的提升,除此之外还有很多的改进需要花段时间来列出。

数据库集群和复制组的主席Robert Hodges说:他对MySQL的活力毫不质疑,他甚至还遇到一个担忧Mysql会被 Oracle毁掉的经理人,现在的情况是 Oracle正在将MySQL变成一个企业级的数据库管理系统。

3. MySQL is designed with a focus on the Web, Cloud, and Big Data

Oracle was not deaf to the trends in computing and put emphasis on the Web, cloud computing, and big data projects. The focus was on both MySQL and MySQL cluster to provide improvements in scale-up and scale-out performance, high availability, self-healing and data integrity, provisioning, monitoring and resource management, developer agility, and security.

To support cloud services, MySQL replication has been greatly enhanced to include a new feature, Global Transaction Identifiers (GTIDs). GTIDs make it simple to track and compare replication progress between the master and slave servers. This makes it easier to recover from failures while offering flexibility in the provisioning and on-going management of multi-tier replication.

3. MySQL被设计着眼于Web开发、云计算及大数据

Oracle在计算发展趋势上没有瞎,并把重点放在网络,云计算和大数据等项目上。侧重点在MySQL和MySQL cluster上,旨在提供伸缩扩展的高性能、高可用性、自愈性和数据的完整性、配置、监控及资源管理、开发的敏捷性和安全性等方面的改进。

为了支持云服务,MySQL通过GTIDs(全球的的交易标识符)这个新特性使得复制功能大大增强。 GTIDs使主从服务器之间的复制进度跟踪和变得简单,可以更容易的从故障中恢复,同时提供灵活配置和多层复写的持续管理。

In April 2013,  Oracle announced the MySQL Applier for Hadoop. The Applier enables the replication of events from MySQL to Hadoop / Hive / HDFS as they happen and complements existing batch-based Apache Sqoop connectivity.

One of the first firms to embrace MySQL in a Big Data environment is Nokia, which consists of a centralized, petabyte-scale Hadoop cluster that is interconnected with a 100TB Teradata enterprise data warehouse (EDW), numerous Oracle and MySQL data marts, and visualization technologies that allow Nokia’s 60,000+ users around the world tap into the massive data store. And MariaDB? Good luck finding anything related to Big Data there.

2013四月,Oracle宣布发布Hadoop的MySQL插件。该插件实现了MySQL到Hadoop/Hive/HDFS间事件发生时的复制,补充了现有的基于批处理的Apache Sqoop连接。

诺基亚是在大数据环境拥抱MySQL的第一个公司,它运维着一个集中的PB级别的Hadoop集群,这个集群和规模100TB的Teradata企业级数据仓库关联(EDW)关联着,大量的Oracle和MySQL数据节点及可视化技术使诺基亚世界各地60000+的用户使用大规模数据存储。而MariaDB呢,好像找不到大数据相关的任何事情。

4. MySQL Enterprise

MySQL Enterprise was introduced before the Oracle purchase, but Oracle has significantly improved the product. Version 5.6 added High Availability features like Replication, Oracle VM Templates for MySQL, DRBD, Oracle Solaris Clustering, and Windows Failover Clustering for MySQL. It also introduced Enterprise Audit to perform policy-based auditing compliance on new and existing applications.

There’s also the Enterprise Monitor, which continuously monitors your database and advises you of best practices to implement. It also offers Query Analyzer to monitor application performance and Workbench, which offers data modeling, SQL development, and comprehensive administration tools for server configuration and user administration.

5. 现在较之前有更多的Mysql项目

在MySQL AB被收购之前,它在在25个国家有400名员工,其中有70%在家里办公。是否在一定要在一个地方工作一直存在争议。雅虎首席执行官Marissa Mayer说:她结束了在雅虎远程工作的允许,做事情需要合作,即同一建筑物里。

一位Oracle的MySQL架构师在自己的博客上说,Oracle已经变了,整个团队协同工作,尽管有些在红木海岸的巨塔、加利福尼亚或其他的地方,但都在为MySQL特定的项目工作。整个项目组在集群上工作,其中一个工作组负责可管理性,一个优化团队致力于数据库算法的优化,另一个团队解决复制(至关重要云、大数据等),整个团队使项目更具扩展性。

None of the anti-MySQL arguments are against the product’s performance. Most of Monty’s arguments stem from open source purity, and he has the right to make that complaint. But MySQL was a $75 million company when Sun bought it. Oracle is a $37 billion company. It knows a few things about professional software development and it’s going to do things its own way. It has turned over the basic MySQL code to the GPL, but its own extensions, like Enterprise Edition, are not obliged to be open source.

Monty more or less held up the Sun acquisition for months with his protests to the European Commission. Now he’s throwing stones from the outside. There comes a point when an advocate can become a nuisance and his actions can backfire.

See also:

反对MySQL的观点中没有提到产品的性能。Monty的大多数观点来源于开源的纯度,他有权利去抱怨。但是当Sun收购MySQL的时候,它是一家身价为7.5亿美元的公司。Oracle是3.7亿美元的公司。它不擅长专业软件开发,做起事情来有自己的方法。MySQL公司已经移交GPL一份基本版的MySQL代码,但是它的拓展版本,比如企业版,并没有义务开源。

几个月里,Monty或多或少地反对Sun的收购品,并向欧洲委员会提出抗议。当事情发展到一定程度,提倡者会变成滋事者,他的行为也就适得其反了。

相关阅读:


via:oschina

转载请注明:AspxHtml学习分享网 » 坚持使用 MySQL 的 5 个理由(5 Reasons to Stick with MySQL)

发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址