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
25 minutes conference
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.
Technical Director, Wamba
I have been working in IT industry for 15 years.