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
Steps to Create Active Physical Standby Dataguard Using RMAN Duplicate in Oracle In the previous article, we have configured a Physical STANDBYdatabase where we started MRP in mount state. In this article, we are going to demonstrate Steps to Create Active Physical Standby Dataguard Using RMAN Active Duplicate in Oracle database. Active dataguard features introduced
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
Multiplexing of Control Files Using RMAN, SPFILE & PFILE in Oracle Here we are going to demonstrate multiplexing of Control Files in Oracle using available options SPFILE, PFILE & RMAN. Before moving ahead first we will have a basic understanding of Control Files in Oracle. Control File is a physical file on OS level and
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
Step by Step Physical Standby Database Creation in Oracle Data Guard is used for disaster recovery and high availability. Due to any disaster, if our PRIMARY database got crash so, in that case, our STANDBY may become our PRIMARY database. Here, our client requirement, we need to create a STANDBY database using RMAN backup. Below
Create MySQL Instance Replica using Clone Command MySQL 8 has recently released clone plugin which makes cloning process very easy and handy to perform. In this blog we will see How to install and perform clone of mysql instance. I will clone complete mysql instance server_id 3 into server_id 4, Please note in server_id 4