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...
Replication Series – Introduction

Replication Series – Introduction

Replication is the ability of any database or data streaming software that allows it to maintain multiple copies of data or the server itself. The data flows from the Source (often referred as primary or master or writer etc) node to one or more targets (often...
Step by Step Guide – Group Replication

Step by Step Guide – Group Replication

Single Server Group Replication Setup   Initialize three mysql instances Generate UUID for group name Prepare the config file with group replication and regular replication parameters Start Mysql for all the three instances Primary Member ( port = 24801 )...
Replication in postgres 9.0

Replication in postgres 9.0

Replication in postgres 9.0   We at Genexdb Solutions are constantly test and try new features of open source databases like MySQL,Mongo,PostgreSQL,MariaDB etc. We wanted to explore on how inbuilt replication got started with postgres and thought it is worth...
How To Set Up Master Slave Replication in MySQL

How To Set Up Master Slave Replication in MySQL

What is MySQL replication ? The definition of replication cannot be stated as better as it has been stated in the mysql doc as below. Replication is a technology through which we can maintain a copy data from one source of MySQL server to one or more destination MySQL...