MemSQL runs natively on 64-bit Linux operating systems. Your system hardware must have at least 4 CPU cores and 8 GB of RAM, and you must using a supported distribution of Linux. For more information, see our System Requirements.
1Download the MemSQL tar file
Open the Terminal App on your computer and execute theses commands. They download the MemSQL tar file to the /tmp directory (or a path of your own choosing).
cd /tmp
wget http://download.memsql.com/memsql-ops-6.0.10/memsql-ops-6.0.10.tar.gz
2Extract the contents of the tar file
This command extracts the MemSQL executable from the tar file to a folder with the same name.
tar zxvf memsql-ops-6.0.10.tar.gz
3Run the installer script and deploy a simple cluster
These commands navigate to the extracted folder and then run an installer script that installs MemSQL as a simple cluster with one master aggregator and one leaf.
cd memsql-ops-6.0.10
sudo ./install.sh --simple-cluster
4Connect to the MemSQL client
memsql
然后你可以使用 mysql 的命令行或者是 mysql 的客户端工具连接到 MemSQL,跟连接到 MySQL 的方法一样,例如:
$ mysql -u root -h 127.0.0.1 -P 3307 --prompt="memsql> "
你也可以使用一些图形化的数据库管理工具来连接。
使用 MemSQL 跟使用 MySQL 没有区别:)
删除:
memsql-ops memsql-delete 可删除数据库