Facebook, other Web giants unite to scale MySQL

WebScaleSQL hopes to equip the open source MySQL database with high-performance features

Facebook has joined a number of other Internet services heavyweights, such as Google and LinkedIn, to better equip the MySQL relational database management system for large- scale work.

The new group, called WebScaleSQL, includes engineers from Facebook, Google, LinkedIn, and Twitter.

"Our goal in launching WebScaleSQL is to enable the scale-oriented members of the MySQL community to work more closely together in order to prioritize the aspects that are most important to us," wrote Facebook software engineer Steaphan Greene, in a blog post announcing the collaboration.

"We aim to create a more integrated system of knowledge-sharing to help companies leverage the great features already found in MySQL 5.6, while building and adding more features that are specific to deployments in large-scale environments," Greene wrote.

Facebook has one of the largest deployments of the open source MySQL, if not the single largest deployment. The database system houses the data of Facebook's 1.23 billion users.

Many other social networking companies have eschewed the use of relational databases such as MySQL altogether in favor of NoSQL databases such as Cassandra or Riak, which were built from scratch to host extremely large data sets spread across multiple servers.

Facebook instead uses MySQL along with the Memcached caching system to replicate the data around the globe across many servers.

WebScaleSQL is not alone in its effort to boost MySQL for low-latency global Web scale work.

Percona offers a version of MySQL for high performance use, called Percona Server.

The MariaDB and Drizzle forks of MySQL were created with scalability improvements in mind as well.

Even the company managing the MySQL code, Oracle, outfitted MySQL with a handler that makes quick Memcached-like calls directly to the data, rather than going through the database engine itself.

Oracle also offers a separate version of MySQL, called MySQL Cluster,for use on server clusters, though it differs from MySQL considerably and is not widely used outside of telecommunications and a few other specific industries.

The WebScaleSQL project insists that the code base for WebScaleSQL is not a fork of MySQL, a separate version incompatible with MySQL itself, but rather a branch optimized for large-scale usage.

The work is based on the latest production-ready version of MySQL, version 5.6. The group hopes Oracle will accept some of the changes into the next version of MySQL, version 5.7.

The project has already produced a number of tools to help in its cause. It has developed a set of stress tests and an automated framework for creating and reviewing code changes.

Several projects are already under way.

One project is an asynchronous MySQL client that won't block additional requests when it is currently handling one. Facebook created this fix and it is currently being reviewed by other WebScaleSQL engineers.

The group is also reviewing other Facebook MySQL augmentations such as a read-ahead mechanism that can speed full table scans by a factor of 10.

Joab Jackson covers enterprise software and general technology breaking news for The IDG News Service. Follow Joab on Twitter at @Joab_Jackson. Joab's e-mail address is Joab_Jackson@idg.com

Join the Good Gear Guide newsletter!

Error: Please check your email address.

Tags open sourcedatabasesapplicationsGooglesoftwareOracleFacebook

Our Back to Business guide highlights the best products for you to boost your productivity at home, on the road, at the office, or in the classroom.

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Joab Jackson

IDG News Service
Show Comments

Most Popular Reviews

Latest News Articles

Resources

PCW Evaluation Team

Azadeh Williams

HP OfficeJet Pro 8730

A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.

Andrew Grant

HP OfficeJet Pro 8730

I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.

Ed Dawson

HP OfficeJet Pro 8730

As a freelance writer who is always on the go, I like my technology to be both efficient and effective so I can do my job well. The HP OfficeJet Pro 8730 Inkjet Printer ticks all the boxes in terms of form factor, performance and user interface.

Michael Hargreaves

Windows 10 for Business / Dell XPS 13

I’d happily recommend this touchscreen laptop and Windows 10 as a great way to get serious work done at a desk or on the road.

Aysha Strobbe

Windows 10 / HP Spectre x360

Ultimately, I think the Windows 10 environment is excellent for me as it caters for so many different uses. The inclusion of the Xbox app is also great for when you need some downtime too!

Mark Escubio

Windows 10 / Lenovo Yoga 910

For me, the Xbox Play Anywhere is a great new feature as it allows you to play your current Xbox games with higher resolutions and better graphics without forking out extra cash for another copy. Although available titles are still scarce, but I’m sure it will grow in time.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?