Switching MySQL slaves in master-master configuration
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 ..
Relocate binary logs and relay logs in MySQL server manually
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..
Fixing Tungsten Replication Failure
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. ..