MySQL+HandlerSocket=NoSQL

Developing Applications
4 December 13:10 - 14:00 @ Sentosa 5-8

We've been using HandlerSocket in our infrastructure for 2 years here at Badoo. Badoo has extensive experience running HS in production. More and more teams in our company use HandlerSocket for their projects.

We're currently using HandlerSocket as a Memcached replacement in some cases, as a search engine in some other cases and as a primary key-value storage for mobile & desktop applications. Our HS installation has more than 30 servers serving max. ~ 8000 RPS per server. I have written a custom HS client library for PHP including a couple of tricks and optimizations I'm going to show you.

I'm going to speak on:

  1. Brief HS introduction.
  2. What HS is and what it is not. The benefits it provides.
  3. HS internals.
  4. Common use cases, a detailed description of one or two use cases @ Badoo with figures.
  5. Performance issues, speeding it up:
    1. Sharding
    2. HS with Percona Server
    3. Using HS with persistent connections. Pros and cons, problems, solutions.
    4. Tips & tricks: pipelining, lazy open_index, etc.
  6. Useful links: HS client libraries, articles, Percona Server Handlersocket page.

This will not be an introductory talk but a summary of my practical experience including graphs, numbers and pitfalls.

Speakers

Sergey Averin
Desktop Apps department lead, Badoo
Speaker Biography: 
I work at Badoo, mostly coding server-side in PHP. Studied electronics design in Moscow Aviation University. I develop Badoo Desktop app for Win/Mac with > 2.5 million users monthly. Participated in developing of habrahabr.ru, autokadabra.ru, dirty.ru, trendclub.ru. I make 3 to 6 conference talks a year, primarily in Moscow.