Question : I created MERGE statements to transfer differences with a minimal set of required columns from production db into […]
Category: Replication
Can I set up Wal Archiving on a three years old Postgres database?
Question : If I set up Wal Archiving on a three years old Postgres database (used in production); do the […]
Changing tx_isolation and binlog format on master server – do i also need to adjust slave?
Question : We are running a Drupal Commerce site with MariaDB 10.0 and master/slave replication. Because of the way our […]
Doubts on Setting up Master-Master replication (Percona)
Question : I have two 5.6 Percona servers in which I’m planning to setup Active master- Passive master replication. Secondary […]
Issue with SQL Server 2008 replication
Question : I’m doing merge replication between two SQL Server 2008 machine.But,when I attempt to do any modification on system,I […]
Should a MySQL slave used for backup also be used to service read-only requests in a production environment?
Question : Based on best practices, I’m wondering if we should have at least one slave that’s used solely as […]
pg_xlog not recycling WAL files on slave server
Question : I’ve setup streaming replication with Postgres 9.3 My problem is that on the slave server the pg_xlog folder […]
Upgrading to MySQL 5.6, benefits to switching to GTID replication?
Question : We have the most basic of MySQL replication setups, a single Master doing statement-based replication to a single […]
Master Slave Replication in Mysql
Question : I have generated a dump from Master and I have to construct slave and give privileges and binary […]
.NET error when trying to create snapshot for transactional Replication
Question : I encountered a bizarre prob today while creating a transactional publication on a SQL 2012 server running on […]