I'm really excited about having MySQL as not only my relational database, but also a key/value, No-SQL store. And to top it all off, memcached is tied into it.
Installing this with Homebrew is as easy as punch.
brew install --enable-memcached mysql
Now, take a look in this folder: /usr/local/Cellar/mysql/5.6.10/share/mysql
You'll see a file named innodb_memcached_config.sql
Run that sql on your db: mysql -uroot -p < innodb_memcached_config.sql
Now, install the plugin:
mysql> INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
This should work if you added the --enable-memcached flag. The libmemcached.so file should exist in your /usr/local/Cellar/mysql/5.6.10/lib/plugin folder.
Confirm that the plugin is installed with:
mysql> show plugins;
At the bottom of the list, you should see:
| daemon_memcached | ACTIVE | DAEMON | libmemcached.so | GPL |
Restart mysql. Memcached is now running at port 11211
Keep your eyes open for future posts on mixing this into a Rails application.
