Top "Database-replication" questions

Database replication is used to ensure consistency between redundant databases and to improve reliability and increase fault-tolerance.

How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?

Mysql Server1 is running as MASTER. Mysql Server2 is running as SLAVE. Now DB replication is happening from MASTER to …

mysql database database-replication
check postgres replication status

Can someone suggest the steps to check pgsql replication status and when to say replication is not happening properly? We …

postgresql database-replication
SQL Server Update Trigger, Get Only modified fields

I am aware of COLUMNS_UPDATED, well I need some quick shortcut (if anyone has made, I am already making …

sql sql-server triggers sql-update database-replication
MongoDB replica set preventing queries to secondary

To set up the replica set, I've run in 3 separate terminal tabs: $ sudo mongod --replSet rs0 --dbpath /data/mining --port 27017 $ …

mongodb database-replication
Length of LOB data (78862) to be replicated exceeds configured maximum 65536

Here is a related question. Why do I get this error even when I have not installed SQL Server replication ? …

sql-server-2008 replication database-replication
Pause SQL server replication temporarily

We have a transactional replication setup using 3 SQL Servers, 1st as publisher, 2nd as distributor, and 3rd as subscriber. We …

sql-server sql-server-2008 replication database-replication
MongoDB shell command line authentication fails

I set up replica set with authentication. I used this tutorial. I set up keyfile, admin user and other users. …

mongodb authentication database-replication
expire_logs_days ignored in my.cnf

I've got a pair of MySQL databases that are set up for Master Slave replication. The slave is doing just …

mysql database-replication
Where can I find the file my.cnf or my.ini file?

I've read about MySQL replication and i need to change some configuration but I can't find the file my.cnf …

mysql configuration configuration-files mysql-management database-replication
filter mysql replication (ignore-db)

mysql ignore-db works according to server my.cnf AFAIK, i.e. binlog-ignore-db = mysql replicate-ignore-db = mysql I am not sure, if …

mysql database-replication