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 […]

 14 Total Views,  14 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 […]

 25 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 […]

 61 Total Views,  4 Views Today

0 Comments

Deploying MySql Group Replication in Single-Primary Mode 0 (0)

Deploying MySql Group Replication in Single-Primary Mode Group Replication is provided as a plugin to MySQL Server. MySQL Group Replication enables you to create elastic, highly-available, fault-tolerant replication topologies and Group Replication guarantees that the database service is continuously available. Groups can operate in a single-primary mode with the automatic primary election, where only one […]

 70 Total Views,  3 Views Today

0 Comments

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

How To Bootstrap MySQL Router For InnoDB ReplicaSet In the previous blog, we saw How to Configure InnoDB ReplicaSet Click here to read more & How to perform Switchover/Failover in MySql InnoDB ReplicaSet Click here to read more. We will use the same configuration to install and bootstrap mysql router. Bootstrap MySQL Router against an InnoDB ReplicaSet […]

 82 Total Views,  3 Views Today

0 Comments

How to perform Switchover/Failover in MySql InnoDB ReplicaSet 0 (0)

How to perform Switchover/Failover in MySql InnoDB ReplicaSet In the previous blog, we saw Part I: How to Configure InnoDB ReplicaSet MySQL Click here to read more. We will use the same configuration to perform Switchover & Failover in InnoDB ReplicaSet. Below are the setup information. Hostname IP Role Server_ID Port Installation Link test-machine01 192.168.114.177 […]

 102 Total Views,  1 Views Today

0 Comments

How to Configure InnoDB ReplicaSet New MySQL 0 (0)

How to Configure InnoDB ReplicaSet mysqlshell AdminAPI includes support for InnoDB ReplicaSet, which enables you to create and administer a set of MySQL instances running asynchronous GTID-based replication.  An InnoDB ReplicaSet consists of a single primary and multiple replicas. InnoDB ReplicaSet Prerequisites Only instances running MySQL version 8.0 and later are supported. Only GTID-based replication is supported, binary log file […]

 88 Total Views

0 Comments

Asynchronous Replication Automatic Failover in MySQL 0 (0)

Asynchronous Replication Automatic Failover in MySQL MySQL 8.0.22 supports an asynchronous connection failover mechanism. This feature allows a replica/slave to automatically failover to a new source/master, in case its existing source/master fails. When the existing connection source/master fails, the replica first retries the same connection for the number of times specified by the MASTER_RETRY_COUNT. The […]

 104 Total Views,  1 Views Today

0 Comments

How to Setup MySQL Master-Master Replication (Circular Replication) 0 (0)

How to Setup MySQL Master-Master Replication (Circular Replication) Master-Master Replication (Circular Replication) also known as ring topology in MySQL, this setup requires two or more MySQL servers which act as a master. All masters receive writes and generate binlogs. Below points should be considered while doing the master-master setup. You need to set an auto-increment […]

 154 Total Views,  5 Views Today

0 Comments

MySQL Multi-Source Replication – GTID Based Sources 0 (0)

MySQL Multi-Source Replication – GTID Based Sources In this blog post, we will see How to setup MySQL Multi-Source Replication – GTID Based Sources. For this demonstration, we will be using the below configuration. We have already set up 2 mysql instance in test-machine01 server running on port 3306 (Server_ID : 1) & 3307 (Server_ID […]

 147 Total Views,  4 Views Today