MemSQL Installation

MemSQL installation is very simple. But before installation its important to choose the suitable package. Earlier MemSQL subscription was free for one month but as per my knowledge they have extended the trial period upto 3 months. So its very convenient for end user to evaluate the product with time. No need to hurry.

As per my experience MemSQL has separate subscription for trial and for production. The production subscription has lot more as compare to trial subscription. So its better to go for easiest installation option for trial.

One of the common industry installation options is rpm. In this entire blog I will discuss the things based on rpm installation.

How do we start rpm installation (step wise)

1. REGISTER ON MEMSQL SITE www.memsql.com
2. YOU WILL GET MAIL FROM MEMSQL LIKE BELOW
3. Name: Jeetendra Ranjan                  Trial License Key: 91b7328a50e748c89bfa8702d55c1111
                     License File: Click here to download
                             now go to the bottom of the page and you will see the rpm installation link like below
   
   The following installation options require installing MemSQL on each node of your cluster. For instructions on installing MemSQL, click here.
   MemSQL Download Links
   $ wget http://download.memsql.com/91b7328a50e748c89bfa8702d55c1111/memsql-3.2.x86_64.rpm
   Here I would like to share one more link which you will see. this is memsql-ops. So memsql-ops is very useful monitoring tool for memsql as this is very difficult to monitor all the servers(aggregators and leaves individually. So go for memsql-ops installation also. here is the link
   $ wget http://download.memsql.com/ops-3.1.1/memsql-ops-3.1.1.x86_64.rpm
4. Before we start installation few very important point. First is MemSQL does not support 32-bit architecture so don't try to install on 32-bit servers. Secondly as we know MemSQL is two tiered architecture so same installation should be done on all the aggregators as well as on leaves. Very important is MemSQL does not have their own client tool so it support MySQL as a client. So on all the servers MySQL client should be installed.
5.  [root@localhost opt]#wget http://download.memsql.com/91b7328a50e748c89bfa8702d55c1111/memsql-3.2.x86_64.rpm
6.  [root@localhost opt]# ls
     memsql-3.2.x86_64.rpm
7. 4. [root@localhost opt]# rpm -i memsql-3.2.x86_64.rpm
    [root@localhost opt]# rpm -qa  grep -i memsql
    memsql-3.2-1.x86_64
    [root@localhost opt]# rpm -qa  grep -i mysql (i
    MySQL-client-5.5.27-1.linux2.6.x86_64
8. add below at memsql.cnf (/var/lib/memsql) at aggregator
   
    port  = 22407
    redundancy-level=2
    master-aggregator
9. [root@localhost opt]# service memsql start
10. mysql -u root --password='' -h 127.0.0.1 -P 22407 --prompt="memsql> "
11. memsql> add leaf 'root'@'192.168.2.2':23976; (at aggregator)
     memsql> add leaf 'root'@'10.20.1.3':23976; (at aggregator)
12. memsql> show leaves;
    +---------------+-------+--------------------+---------------+-----------+--------+--------------------+---------------------------+
     Host           Port   Availability_Group  Pair_Host      Pair_Port  State   Opened_Connections  Average_Roundtrip_Latency
    +---------------+-------+--------------------+---------------+-----------+--------+--------------------+---------------------------+
     192.168.2.2  23976                   1  10.20.1.3        23976  online                   1                      0.832
     10.20.1.3    23976                   2  192.168.2.2     23976  online                   1                      0.381
    +---------------+-------+--------------------+---------------+-----------+--------+--------------------+---------------------------+
    2 rows in set (0.01 sec)