Welcome to another post in the series of Percona Live featured session blogs! In these blogs, we’ll highlight some of the session speakers that will be at this year’s Percona Live conference. We’ll also discuss how these sessions can help you improve your database environment. Make sure to read to the end to get a special Percona Live 2017 registration bonus!
In this Percona Live featured session, we’ll meet Wei Hu, Staff Engineer at Alibaba. His session (along with co-presenter Dengcheng He, Senior Staff Engineer at Alibaba) is AliSQL: Breakthrough for the Future. AliSQL is a MySQL branch maintained by the Alibaba Database Team. AliSQL has made many improvements over the last year in its efforts to make it a high-performance, high-availability and low-maintenance storage engine option.
I had a chance to speak with Wei about AliSQL:
Wei: I worked on an RDBMS storage engine project in graduate school, where I spent years studying database theory, and experienced the charm of database systems.
Before joining the Alibaba Group, I worked for Netease. I developed another storage engine called TNT (Transactional/Non-
Percona: Your talk is called AliSQL: Breakthrough for the Future. What is AliSQL, and what workloads could benefit from it?
Wei: Last year, we joined Percona Live for the very first time. We brought the world AliSQL. AliSQL is a fork of MySQL(based on the community version) tailored for Alibaba’s business characteristics and requirements. AliSQL is focused on extreme performance and data consistency. As many people know, AliSQL supports the world’s largest throughput of OLTP system. This has been demonstrated in the Singles’ Day shopping festival. Compared to the community version, AliSQL can offer high throughput, high concurrency and low latency at the same time.
Last Percona Live, We share many of the improvements we made, including Column Compression, Double Read Buffer, SQL Firewall and so on. This year we’re bringing the world a brand new AliSQL.
Firstly, we developed the new “Hot SKU” feature. We were not satisfied with AliSQL’s previous performance (5,000 single key updates per second). We developed a new Group update algorithm to improve throughputs to 100,000 single key updates per second. Panic buying is no longer an annoying problem in our e-commerce scenario.
Secondly, based on the InnoDB memcache plugin, AliSQL developed X-KV, a new powerful Key-Value interface. X-KV implements a new protocol with more operation and data type support. Our customers used X-KV as a memory cache, and save the use of hundreds of machines in a production environment.
In addition, based on AliSQL we have developed X-Cluster. X-Cluster uses X-Paxos (Alibaba’s consensus library) to replicate data among instances. It supports high availability and high reliability. X-Cluster has better performance compared to Group Replication. Our benchmarking shows that X-Cluster has five times the throughput of Group Replication (for MySQL 5.7.17) in our high latency network. Furthermore, X-Cluster has many customization features for Alibaba’s production environment, such as leader election priority, LogType instance (low cost), etc.
Percona: How does the latest version of AliSQL make DBAs’ work easier?
Wei: With new “Hot SKU” feature, DBAs do not need to scale out instances for panic buying. With AliSQL X-KV, DBAs do not need to care about schema changes anymore. With AliSQL X-Cluster, DBAs don’t need to worry about data inconsistency problems. All the data transfer systems for AliSQL can use X-Paxos SDK to communicate with X-Cluster. DBAs do not need to set the log position. All is handled by X-Cluster itself.
Percona: What do you want attendees to take away from your session? Why should they attend?
Wei: In my session, I will share the AliSQL HOT SKU, X-KV and X-Cluster internals. Other developers can gain insights and spark new ideas from the talk.
Percona: What are you most looking forward to at Percona Live 2017?
Wei: I am looking forward to chatting with MySQL developers from all over the world, and making more friends.
Register for Percona Live Data Performance Conference 2017, and see Wei and Dengcheng present AliSQL: Breakthrough for the Future. Use the code FeaturedTalk and receive $100 off the current registration price!
Percona Live Data Performance Conference 2017 is the premier open source event for the data performance ecosystem. It is the place to be for the open source community, as well as businesses that thrive in the MySQL, NoSQL, cloud, big data and Internet of Things (IoT) marketplaces. Attendees include DBAs, sysadmins, developers, architects, CTOs, CEOs, and vendors from around the world.
The Percona Live Data Performance Conference will be April 24-27, 2017 at the Hyatt Regency Santa Clara and the Santa Clara Convention Center.