WebScaleSQL

WebScaleSQL is a database technology specifically designed for large-scale deployments. It is developed by a collaboration of engineers from various companies, including Alibaba, Facebook, Google, LinkedIn, and Twitter. According to the WebScaleSQL Contributors, the product aims to address the challenges faced by technology, e-commerce, social media, online service providers, and data-intensive businesses in running MySQL at scale. With a focus on performance and scalability, WebScaleSQL offers a tailored solution for companies operating at a significant scale.

Key Features

Automated Test Framework: WebScaleSQL includes an automated framework that runs and publishes the results of MySQL's built-in test system (mtr) for each proposed change. According to the WebScaleSQL Contributors, this framework helps ensure the stability and reliability of the database technology.

New Suite of Stress Tests: WebScaleSQL has developed a full new suite of stress tests, along with a prototype automated performance testing system. These stress tests are designed to evaluate the performance and robustness of the database in large-scale environments, according to the WebScaleSQL Contributors.

Code Changes and Structure Improvements: WebScaleSQL has made several changes to the tests and structure of existing code in MySQL. These changes aim to avoid conflicts and failures caused by code changes, making it easier to work on the codebase and contribute to the project, as stated by the WebScaleSQL Contributors.

Performance Improvements: WebScaleSQL includes various performance enhancements, such as buffer pool flushing enhancements, optimizations for specific types of queries, support for NUMA interleave policy, and more. The WebScaleSQL Contributors claim that these improvements enhance the overall performance of MySQL in large-scale deployments.

New Features for Web Scale Operations: WebScaleSQL introduces new features that make operating the database at true web scale easier. These features include super_read_only, which allows read-only access to the database, and the ability to specify sub-second client timeouts, improving the responsiveness of the system, according to the WebScaleSQL Contributors.