2015-06-02
Installing and Configuring MemSQL Ops
http://docs.memsql.com/latest/ops/install/
下載網頁
http://www.memsql.com/download/
安裝說明
http://docs.memsql.com/latest/setup/setup_onprem/
硬體需求
http://docs.memsql.com/latest/setup/requirements/#hardware-requirements-onprem
CPU : Two socket x86-64 based server with 8 cores. At a minimum, Intel Core i3 or better processor. (MemSQL will run on machines with less than 8GB RAM, but this is not recommended.)
Memory : Recommended: 64-96GB. Minimum: 8GB
Hard Drive : SSD or SATA 7200RPM hard drive with 3X memory capacity
MemSQL 是由前Facebook工程師創辦的，號稱世界上最快的分佈式關係型數據庫，兼容MySQL但更快，原理是僅用內存並將SQL預編譯為C++。
社群版 (Community Edition) 安裝
(要可以連上 Internet，install.sh 執行過程，會自動下載套件安裝)
cd /usr/local
wget http://download.memsql.com/memsql-ops-4.0.28/memsql-ops-4.0.28.tar.gz
tar zxvf memsql-ops-4.0.28.tar.gz
cd memsql-ops-4.0.28
./install.sh
[root@localhost memsql-ops-4.0.28]# ./install.sh
Installing MemSQL Ops in /var/lib/memsql-ops
Creating a memsql user
Setting up permissions
Creating an init script so that MemSQL Ops runs on startup
Creating a symlink to MemSQL Ops at /usr/bin/memsql-ops
Successfully installed MemSQL Ops!
--------------------------------------------------------------------------------
You can install MemSQL across multiple machines
using the MemSQL Ops Web UI.
For quick testing, you can also install a simple MemSQL
deployment on this host.
Do you want to install MemSQL on this host only? [y/N] y
2015-06-02 10:34:05: J62bf4b [INFO] Deploying MemSQL to 192.168.128.71:3306
2015-06-02 10:34:05: J359f08 [INFO] Deploying MemSQL to 192.168.128.71:3307
2015-06-02 10:34:51: J62bf4b [INFO] Downloading MemSQL: 100.00%
2015-06-02 10:34:51: J62bf4b [INFO] Installing MemSQL
2015-06-02 10:34:51: J359f08 [INFO] Downloading MemSQL: 100.00%
2015-06-02 10:34:51: J359f08 [INFO] Installing MemSQL
2015-06-02 10:35:22: J62bf4b [INFO] Finishing MemSQL Install
2015-06-02 10:35:22: J359f08 [INFO] Finishing MemSQL Install
Waiting for MemSQL to start...
MemSQL failed to start: Failed to start MemSQL: This machine does not have enough memory to run MemSQL. The minimum required size is 3700 MB, and this machine has 1826 MB
Cleaning up failed MemSQL installs
You can setup, manage and monitor MemSQL with the MemSQL Ops
web UI on port 9000. Make sure that port 9000 is open in your
firewall or security group.
[root@localhost memsql-ops-4.0.28]#
VM 目前設定 2GB RAM 無法安裝，根據訊息至少還要 3700-1826=1874 MB，所以 VM PowerOff 後，設定為 4GB 再測試
[root@localhost memsql-ops-4.0.28]# ./install.sh
Installing MemSQL Ops in /var/lib/memsql-ops
Creating a memsql user
Setting up permissions
Creating an init script so that MemSQL Ops runs on startup
Creating a symlink to MemSQL Ops at /usr/bin/memsql-ops
Successfully installed MemSQL Ops!
--------------------------------------------------------------------------------
You can install MemSQL across multiple machines
using the MemSQL Ops Web UI.
For quick testing, you can also install a simple MemSQL
deployment on this host.
Do you want to install MemSQL on this host only? [y/N] y
2015-06-02 10:44:16: J8114ec [INFO] Deploying MemSQL to 192.168.128.71:3306
2015-06-02 10:44:16: J6884a3 [INFO] Deploying MemSQL to 192.168.128.71:3307
2015-06-02 10:45:24: J8114ec [INFO] Downloading MemSQL: 100.00%
2015-06-02 10:45:24: J8114ec [INFO] Installing MemSQL
2015-06-02 10:45:24: J6884a3 [INFO] Downloading MemSQL: 100.00%
2015-06-02 10:45:24: J6884a3 [INFO] Installing MemSQL
2015-06-02 10:45:43: J6884a3 [INFO] Finishing MemSQL Install
2015-06-02 10:45:45: J8114ec [INFO] Finishing MemSQL Install
Waiting for MemSQL to start...
MemSQL failed to start: Failed to start MemSQL: This machine does not have enough CPU cores to run MemSQL. The minimum required number is 4, and this machine has 1 cores
Cleaning up failed MemSQL installs
You can setup, manage and monitor MemSQL with the MemSQL Ops
web UI on port 9000. Make sure that port 9000 is open in your
firewall or security group.
[root@localhost memsql-ops-4.0.28]#
要 4 core CPU，PowerOff 修改 VM 設定為 4 processors 和 1 core/processor 後再 Power On測試
[root@localhost memsql-ops]# memsql-ops status
MemSQL Ops is running with pid 2888 on port 9000.
[root@localhost memsql-ops-4.0.28]# ps aux | grep mem
memsql 2888 0.8 1.4 3660224 54296 ? Sl 10:49 0:01 /var/lib/memsql-ops/lib/memsql-ops start
root 4130 0.0 0.0 112644 960 pts/0 S+ 10:52 0:00 grep --color=auto mem
[root@localhost memsql-ops-4.0.28]# netstat -ntulp | grep 9000
tcp 0 0 0.0.0.0:9000 0.0.0.0:* LISTEN 2888/memsql-ops
[root@localhost memsql-ops-4.0.28]# /var/lib/memsql-ops/lib/memsql-ops stop
Stopping MemSQL Ops
Waiting up to 60 seconds for a clean exit.
Done.
[root@localhost memsql-ops-4.0.28]# /var/lib/memsql-ops/lib/memsql-ops start
Starting MemSQL Ops...
MemSQL Ops is running with pid 5081
The web UI is running on port 9000
[root@localhost memsql-ops-4.0.28]#
(完)
沒有留言:
張貼留言