0 Comments

Setup Streaming Replication with repmgr and barman in PostgreSQL 0 (0)

Setup Streaming Replication with repmgr and barman in PostgreSQL repmgr is an open-source toolset and it is used to automate, enhance, and manage PostgreSQL streaming replication. Natively setting up and managing streaming replication involves many manual steps which include:1. Configuring replication parameters in both primary and each standby node.2. Backing up primary node data with […]

 18 Total Views,  6 Views Today

0 Comments

Configure Logical Replication in PostgreSQL 0 (0)

Configure Logical Replication in PostgreSQL   In the recent three blogs, we discuss briefly on Replication available options in PostgreSql Click here to read more. And How To Configure File-Based Log Shipping in PostgreSQL Click here to read more. How To Configure Streaming Replication  in PostgreSQL Click here to read more. And In this blog, we will implement Logical Replication in PostgreSQL.  Logical replication is […]

 115 Total Views,  8 Views Today

0 Comments

Configure Streaming Replication (Record Based Log Shipping) in PostgreSql 0 (0)

Configure Streaming Replication (Record Based Log Shipping) in PostgreSQL In the recent two blogs, we discuss briefly on Replication available options in PostgreSql Click here to read more. And How To Configure File-Based Log Shipping in PostgreSQL Click here to read more. In this blog, we will implement Record Based Log Shipping also know as Streaming Replication in PostgreSQL.  […]

 91 Total Views,  2 Views Today

0 Comments

Configure File Based Log Shipping in PostgreSQL 0 (0)

Configure File Based Log Shipping in PostgreSQL In the previous blog, we discuss briefly on Replication available options in PostgreSql Click here to read more. In this blog, we will implement File Based Log Shipping in PostgreSQL. Below are setup details and the same will be used in this demonstration. Sr No Hostname IP Role […]

 97 Total Views,  1 Views Today

0 Comments

Introduction to Replication in PostgreSQL 0 (0)

Introduction to Replication in PostgreSQL Introduction to Replication:- Replication refers to the process of copying modifications in data from the Primary database to the Standby database. Both these databases are usually located on different physical servers and help in distributing various types of database queries. Replication is implemented in PostgreSQL using a master-slave configuration. The […]

 118 Total Views,  5 Views Today

0 Comments

How To Bootstrap MySQL Router For InnoDB Cluster 0 (0)

How To Bootstrap MySQL Router For InnoDB Cluster Bootstrap MySQL Router against an InnoDB Cluster to automatically configure the routing of incoming client connections to mysql instances. To bootstrap MySQL Router at the command-line, pass in the –bootstrap option when you start the mysqlrouter command, and it retrieves the topology information from the metadata and configures routing connections to […]

 673 Total Views,  10 Views Today

0 Comments

Changing InnoDB Cluster Topology in MySQL 0 (0)

Changing InnoDB Cluster Topology in MySQL By default, an InnoDB Cluster runs in single-primary mode, where the cluster has one primary server that accepts read and writes queries (R/W), and all of the remaining instances in the cluster accept only read queries (R/O). When you configure a cluster to run in multi-primary mode, all of […]

 311 Total Views

0 Comments

How to Setup MySql InnoDB Cluster 0 (0)

How to Setup MySql InnoDB Cluster MySQL InnoDB Cluster provides a complete high availability solution for MySQL. By using the AdminAPI included with MySql Shell, you can easily configure and administer a group of at least three MySQL server instances to function as an InnoDB Cluster. Each MySQL server instance runs MySQL Group Replication, which […]

 355 Total Views,  2 Views Today

0 Comments

Adopting a Group Replication Deployment into InnoDB Cluster 0 (0)

Adopting a Group Replication Deployment into InnoDB Cluster in MySQL If you have an existing deployment of Group Replication and you want to use it to create a cluster, pass the adoptFromGR option to the dba.createCluster() function. The created InnoDB Cluster matches whether the replication group is running as single-primary or multi-primary. To adopt an […]

 343 Total Views,  2 Views Today

0 Comments

How to change Group Replication Mode in MySQL 0 (0)

How to change Group Replication Mode in MySQL In this blog, we will see How to change the mode in which a group is running in, either single or multi-primary. For this we will use two functions group_replication_switch_to_multi_primary_mode() & group_replication_switch_to_single_primary_mode(). These functions used to change a group’s mode can be run on any member. In […]

 437 Total Views,  1 Views Today