Most of high scale web applications use MySQL + memcached. Many of them use also NoSQL like TokyoCabinet/Tyrant. In some cases people have dropped MySQL and have shifted to NoSQL. One of the biggest reasons for such a movement is that it is said that NoSQL performs better than MySQL for simple access patterns such as primary key lookups. Most of queries from web applications are simple so this seems like a reasonable decision. Like many other high scale web sites, we at DeNA had similar issues for years. But we reached a different conclusion. We developed HandlerSocket Plugin – a MySQL plugin that speaks NoSQL network protocols. HandlerSocket has the following features/advantages.
In our benchmarks, we could get 750,000+ read qps on a commodity MySQL/InnoDB 5.1 server from remote web clients. We also have got excellent performance on production environments. In this session, we’d like to share our experiences. We’ll talk about what HandlerSocket can do, how it performs with reads and writes, where and how we use in production, etc.
Yoshinori Matsunobu is a database and infrastructure architect at DeNA (http://www.dena.jp/en/index.html), living in Tokyo. Yoshinori’s primary responsibility at DeNA is to make our database infrastructure more reliable, faster and more scalable. Before joining DeNA, Yoshinori worked at MySQL/Sun/Oracle as a lead consultant in APAC for four years. Yoshinori has written eight MySQL related technical books so far and has published technical articles about MySQL, Linux, and Java for a monthly database magazine since 2004.
Kazuho Oku is a software engineer living in Japan. He is the original developer of:
He is currently working for Cybozu (Japan’s largest groupware vendor) as a researcher of platform software and services. Awarded as TR100 by Technology Review in 2002, “Super Creator” by IPA, Japan in 2005.
Comments on this page are now closed.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at email@example.com
For media partnerships, contact mediapartners@ oreilly.com
For media-related inquiries, contact Maureen Jennings at firstname.lastname@example.org
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).
View a complete list of O'Reilly MySQL Conference Contacts