Stack Overflow
Stack Overflow

Questions tagged [database-replication]

Database replication is used to ensure consistency between redundant databases and to improve reliability and increase fault-tolerance. The replication process commonly involves continuously duplicating a "master" database to one or more additional "slave" databases.

Database replication can be used on many database management systems, usually with a master/slave relationship between the original and the copies. The master logs the updates, which then ripple through to the slaves. The slave outputs a message stating that it has received the update successfully, thus allowing the sending (and potentially re-sending until successfully applied) of subsequent updates.

1836 questions
0
votes
1 answer

Sociable SQL Server instance replication - Best practice

I would like to know what are best practices for using SQL Server replication on a SQL Server instance that may have other application databases that may also use replication. That is, our product needs to play well with other users of the…
Rob Smyth
  • 1,768
  • 11
  • 19
0
votes
0 answers

Cannot replicate CouchDB 2.0.0

Update: I can replicate from my Linux 1.6.0 db to my windows 2.0.0 db - but not the other way around or local on the 2.0.0 windows version. I am trying to replicate some couchdb databases without much success (locally or remote). I am using…
schmoopy
  • 6,419
  • 11
  • 54
  • 89
0
votes
0 answers

MongoDB 3.4 - How to add config servers to a mongos

I'm editting the config file of a mongos. And I have a replicaSet of n config servers. To balance the load among all of them, I have to write all config servers in the config file, or it's enough to add the master? sharding: configDB:…
Adrian Lopez
  • 2,601
  • 5
  • 31
  • 48
0
votes
1 answer

How can I Snapshot a database without losing undeleted data?

We have a shop floor database OPERATION that replicates selected data to a database BUSINESS that is used for reporting. The data in OPERATION is deleted daily by the third-party shop floor application so in order to retain the data on BUSINESS…
Wayne Ivory
  • 321
  • 2
  • 8
0
votes
1 answer

Can a subscriber database pull from the publisher in a replication scenario

With SQL Server 2012 or later, is it possible to set up replication in such a way that a subscriber can pull data from the publisher, instead of the publisher pushing data out to it?
Tim
  • 8,669
  • 31
  • 105
  • 183
0
votes
1 answer

Mongod slow query be happend when replicate set sync

Recently, I found that a insert op make the mongod slow query be happend. And always heppend when the secondary mongod instance syncing data from another node. The replicate set has three members and I set the client driver write concern "w :…
yangbinnnn
  • 79
  • 1
  • 8
0
votes
1 answer

Identify that a trigger in the slave has been invoked by a replicated statement

How can I detect into a trigger in my slave that it has been invoked by a replicated statement in MySQL? I've tried with USER() function, but it returns null when the trigger is activated by a replicated statement. Shouldn't it returns replication…
Aníbal
  • 785
  • 8
  • 24
0
votes
2 answers

Sizing an Azure Geo Replicated Database

If I have an S2 Sql Database, and I create a secondary geo-replicated database, should it be of the same size (S2)? I see that you get charged for the secondary DB, but the DTU's reported against that secondary are 0%, which seems to indicate that…
crichavin
  • 4,672
  • 10
  • 50
  • 95
0
votes
0 answers

SQL Pull Replication not synchronizing

I am trying to establish a pull transactional replication using SQL Server 2008 R2, I have a local DB and a Remote DB, I am using UNC file share for the snapshot. All are running with no errors, however the publisher on the remote server is…
Hasan Shouman
  • 2,162
  • 1
  • 20
  • 26
0
votes
1 answer

How to replicate VSAM files (Mainframe) to Database?

What is an efficient solution/technology (other than ETL) to do a near real-time replication of data from a VSAM file (Mainframe) to an RDBMS (outside Mainframe) ? Note: This VSAM file has COM3 data, so the replication technology should be able to…
yathirigan
  • 5,619
  • 22
  • 66
  • 104
0
votes
0 answers

extend mysqli class to try multiple servers

I have extended the mysqli database class to make query handling more efficient and it works well so far. However, sometimes my database server will go down and then basically lots of parts break. So I want to adapt my database class to connect to a…
user1914292
  • 1,586
  • 13
  • 38
0
votes
1 answer

Procedure to safely Stop and Restart Oracle Golden Gate Replication during Linux DR database server reboot

We are using Golden Gate for replication between our Primary Database server and our DR database server. We are having to shutdown our DR server for a few hours as the SAN is being retired. In this context, I am trying to figure out the sequence of…
Srini
  • 1
  • 1
  • 2
0
votes
1 answer

How to compare replication in Big Data

Problem statement - Replications are usual tasks in industry and its equally important to verify the replication, if replicated database has same data as same as the original database. Example - I have database D1 and for testing purpose I am…
Anand Chavan
  • 4,338
  • 6
  • 23
  • 27
0
votes
1 answer

why update ignore sql query have an impact on replication?

I have a trouble understanding why update ignore sql query would have an impact on replication? Could someone explain a way that I could understand instead of pointing out that it is unsafe for statement-based replication..
slopeofhope
  • 686
  • 2
  • 6
  • 21
0
votes
1 answer

Is it possible to let a write request pass by a slave directly to the master in Redis?

We need to have an in-memory key/value storage which can be replicated to other data centers. Here is our requirements: 1. All data centers must have the same database (a little resynchronization is acceptable like 30-60 seconds). I know that we can…
Oleksandr
  • 3,574
  • 8
  • 41
  • 78
1 2 3
…
99 100