Question : I have a set of database with merge replicate configured between them. The publisher is an aggregate of […]
Tag: replication
MySQL Bug required remedy : [Warning] Invalid (old?) table or database name ‘#sql-‘
Question : We have a master & multiple slave replication in our production environment. At first, I found this error […]
Rows already DELETEd on MySQL slave; How to DELETE on master?
Question : I have a handful of rows that exist in my MySQL master but not in my slave. Replication […]
Performing frequent backups of a large MySQL slave
Question : We replicate our production MySQL databases (120 GB on production) to a dedicated local desktop machine. The local […]
Mitigating MySQL replication delay in single master/multiple slave setup
Question : For a particular web application that requires high availability I am thinking of scaling out by setting-up MySQL […]
SQL Server 2016 replication between Windows 10 and Windows Server 2012
Question : I’ve been asked to set up SQL Server 2016 replication between a development PC running Windows 10 Home […]
MongoDB: Replica Set – master vs. slave
Question : We think about moving from a master-slaves to MongoDB with replica-set. Now I wonder if MongoDB replicas are […]
“The slave is lagging behind”-mystery
Question : I have a testing scenario with one dedicated server (6 vCore x 3.6 GHz AMD Ryzen 5 Pro […]
MySQL replication constantly checking tables
Question : I recently moved one of our slave databases to a new server, the database is purely used for […]
Postgresql failback without resync the data directory
Question : Im using Master slave streaming replication in PostgreSQL. Repmgr is configured to handle automatic failover. Once the failover […]