Question : In our AlwayOn environment I have two SQL servers 2014 Ent.edition (SERVER A, and SERVER B). I setup […]
Category: Replication
Do MySQL GTIDs get created for all transactions or just those that occur after enabling GTIDs?
Question : I have a MySQL database that I’m going to start replicating, and I plan on using GTIDs to […]
Migrating Postgres server from Windows to Linux
Question : Simple question: I want to migrate all of a Postgres server’s data, schema, roles, everything from Windows to […]
Setup MySQL Master to Master replication/automatic failover when each Master also has a Slave
Question : Thanks in advance. I have always worked with SQL Server and never really had any exposure to MySQL. […]
SQL Server replication additional subscriber
Question : I have a publisher with the distributor on the same server which is transactional replication. There is also […]
Will auto_increment always grow in master-master setup?
Question : Let’s suppose I have mysql master-master replication setup with only one server active at a time (i.e. all […]
Got fatal error 1236 Slave has more GTIDs than the master has, using the master’s SERVER_UUID
Question : We are testing replication using GTID’s on two servers running MySQL 5.6. Replication was running fine, but now […]
Add article to transactional publication without generating new snapshot
Question : Using SQL 2008 R2 transactional replication with pull subscribers, when we add an article, I’d like to avoid […]
MongoDB Partial Replication
Question : I am using MongoDB 3.0.10 with 10 databases in it, also has implemented 3 member replica Set for […]
MySQL “Statement may not be safe to log in statement format” warning
Question : What is the meaning of the following MySQL warning: Statement may not be safe to log in statement […]