丢弃 MySQL 的 5 个理由 已翻译 100%

oschina 投递于 2013/07/11 05:27 (共 7 段, 翻译完成于 07-13)
阅读 2348
收藏 5
0
加载中

MySQL is still the most popular open-source database, but it has been losing fans over the years – for good reason. We look at five practical motivations to dump the MySQL database.

Back in 2008, MySQL was rapidly growing in popularity when Sun Microsystems bought MySQL AB for approximately a billion bucks. The following year, Oracle scooped up Sun, and MySQL was part of the deal. MySQL users and developers started questioning the fate of the open-source database, and many of them began looking for alternatives.

Flash forward to 2013: Oracle didn’t kill off its former competitor, and MySQL remains the most popular open source database. Still, MySQL’s popularity is on the decline; as it loses its luster, viable database alternatives have started to shine. Let’s look at five good reasons not to use the former open source database standard, MySQL. (To see the other side of the argument, read Andy Patrizio’s article on the 5 reasons to stick with MySQL. Then make your own decision, and share it with us in the comments.)

已有 1 人翻译此段
我来翻译

1. MySQL is not as mature as other relational database management systems.

MySQL did not start out as an RDBMS, but later changed direction to encompass more functionality. Older, more mature relational database management systems are still considered more feature-rich than MySQL. If you want a feature-rich RDBMS, you might check out PostgreSQL or closed source options, such as Oracle or Microsoft SQL Server.

PostgreSQL contributor Selena Deckelmann says that Postgres is seen as the right choice for new projects among Web developers who need a relational database. “With the JSON data type and PLV8, Postgres may become the default choice for NoSQL as well,” she says.

已有 1 人翻译此段
我来翻译

2. MySQL is open source… but only sorta

Technically, MySQL is an open-source database, but in practice, it no longer feels like it. Under Oracle’s umbrella, MySQL now has proprietary, closed-source modules. “MySQL remains alive on paper but Oracle’s foot dragging on development and refusal to release test cases for bugs and security patches for MySQL has reinforced its control over the code and sent hordes of open source developers to greener pastures,” Paula Rooney explains in her ZDNet article, Is it time for Oracle to donate MySQL to Apache?

MariaDB

It isn’t like you don’t have other open-source alternatives. MariaDB, a MySQL fork, remains “truly open source.” SkySQL, a MariaDB developer that merged with Monty Program Ab (MariaDB’s parent company) earlier this year, explains, “All code in MariaDB is released under GPL, LPGL or BSD. MariaDB does not have closed source modules like those you can find in MySQL Enterprise Edition. In fact, all the closed source features in MySQL 5.5 Enterprise Edition are found in the MariaDB open source version.”

已有 1 人翻译此段
我来翻译

3. MySQL’s performance doesn’t scale as well as its competitors

The MariaDB blog offers detailed benchmark results for recent MySQL vs. MariaDB releases, and, although the results were close, MariaDB came out ahead.

PostgreSQL contributor Selena Deckelmann says that Heroku Postgres makes Postgres more attractive for several reasons, including scaling. “They have arguably the largest hosted environment for Postgres, automatically handle scaling for your apps, and are supporting cool add-ons that make it easy to try out features before you figure out the DevOps situation locally,” she explains, adding, “They just announced support for PLV8, which allows you to run JavaScript in the database and take better advantage of the JSON datatype available in 9.2 and higher.”

已有 1 人翻译此段
我来翻译

4. MySQL is Oracle-owned instead of community driven

MySQL hasn’t changed direction dramatically since it was acquired by Oracle, but Oracle still owns it, which makes some developers nervous. “And, probably worst of all, it’s impossible for the community to work with the MySQL developers at Oracle,” Michael “Monty” Widenius, founder of MySQL and MariaDB, says.

Widenius notes that Oracle does not accept patches or provide a public roadmap. “There is no way to discuss with MySQL developers how to implement things or how the current code works,” he says. If an open source, community developed database matters to you, Widenius recommend MariaDB (duh!) because it is built on top of MySQL and offers more features, speed, and stability, with fewer security issues.

已有 1 人翻译此段
我来翻译

5. The list of big names jumping ship is growing fast

At its June 2013 summit in Boston, Red Hat announced that it was breaking up with MySQL. Instead, Red Hat Enterprise Linux (RHEL) will ship with MariaDB. Fedora already announced that it would move from MySQL to the MariaDB fork with Fedora 19. Slackware Linux announced its move from MySQL to MariaDB in March 2013, and openSUSE made a similar announcement in January 2013.

It isn’t just the Linux distributions. In April 2013, the Wikimedia Foundation announced that Wikipedia, the world’s seventh most popular website, would be adopting MariaDB. In the announcement, Wikimedia Foundation Site Architect Asher Feldman explained that MariaDB’s optimizer enhancements and Percona’s XtraDB feature set were compelling reasons for the change. “Equally important, as supporters of the free culture movement, the Wikimedia Foundation strongly prefers free software projects; that includes a preference for projects without bifurcated code bases between differently licensed free and enterprise editions,” he added. “We welcome and support the MariaDB Foundation as a not-for-profit steward of the free and open MySQL related database community.” As technology journalist Steven J. Vaughan-Nichols (and contributor here at SmartBear) noted at the end of 2012, no matter how you feel about Oracle or open-source vs. proprietary software, “MariaDB’s better performance at one of the world’s busiest Web sites is going to draw attention from anyone running serious Linux, Apache, MySQL, PHP/Python/Perl (LAMP) software stacks.”

So what do these big data, tech-savvy companies know that loyal MySQL users don’t? MySQL is no longer the only big fish in a small pond of database solutions. Instead, MySQL is up against its own Oracle-free, truly open source offspring, MariaDB, the increasingly popular PostgreSQL RDBMS, and a growing NoSQL market. If you haven’t dumped MySQL yet, there are plenty of reasons to reconsider.

已有 1 人翻译此段
我来翻译

About the author

Rikki Endsley writes for a variety of tech publications, is the community manager for USENIX, and is the managing editor of the association’s bi-monthly publication, ;login:. In the past, Rikki worked as the editor in chief of Ubuntu User magazine, associate publisher of Linux Pro Magazine, and managing editor of Sys Admin magazine. Follow her on Twitter at @rikkiends or visit rikkiendsley.com.

See also:

已有 1 人翻译此段
我来翻译
本文中的所有译文仅用于学习和交流目的,转载请务必注明文章译者、出处、和本文链接。
我们的翻译工作遵照 CC 协议,如果我们的工作有侵犯到您的权益,请及时联系我们。
加载中

评论(2)

赵云30
赵云30
一个所谓的科技撰稿人,社区经理写出的文章及各种理由难以令人信服,各种观点更像是东拼西凑抄来的。我甚至怀疑此人是否真的用过MySQL PostgreSQL
赵亮-碧海情天
赵亮-碧海情天
一切都是那么自然而然。唯一有点让人感觉不自然的就是ORACLE,但其实大树老了必然生虫腐朽,这也是自然。
返回顶部
顶部
返回顶部
顶部