Writing this post after so many days, yet another IN-MEMORY database is in market which tag line promised with"The DataBase for Real-Time Applications".
As per MemSQL site - MemSQL is a scalable SQL database that ingests data continuously to perform operational analytics for the front lines of your business. Ingest millions of events per day with ACID transactions while simultaneously analyzing billions of rows of data in relational SQL, JSON, or Geospatial formats.
In my current assignment, I've been asked to look into the capabilities of this db, so starting with very first step "Installation" -
Installation in linux is quite simple, if you are OK with linux commands, You can follow the installation from HERE
1. Download the software (with sudo or root user) -
sudo su - root
wget http://download.memsql.com/memsql-ops-6.0.11/memsql-ops-6.0.11.tar.gz
2. Extract the tar ball
tar zxvf memsql-ops-6.0.11.tar.gz
3. Run the installer script
cd memsql-ops-6.0.11
sudo ./install.sh --simple-cluster
By default, MemSQL supports the machine with 4 cpu core and 8 GB of RAM (which is little unfair;-)) so remove this constraints by below argument -
cd memsql-ops-6.0.11
sudo ./install.sh --simple-cluster --ignore-min-requirements
After being successful installation of MemSQL, it will start setting up MemSQL WebUI.
You can access the MemSQL WebUI on the sever's 9000 port by default.
https://<SERVER_IP>:9000
4. To connect to MemSQL command line, execute -
memsql
In next post, I will explain how this db is different than other in-memory db. Till then, Keep Learning , Keep Loving.
Facebook Page Facebook Group Twitter Feed Google+ Feed Telegram Group