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

RMAN Full Database Backup Scripts in Oracle 5 (1)

RMAN Full Database Backup Scripts in Oracle. In this article, we are going to prepare a script for RMAN full database backup which includes backup of datafiles, control files, spfile along with archives. This RMAN full database script will create a backup in a specified location (local directory) on the database server. Generally, we do […]

 48 Total Views

0 Comments

Oracle Database 19c RPM Installation On Oracle Linux 7 0 (0)

Oracle Database 19c RPM Installation On Oracle Linux 7 Oracle Database 19c can now be installed on Linux OS using an RPM.This post describes the steps for RPM based installation of Oracle Database 19c 64-bit on OEL 7 64-bit. Step 1. Prerequisite for Installation: Two most important things for rpm based installation is (1) You […]

 79 Total Views

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

Steps to Create Active Physical Standby Dataguard Using RMAN Duplicate in Oracle 0 (0)

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

 196 Total Views,  3 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

Multiplexing of Control Files Using RMAN, SPFILE & PFILE in Oracle 0 (0)

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

 139 Total Views,  3 Views Today