Just over a month ago, the WebscaleSQL collaboration project was launched. This project aims to create a community-developed branch of the popular MySQL DBMS that incorporates features to make large-scale deployments easier. As many of our clients run large clusters of MySQL on commodity hardware (as a means to reduce costs and improve scalability) the WebScaleSQL project naturally drew our attention.
The project is currently developed by a small collaboration of engineers from Facebook, Google, Twitter, and LinkedIn. Certainly no strangers to scalability challenges, the developers from these web giants all face similar challenges and must work continuously to improve performance and scalability of their MySQL deployments to remain competitive. Aimed at minimizing the duplication of effort across these engineering teams, WebScaleSQL’s development is run as an open collaboration between these major contributors. Contributions aren’t limited to major companies, however, and participation from outside engineers is encouraged.
Despite having only been around a few weeks, the WebScaleSQL project boasts some significant improvements overs its upstream parent (Oracle’s MySQL ver 5.6). These advances include an automated testing framework, a stress testing suite, query optimizations and host of other changes that promise to improve the performance, testing, and deployment of large-scale DBs.
As WebScaleSQL matures, we’ll continue to track its development and report on our clients’ experiences (both good and bad) working with this new “scale friendly” branch of MySQL.
WebScaleSQL source is currently hosted on GitHub (https://github.com/webscalesql/webscalesql-5.6) and released under version 2 of the GNU public license.