SingleStore MA Architecture

SingleStore Installation contains 3 components - SingleStore Database, SingleStore Toolbox and SingleStore Client.

SingleStore Database software itself runs as the process memsqld. On the Unix box running SingleStore, to check if SingleStore is running or not, ps -ef | grep memsqld.

SingleStore Toolbox is the clusterware software which is used to control various memsql operations on the cluster, change configurations across the cluster, add / remove nodes, upgrade SingleStore etc. It is the total cluster controlling software. It is similar to Oracle Clusterware software.

SingleStore client is the software used to connect to SingleStore. It can connect to any cluster. 

SingleStore Toolbox and Client is not installed on all the servers. It is installed only on the Master Aggregator to save on installation time and space. If needed, we can install on all the servers. Best practice is to install on the Child Aggregators so that incase of Master Aggregator is not available, we are able to control the cluster.


SingleStore Toolbox replaces memsql-ops which was used in earlier versions. By default, memsql-ops was installed on all the servers, but was taking time. Toolbox is installed only installed on the desired servers.


Comments

Post a Comment

Popular posts from this blog

Architecture of SingleStore / MemSQL

Image
  SingleStore / MemSQL Cluster Most of the SingleStore DBAs will be fully aware of this. Just for starters, an information of what a typical SingleStore / MemSQL Cluster looks like. Master Aggregator - Heart of the cluster as the name suggests. Clients can connect to any aggregator including master aggregator. Master Aggregator contains the metadata about the leaf nodes,  version, end user security, metadata on which leaf node to look into when a client requests data, cluster realtime information etc. Master Aggregator is the master control of the cluster. User management, upgrades, create database  and few important cluster operations can only be performed on the master aggregator. In the case of a failure,  cluster can be operational via child aggregator. But important functions cannot be performed. In that case, a child can be promoted to master. Child Aggregator -  High availability for the clients can be provided using child aggregators. Also, having multi...
Read more