MemSQL介绍与安装

 

前Facebook工程师创办的MemSQL公司获500万美元投资。http://url.cn/2Ij2BY

号称世界上最快的分布式关系型数据库,兼容MySQL但快30倍,能实现每秒150万次事务。原理是仅用内存并将SQL预编译为C++。

下载:http://url.cn/4cjsqE

Download and Start MemSQL

If you want to download MemSQL yourself, the installation process is really simple. On your favorite 64-bit Linux, just run:

$ wget http://download.memsql.com/54fb547a16224c85ae240a209b66067b/memsqlbin_amd64.tar.gz

$ tar -xzf memsqlbin_amd64.tar.gz

$ cd memsqlbin

$ ./check_system

$ ./memsqld –port 3307
Note: MemSQL runs on port 3306 by default (the same port as MySQL). Running it on port 3307 will avoid conflicts if MySQL is running on your machine.

Connect with the MySQL Client

MemSQL is wire-compatible with MySQL, so you can run queries directly from the MySQL client.

$ mysql -u root -h 127.0.0.1 -P 3307 --prompt="memsql> "