Facebookが公開した新しいMySQL用ストレージエンジン「MyRocks」を試してみる 〜インストール編〜 ref: http://qiita.com/endam/items/de670eb4d773d27dc802

file0.txt

docker pull perconalab/myrocks

file1.txt

docker run -d --name myr -P  perconalab/myrocks

file2.sql

CREATE TABLE `linktable` (
 `id1` bigint(20) unsigned NOT NULL DEFAULT '0',
 `id1_type` int(10) unsigned NOT NULL DEFAULT '0',
 `id2` bigint(20) unsigned NOT NULL DEFAULT '0',
 `id2_type` int(10) unsigned NOT NULL DEFAULT '0',
 `link_type` bigint(20) unsigned NOT NULL DEFAULT '0',
 `visibility` tinyint(3) NOT NULL DEFAULT '0',
 `data` varchar(255) NOT NULL DEFAULT '',
 `time` bigint(20) unsigned NOT NULL DEFAULT '0',
 `version` int(11) unsigned NOT NULL DEFAULT '0',
 PRIMARY KEY (link_type, `id1`,`id2`) COMMENT 'cf_link_pk',
 KEY `id1_type` (`id1`,`link_type`,`visibility`,`time`,`version`,`data`) COMMENT 'rev:cf_link_id1_type'
) ENGINE=RocksDB DEFAULT COLLATE=latin1_bin; 

file2.txt

mysql -h127.0.0.1
RROR 1130 (HY000): Host 'gateway' is not allowed to connect to this MySQL server

file3.txt

$ docker exec -it  myr bash
[root@84e0d99b1244 /]# /usr/local/mysql/bin/mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.6.27 Source distribution

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

file4.txt

mysql> show engines;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine     | Support | Comment                                                        | Transactions | XA   | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| ROCKSDB    | DEFAULT | RocksDB storage engine                                         | YES          | YES  | YES        |
| MRG_MYISAM | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
| MyISAM     | YES     | MyISAM storage engine                                          | NO           | NO   | NO         |
| BLACKHOLE  | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
| CSV        | YES     | CSV storage engine                                             | NO           | NO   | NO         |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
| ARCHIVE    | YES     | Archive storage engine                                         | NO           | NO   | NO         |
| FEDERATED  | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |
| InnoDB     | NO      | Supports transactions, row-level locking, and foreign keys     | NULL         | NULL | NULL       |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+

file5.sql

CREATE TABLE `linktable` (
 `id1` bigint(20) unsigned NOT NULL DEFAULT '0',
 `id1_type` int(10) unsigned NOT NULL DEFAULT '0',
 `id2` bigint(20) unsigned NOT NULL DEFAULT '0',
 `id2_type` int(10) unsigned NOT NULL DEFAULT '0',
 `link_type` bigint(20) unsigned NOT NULL DEFAULT '0',
 `visibility` tinyint(3) NOT NULL DEFAULT '0',
 `data` varchar(255) NOT NULL DEFAULT '',
 `time` bigint(20) unsigned NOT NULL DEFAULT '0',
 `version` int(11) unsigned NOT NULL DEFAULT '0',
 PRIMARY KEY (link_type, `id1`,`id2`) COMMENT 'cf_link_pk',
 KEY `id1_type` (`id1`,`link_type`,`visibility`,`time`,`version`,`data`) COMMENT 'rev:cf_link_id1_type'
) ENGINE=RocksDB DEFAULT COLLATE=latin1_bin; 

file6.txt

mysql> show table status \G
*************************** 1. row ***************************
           Name: linktable
         Engine: ROCKSDB