myrocks安装

linux

myrocks安装

已编译好的下载包 http://pan.baidu.com/s/1eR4vrO2 kbnd

先下载好

然后解压

查看基础文档

配置文件如下

[mysqld]
rocksdb
default-storage-engine=rocksdb
skip-innodb
default-tmp-storage-engine=MyISAM
collation-server=latin1_bin

init_connect='SET NAMES utf8'

log-bin
binlog-format=ROW
basedir =/home/free/rock
datadir =/home/free/rock/data
port =3309
server_id = 100032
socket =/home/free/rock/rock.sock

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

运行命令

path替换你的路径

安装

mysql_install_db --defaults-file=/path/to/my.cnf

运行

mysqld_safe --defaults-file=/path/to/my.cnf

安装后的设置

mysql --socket=xxxx

set password=password('root');
grant all privileges on *.* to root@'%' identified by 'root';

flush privileges;

grant grant option on *.* to 'root'@'%';