Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

How to improve performance of MySQL even with Handler Socket by 6-7 times through replication to the in-memory database Tarantool

How to improve performance of MySQL even with Handler Socket by 6-7 times through replication to the in-memory database Tarantool

 26 April - 5:00 PM - 5:25PM @ Room 210
Experience level: 
Intermediate
Duration: 
25 minutes conference
Tracks:
Business / Case Studies
Developer
Topics:
MySQL
NoSQL

Description

In my talk I will share with you our solution to the performance problem of MySQL. We were using MySQL and HandlerSocket over 5 years and at some point we decided to migrate from 5.6 to 5.7. The problem was that there was no HandlerSocket in 5.7. The other problem was that we could not use MySQL without HandlerSocket because MySQL alone didn’t stand our heavy workload (10-50K requests per second). We decided to solve it in a very unusual way that is to develop a replicator from MySQL to some in-memory database and use that database instead of HandlerSocket. Luckily, It didn’t result in a lot of reengineering of our existing applications because the HandlerSocket interface and interfaces of in-memory databases are pretty much similar. I will cover everything about our approach - how this replicator works, how it extracts data from the master and filter it, what limitations of the replicator are, what results we have on production and many more.

Speakers

Alexander Yakovlev's picture

Alexander Yakovlev

Technical Director, Wamba

Biography:

I have been working in IT industry for 15 years.

Share this talk