Before i start MemSQL first process installation i would like to share the view about MemSQL. MemSQL is new era IMDB (IN-memory database) which support both in-memory and disk-based storage for performance as well as reliability.
Due to primary storage is as memory its performance is far speeder than traditional disk-based storage databases and its secondary storage disk provides us reliability of data.
In my opinion you go for production with this Database or not but must use this one time. its features will force you to use this.
Installation steps
--------------------
REGISTER ON MEMSQL SITE www.memsql.com
YOU WILL GET MAIL FROM MEMSQL LIKE BELOW
Name: XYZ Trial License Key: 91b7328a50e748c89bfa8702d55c4040
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. 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
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.MemSQL does not have their own client tool, it supports MySQL as a client. So on all the servers MySQL client should be installed.
[root@localhost opt]#wget http://download.memsql.com/91b7328a50e748c89bfa8702d55c1111/memsql-3.2.x86_64.rpm
[root@localhost opt]# ls
memsql-3.2.x86_64.rpm
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
add below at memsql.cnf (/var/lib/memsql) at aggregator
port = 22407
redundancy-level=2
master-aggregator
[root@localhost opt]# service memsql start
mysql -u root --password='' -h 127.0.0.1 -P 22407 --prompt="memsql> "
memsql> add leaf 'root'@'192.168.2.2':22974; (at aggregator)
memsql> add leaf 'root'@'10.20.1.3':22974; (at aggregator)
memsql> show leaves;
+---------------+-------+--------------------+---------------+-----------+--------+--------------------+---------------------------+
Host Port Availability_Group Pair_Host Pair_Port State Opened_Connections Average_Roundtrip_Latency
+---------------+-------+--------------------+---------------+-----------+--------+--------------------+---------------------------+
192.168.2.2 22974 1 10.20.1.3 22974 online 1 0.832
10.20.1.3 22974 2 192.168.2.2 22974 online 1 0.381
+---------------+-------+--------------------+---------------+-----------+--------+--------------------+---------------------------+
2 rows in set (0.01 sec)
Due to primary storage is as memory its performance is far speeder than traditional disk-based storage databases and its secondary storage disk provides us reliability of data.
In my opinion you go for production with this Database or not but must use this one time. its features will force you to use this.
Installation steps
--------------------
REGISTER ON MEMSQL SITE www.memsql.com
YOU WILL GET MAIL FROM MEMSQL LIKE BELOW
Name: XYZ Trial License Key: 91b7328a50e748c89bfa8702d55c4040
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. 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
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.MemSQL does not have their own client tool, it supports MySQL as a client. So on all the servers MySQL client should be installed.
[root@localhost opt]#wget http://download.memsql.com/91b7328a50e748c89bfa8702d55c1111/memsql-3.2.x86_64.rpm
[root@localhost opt]# ls
memsql-3.2.x86_64.rpm
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
add below at memsql.cnf (/var/lib/memsql) at aggregator
port = 22407
redundancy-level=2
master-aggregator
[root@localhost opt]# service memsql start
mysql -u root --password='' -h 127.0.0.1 -P 22407 --prompt="memsql> "
memsql> add leaf 'root'@'192.168.2.2':22974; (at aggregator)
memsql> add leaf 'root'@'10.20.1.3':22974; (at aggregator)
memsql> show leaves;
+---------------+-------+--------------------+---------------+-----------+--------+--------------------+---------------------------+
Host Port Availability_Group Pair_Host Pair_Port State Opened_Connections Average_Roundtrip_Latency
+---------------+-------+--------------------+---------------+-----------+--------+--------------------+---------------------------+
192.168.2.2 22974 1 10.20.1.3 22974 online 1 0.832
10.20.1.3 22974 2 192.168.2.2 22974 online 1 0.381
+---------------+-------+--------------------+---------------+-----------+--------+--------------------+---------------------------+
2 rows in set (0.01 sec)
