Facebook Announces WebScaleSQL Upgrade For MySQL - InformationWeek
Data Management // Big Data Analytics
04:03 PM
Connect Directly

Facebook Announces WebScaleSQL Upgrade For MySQL

Partners Facebook, Google, LinkedIn, and Twitter tweak WebScaleSQL branch of MySQL to fix bugs, improve speed, and run "at scale."

 Apple's Next Chapter: 10 Key Issues
Apple's Next Chapter: 10 Key Issues
(Click image for larger view and slideshow.)

The WebScaleSQL branch of MySQL built by Facebook, Google, LinkedIn, and Twitter is about to get an upgrade. Facebook broke the news on Monday while announcing it's taking a memcached tool open source and spearheading a new TODO group aimed at promoting open-source development.

Introduced to the world in March, WebScaleSQL is an open-source, Web-scale branch on top of Oracle's publicly available MySQL Community Edition. The brand was developed by partners Facebook, Google, LinkedIn, and Twitter, all of which are big users of MySQL and all of which had been struggling with scaling the open-source database for their massive, Web-scale needs.

WebScaleSQL is distributed on Github as a set of patches on top of Oracle's publicly available MySQL Community release. Features include a super read-only tool and the ability to specify sub-second client timeouts, buffer pool flushing improvements, optimizations to certain query types, and support for non-uniform memory architecture (NUMA) interleave policies.

[Want more on WebScaleSQL? Read Facebook Debuts Web-Scale Variant Of MySQL.]

The WebScaleSQL release to be available later this week will upgrade an existing Global Transaction ID feature in MySQL 5.6 that isn't living up to Web-scale needs for replication and high availability at scale, according to Jay Parikh, VP of infrastructure engineering at Facebook.

"Global Transaction ID is a base feature, but we found, as we were trying to run it at Facebook, that there were several things that weren't worked out in terms of being able to run it at the kind of scale that the [WebScaleSQL partners] run at," said Parikh. "We've worked on bug fixes, making it faster, and making it more operationally sane to run at scale."

Facebook also announced that it is taking a memcached tool it developed called mcrouter into open source. Mcrouter is a memcached protocol router that Facebook uses to handle "all traffic to, from, and between thousands of cache servers across dozens of clusters distributed in Facebook data centers around the world," according to a statement from the company. The tool is able to handle nearly 5 billion requests per second at peak loads, according to Facebook.

Facebook's new Talk Open, Develop Open (TODO) group boasts high-profile supporters.
Facebook's new Talk Open, Develop Open (TODO) group boasts high-profile supporters.

In another announcement at this week's @Scale 2014 conference in San Francisco, Parikh announced the formation of a Talk Open, Develop Open (TODO) group being launched to address the challenges of consuming and running open-source software. The group, which will gather online at todogroup.org, is being launched with support from companies including Box, Dropbox, Facebook, Google, GitHub, Khan Academy, Square, Stripe, Twitter, and Walmart Labs.

"We're working on how we can make open source better," said Parikh. "We want to raise the bar in terms of how we can improve the quality and types of open-source projects there are. We want to make it easier to consume open source, and if you want to do open-source work, but you don't know where to get started, the TODO Group is going to help you."

In its ninth year, Interop New York (Sept. 29 to Oct. 3) is the premier event for the Northeast IT market. Strongly represented vertical industries include financial services, government, and education. Join more than 5,000 attendees to learn about IT leadership, cloud, collaboration, infrastructure, mobility, risk management and security, and SDN, as well as explore 125 exhibitors' offerings. Register with Discount Code MPIWK to save $200 off Total Access & Conference Passes.

Doug Henschen is Executive Editor of InformationWeek, where he covers the intersection of enterprise applications with information management, business intelligence, big data and analytics. He previously served as editor in chief of Intelligent Enterprise, editor in chief of ... View Full Bio

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
User Rank: Ninja
9/26/2014 | 12:07:45 AM
Facebook Announces WebScaleSQL Upgrade For MySQL
Now, it looks like Facebook, Google, Twitter and LinkedIn have realized they need to collaborate for them to overcome the challenge of utilizing MySQl. They are all extensive users of MySQL and they all face the same challenges when operating MySQL at a scale. WebScaleSQL is certainly going to endow the partners with a database technology customized for their uses and enhance performance. 
Charlie Babcock
Charlie Babcock,
User Rank: Author
9/15/2014 | 7:54:28 PM
WebscaleSQL is the MySQL of the future?
WebscaleSQL looks like its leapt scalabiltiy barriers and become the MySQL version of the future. Interesting that it it's a set of modules sitting on top of Oracle MySQL. It's a set of enhancements, not a fork. And it's probably a goal to keep it that way, which may or may not be possible.
D. Henschen
D. Henschen,
User Rank: Author
9/15/2014 | 5:22:55 PM
Whose logo is that, anyway?
The smushed bird in the picture is the Twitter logo while the stripe represents, you guessed it, Stripe, the payments vendor.
TaylorMade IT Spin-Off Taps Cloud Database
Jessica Davis, Senior Editor, Enterprise Apps,  2/15/2019
2019: The Year IT Makes a Comeback
Guest Commentary, Guest Commentary,  2/18/2019
Myth or Matter: Is There a DevOps Talent Shortage?
Joao-Pierre S. Ruth, Senior Writer,  2/14/2019
White Papers
Register for InformationWeek Newsletters
Current Issue
Security and Privacy vs. Innovation: The Great Balancing Act
This InformationWeek IT Trend Report will help you better understand and address the growing challenge of balancing the need for innovation with the real-world threats and regulations.
Flash Poll