id:garage-kid@76whizkidz のライフログ・ブログ!

Percona Server Supports HandlerSocket!


For who loves MySQL,

Percona announced the release of Percona Server 5.1.52-12.3, 2Days ago.

In this release, they support HandlerSocket!

According to their blog post, Percona Server now both SQL and NOSQL - MySQL Performance Blog, they said, "It handles really high load. In my tests using 2 dedicated web servers ( using perl clients) I reached 200,000 req/sec and the clients were real bottleneck, while Percona Server was busy only 5-7%. I did not have more clients in my lab to put more load, but I have no doubts we have handle 1,000,000 req/sec with 5 separate web applications. The tests were done with Percona Server installed on Cisco UCS C250 server with 12cores/24threads and 380GB of RAM .".

It means using Percona Server (XtraDB), we can use MySQL like a NOSQL!

I think only using Original Oracle's MySQL is terrible.
Because we can't get enough community's contributions from using only Original Oracle's MySQL.

Sometimes, if we can obviously gain many benefits, we should try to use these kind of MySQL forked products (XtraDB, MariaDB and so on).


If you want to know more about HandlerSocket, read this Yoshinori Matsunobu(DeNA)’s blog post.
Yoshinori Matsunobu's blog: Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server


Books recommended to read.

Mysql 5.1 Plugin Development

Mysql 5.1 Plugin Development

High Performance MySQL

High Performance MySQL

  • 作者: Baron Schwartz,Peter Zaitsev,Vadim Tkachenko,Jeremy D. Zawodny,Arjen Lentz
  • 出版社/メーカー: Oreilly & Associates Inc
  • 発売日: 2008/06
  • メディア: ペーパーバック
  • 購入: 4人 クリック: 33回
  • この商品を含むブログ (8件) を見る