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