OurSQL Episode 27: To SQL or No[tto]SQL, that is the question

We talk about HandlerSocket with special guest Patrick Galbraith of Blue Gecko, have some Ear Candy and talk about OSCon and the Strata Conferences

The HandlerSocket announcement blog post from Yoshinori Matsunobu of DeNA: http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-as-nosql-stor...

HandlerSocket in Percona's build: http://www.mysqlperformanceblog.com/2010/12/14/percona-server-now-both-s...

PBXT has had it for years: http://pbxt.blogspot.com/2010/12/handlersocket-why-did-out-version-did.h...

sample MySQL settings using HandlerSocket from Patrick:
First you have to:

mysql> install plugin handlersocket soname 'handlersocket.so';

Then you can add to your my.cnf:

[mysqld]
# HandlerSocket settings
loose_handlersocket_port = 9998 # the port number to bind to for read requests
loose_handlersocket_port_wr = 9999 # the port number to bind to for write requests
loose_handlersocket_threads = 16 # the number of worker threads for read requests
loose_handlersocket_threads_wr = 1 # the number of worker threads for write requests
open_files_limit = 65535
# to allow handlersocket to accept many concurrent
# connections, make open_files_limit as large as
# possible.

IRC channels at irc.freenode.net:
#mysql
#mysql_guru
#drizzle
#memcached
Patrick's handle is capttofu

Henrik Ingo did in fact leave Monty Program: http://openlife.cc/blogs/2010/november/leaving-monty-program-and-mariadb

Blue Gecko blog: http://www.bluegecko.net/community/blog/

Patrick’s books:
Expert PHP and MySQL - http://www.wiley.com/WileyCDA/WileyTitle/productCd-0470563125.html
Developing Web Applications with Apache, MySQL, memcached, and Perl - http://www.amazon.com/Developing-Applications-Apache-MySQL-memcached/dp/...

The five-minute video guide to NoSQL redux by Mark Atwood - http://www.youtube.com/watch?v=zAbFRiyT3LU

Monty Program has put out a trademark policy: http://kb.askmonty.org/v/trademark-policy Very readable translation from the legalese of when one can use a trademark.

Ear Candy
ALTER TABLE...DISABLE/ENABLE KEYS is MyISAM only.
mysql> alter table foo disable keys;
Query OK, 0 rows affected, 1 warning (0.00 sec)
| Note | 1031 | Table storage engine for 'foo' doesn't have this option |

Conferences
O’Reilly’s Strata, a conference about big data, is Feb 1-3 in Santa Clara, CA. https://en.oreilly.com/strata2011/public/register?cmp=il-radar-st11-stra... The speaker list is at http://strataconf.com/strata2011/public/schedule/speakers

Send us feedback via:
Facebook group
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast

Trackback URL for this post:

http://technocation.org/trackback/1086