Posts

SingleStore MA Architecture

Image
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 ...
Post a Comment
Read more

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...
Post a Comment
Read more

Welcome to SingleStore formerly MemSQL DBA Blogs

Dear Readers,  Welcome to SingleStore  DBA Experiences.  I am Vasanth Ramu, and I have been working on SingleStore, formerly MemSQL from past 7 years starting from version 5.0. I will be sharing my experiences and learnings from this blogpost, helping fellow SingleStore DBAs as an alternative to official documentation and more practical experience of managing SingleStore in an Enterprise with on-premises deployment. I am a  DBA with experience ranging from technologies like Oracle, SQL Server, PostgreSQL, MongoDB and Greenplum and I am 9i and 11g Oracle Certified Professional. I am hoping this blog will be  helpful and handy for SingleStore DBAs. Thanking You, Vasanth Ramu
Post a Comment
Read more