What's new in AliSQL - Alibaba's branch of MySQL
This session introduces Alibaba Group's branch of the Oracle MySQL —— AliSQL. In this session, we will talk about how AliSQL could support 140,000 order creation per second, and supported more than thousands of stock deductions per second for single hot SKU in 2015 Alibaba Singles's Day shopping festival (China's version of "Cyber Monday"). Our goal in launching AliSQL is to meet the Alibaba business's needs for high concurrency, high performance, high scalable and high security. We do various improvements in performance and functionality based on MySQL to approach this goal. The improvements including: - Optimized Thread Pool for High Concurrency - Hot SKU patch and extended SQL syntax for inventory deductions of single hot SKU - Business oriented Optimizer - SQL plan binding for performance stability - Others: optimized transaction commit, table-level parallelism replication, SQL firewall, recycle bin, etc. will be presented and discussed.
Database Kernel Expert, Alibaba Group
I am a database developer at Alibaba Group. As the main developer of AliSQL (Alibaba Group's branch of the MySQL), my primary responsibilities is to make AliSQL faster, safer and more scalable by adding new features, eliminating performance bottlenecks and fixing bugs. Before joining Alibaba, I was a member of MySQL team at Baidu Inc.