Switching MySQL slaves in master-master configuration

• September 22, 2016,
• 0Comments

Overview This document generally discusses how to switch mysql slaves between two master mysql servers which are in master-master configuration. In this scenario we have two master-master servers and two slaves named Slave1 and Slave2. Slave1 ..

• Posted by Gayan
• Posted in Uncategorized

Relocate binary logs and relay logs in MySQL server manually

• September 23, 2016,
• 0Comments

Objective: Relocating binary logs and relay logs in MySQL slave database to another location. Environment: Operating System: Ubuntu 12.10 Database : MySQL 5.6. First of all, let’s check if the replication is active or not. Identify curre..

• Posted by Gayan
• Posted in Uncategorized

Fixing Tungsten Replication Failure

• October 21, 2016,
• 0Comments

Scenario: We will simulate a loss of the files at tungsten master server (master1), which have not been applied to slave (slave1). We assume mysql binary logs are still available at master server. These are the steps to simulate the error. ..

• Posted by Gayan
• Posted in Uncategorized