Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

What's new in AliSQL - Alibaba's branch of MySQL

What's new in AliSQL - Alibaba's branch of MySQL

 20 April 01:00 PM - 01:50 PM @ Ballroom C
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Scalability/Performance
Topics:
MySQL
InnoDB
Optimization

Description

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.

Speakers

ying qiang zhang's picture

ying qiang zhang

Database Kernel Expert, Alibaba Group

Biography:

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.

Share this talk


Slides