HandlerSocket

Handlersocket gives you direct access to InnoDB/XtraDB. It's included in MariaDB 5.3 as a ready-to use plugin.

The origin of the following is from the HandlerSocket's README file, Copyright © 2010 DeNA Co.,Ltd

What is handler socket

HandlerSocket is a NoSQL plugin for MySQL/MariaDB. It works as a daemon inside the mysqld process, accept tcp connections, and execute requests from clients. HandlerSocket does not support SQL queries. Instead, it supports simple CRUD operations on tables.

Because of the following reasons, HandlerSocket is much faster than the mysqld/libmysql pair in some circumstances:

• HandlerSocket manipulates data without parsing SQL, which causes less CPU usage.
• HandlerSocket reads many requests from clients and executes their requests in bulk, which causes less CPU and disk usage.
• HandlerSocket client/server protocol is more compact than the mysql/libmysql pair, which causes less network usage.

Libraries

The current version of HandlerSocket only works with GNU/Linux. The source archive of HandlerSocket includes a C++ and a Perl client libraries. Here is a list of client libraries for other languages:

• PHP
  • http://openpear.org/package/Net_HandlerSocket
  • http://github.com/tz-lom/HSPHP
  • http://code.google.com/p/php-handlersocket/
• Java
  • http://code.google.com/p/hs4j/
  • http://code.google.com/p/handlersocketforjava/
• Python
  • http://pypi.python.org/pypi/python-handler-socket
  • https://code.launchpad.net/~songofacandy/+junk/pyhandlersocket
• Ruby
  • https://github.com/winebarrel/ruby-handlersocket
  • https://github.com/miyucy/handlersocket
• JavaScript
  • https://github.com/koichik/node-handlersocket
• Scala
  • https://github.com/fujohnwang/hs2client

Links

• The home of HandlerSocket is here.
• The story of handlersocket can be found here.
• Comparison of HANDLER and HandlerSocket can be found here.