Last active
September 22, 2016 04:48
-
-
Save endam/fc4d76bac391fae9d5d7945ddfe99aac to your computer and use it in GitHub Desktop.
Facebookが公開した新しいMySQL用ストレージエンジン「MyRocks」を試してみる 〜インストール編〜 ref: http://qiita.com/endam/items/de670eb4d773d27dc802
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
docker pull perconalab/myrocks |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
docker run -d --name myr -P perconalab/myrocks |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
mysql -h127.0.0.1 | |
RROR 1130 (HY000): Host 'gateway' is not allowed to connect to this MySQL server |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ 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> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | | |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
mysql> show table status \G | |
*************************** 1. row *************************** | |
Name: linktable | |
Engine: ROCKSDB |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment