SingleStore DBA

  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...

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