How To Setup Multi Data Centre MySQL Clustering

How To Setup Multi Data Centre MySQL Clustering

How many times have we come across a requirement of mysql cluster spread across different data centres , and each data centre offering its own failover strategy , and failover between data centre to data centre upon failure ? We have also come across such requirements...
An Overview of Enum datatype

An Overview of Enum datatype

Introduction ENUM is a string object with a value chosen from a list of permitted values defined at the time of column creation. ENUM values are represented as integers internally. Enum datatype is chosen whenever a column has a limited possible data values like...
MySQL CDC – Maxwell

MySQL CDC – Maxwell

CDC Introduction Before we go over Maxwell what we need to understand the necessity of softwares like Maxwell. CDC is labeled for change Data Capture which is mostly needed by organizations for applying data analytics/science on their data to get insights of...
Common MySQL Replication Issues

Common MySQL Replication Issues

Introduction In this blog we are going to cover some of the most frequent replication issues that might happen to any actively being used databases. If they are not addressed properly it could really take your standby slaves nodes to an inconsistent and which could...