Questions tagged [replication]

The use of redundant resources to improve reliability, fault-tolerance, or performance.

Replication is the process of sharing information so as to ensure consistency between redundant resources, such as software or hardware components, to improve reliability, fault-tolerance, or accessibility.

It could be data replication if the same data is stored on multiple storage devices, or computation replication if the same computing task is executed many times.

A computational task is typically replicated in space, i.e. executed on separate devices, or it could be replicated in time, if it is executed repeatedly on a single device.

The access to a replicated entity is typically uniform with access to a single, non-replicated entity. The replication itself should be transparent to an external user. Also, in a failure scenario, a failover of replicas is hidden as much as possible.

More info on Wikipedia

3869 questions
13
votes
1 answer

Microsoft Sync Framework Or Replication

What is deference between Microsoft Sync Framework and Replication? which one is better?
masoud ramezani
  • 22,228
  • 29
  • 98
  • 151
13
votes
6 answers

How to get master-master replication with Subversion?

Seems like a simple problem: I have an SVN repo inside our firewall. I have an SVN repo outside our firewall. I have users inside, and outside, the firewall. (no VPN isn't an option :( that'd be too easy) machines inside the firewall CAN talk to…
Nic Wise
  • 8,061
  • 2
  • 31
  • 30
13
votes
10 answers

Which database has the best support for replication

I have a fairly good feel for what MySQL replication can do. I'm wondering what other databases support replication, and how they compare to MySQL and others? Some questions I would have are: Is replication built in, or an add-on/plugin? How does…
nathan
  • 4,571
  • 2
  • 27
  • 28
12
votes
2 answers

Replication of AWS RDS Postgresql into On-Premise Postgresql

I have a requirement of replicate data from AWS RDS Postgres(9.6) Database to On-Premise Postgres(9.5) Database. I have found stuff about replication from On-premise to On-premise. But How can we implement it for AWS RDS to On-premise?
YogeshR
  • 1,606
  • 2
  • 22
  • 43
12
votes
6 answers

T-SQL Query for Replication Articles

Does anyone know of a query I could run that would tell me what articles, if any, in a target database, are associated with a transactional replication publication?
Randy Minder
  • 47,200
  • 49
  • 204
  • 358
12
votes
8 answers

Is Guid the best identity datatype for Databases?

It is connected to BI and merging of data from different data sources and would make that process more smooth. And is there an optimal migration strategy from a database without Guids to a version with Guids without information losses?
bovium
  • 2,869
  • 6
  • 25
  • 35
12
votes
1 answer

Problems In Doing MySQL Row-Based Replication By Myself

I am trying using MySQL Replication Listener Library to do data replication between HostA and HostB. The replication is based on row-based other than statements. I know there is such built-in feature in MySQL itself, but I want to do it myself ---…
Wallace
  • 561
  • 2
  • 21
  • 54
12
votes
6 answers

MySQL Binary Log Replication: Can it be set to ignore errors?

I'm running a master-slave MySQL binary log replication system (phew!) that, for some data, is not in sync (meaning, the master holds more data than the slave). But the slave stops very frequently on the slightest MySQL error, can this be disabled?…
mauriciopastrana
  • 5,010
  • 7
  • 35
  • 36
12
votes
5 answers

Difference between Sharding And Replication on MongoDB

I am just confuse about the Sharding and Replication that how they works..According to Definition Replication: A replica set in MongoDB is a group of mongod processes that maintain the same data set. Sharding: Sharding is a method for storing data…
Saad Saadi
  • 1,031
  • 10
  • 26
12
votes
3 answers

Replicate selected postgresql tables between two servers?

What would be the best way to replicate individual DB tables from a Master postgresql server to a slave machine? It can be done with cron+rsync, or with whatever postgresql might have build in, or some sort of OSS tool, but so far the postgres docs…
Michael Guthrie
  • 512
  • 1
  • 4
  • 11
11
votes
5 answers

Are there any frameworks to synchronize data generated on one peer with all other peers in an unreliable network?

We are developing a system with the following requirements. There are N systems that each generate data that is unique to themselves Each system requires the data from every other system to perform its end goal These systems are talking to each…
Justin Breitfeller
  • 13,737
  • 4
  • 39
  • 47
11
votes
7 answers

PostgreSQL replication strategies

Right now we are using PostgreSQL 8.3 (on Linux) as a database backend to our Ruby on Rails web application. Considering that on PostgreSQL database we actively use row level blocking and PL/PGSQL, what can we employ to secure our data -- I mean…
user52873
  • 121
  • 1
  • 2
  • 6
11
votes
2 answers

Why does Master think it's a Slave on Reboot?

In a simple MySQL replication Master-Slave configuration I have a problem where Master tries to connect to itself as a slave on reboot. So when I restart MySQL on Master, I see errors related to the same server trying to replicate to itself and I…
Ryan
  • 14,682
  • 32
  • 106
  • 179
11
votes
1 answer

CouchDB conflict resolution

How does CouchDB handles conflicts while doing bi-directional replication? For example: Lets say there are two address book databases (in server A and B). There is a document for Jack which contains contact details of Jack. Server A and B are…
Sundar
  • 1,204
  • 1
  • 14
  • 17
11
votes
2 answers

In PostgreSQL 9.2, is archiving required for streaming replication?

Is it allowed and/or reasonable to configure a master PostgreSQL 9.2 server to NOT archive but to perform streaming replication. That is configured as shown below: wal_level = hot_standby archive_mode = off Can the "slave" server (hot standby), be…
Dwayne Towell
  • 8,154
  • 4
  • 36
  • 49