Tag: Replication

How to Verify If a Slave Running in MySQL 5.7

Derek Downey, OSDB Practice Advocate at Pythian, explains how to verify that a Slave is running in MySQL 5.7.

Read More >

Truncates and Sequences Replication in Oracle GoldenGate

Gleb Otochkin, Principal Consultant and Certified Oracle Expert at Pythian, discusses the truncate operation and support for sequences values replication.

Read More >

Creating An External Slave For A Live AWS Aurora Instance

Kevin Markwardt, MySQL Database Consultant at Pythian, explains how to set up an external slave for a live Amazon AWS Aurora instance.

Read More >

Exploring The Operations Log In MongoDB

Igor Donchovski, Database Consultant at Pythian, explains the MongoDB Operations log. Discover how the replication window compares to MySQL, how to change the oplog size, and what is improved in MongoDB 3.0 wiredTiger engine.

Read More >

SharePlex Replication Between Two Instances On The Same Host

Gleb Otochkin, Principal Consultant and Certified Oracle Expert at Pythian, explains how to preform SharePlex replication between two instances on the same host.

Read More >

Migrate a SQL Server environment with complex replication without reinitializing or rebuilding replication

Michelle Gutzait, one of Pythian’s SQL Server Experts, discusses how to migrate a SQL Server environment with complex replication without reinitializing or rebuilding replication.

Read More >

Resolving Update-Update Conflict in Peer-to-Peer Replication

Hemantgiri Goswami, Microsoft SQL Server MVP and Lead Database Consultant, discusses how to resolve an Update-Update Conflict in Peer-to-Peer Replication in SQL.

Read More >

My Thoughts on the Resilience of Cassandra

2000px-Cassandra_logo.svg

This blog is a part 1 of a 2 in a series. This will be different from my previous blogs, as this is more about some decisions you can make with Cassandra regarding the resilience of your system. I will talk…

Read More >

Merge Replication Identity Range Management – An Identity Disorder? Part 2

part 2 explores how transactions and batches can affect Merge replication identity range management. It shows a case where batch insert inside a transaction caused applications to fail and provides a resolution to the case.

Read More >

How to Configure Transactional Replication-Mirroring Failover

Configure SQL Server Transactional Replication with Mirroring – this was one of the recent interesting and unusual projects that came our way. At first it looked really odd and intriguing at the same time. The question was, can it really…

Read More >
Page 1 of 212