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
11
votes
2 answers

MongoDB as windows service and setting up replicaSet

I have installed MongoDB and its set up as windows service. When I try to set up replicaSet I am getting error "Only one usage of each socket address (protocol/network address/port) is normally permitted. for socket: 0.0.0.0:27017". So, I have…
jmrio
  • 133
  • 1
  • 2
  • 8
11
votes
3 answers

How does MongoDB do both sharding and replication at the same time?

For scaling/failover mongodb uses a “replica set” where there is a primary and one or more secondary servers. Primary is used for writes. Secondaries are used for reads. This is pretty much master slave pattern used in SQL programming. If the…
alex sundukovskiy
  • 483
  • 1
  • 7
  • 19
11
votes
4 answers

What's the difference between peer-to-peer and merge replication with SQL Server?

What's the difference between peer-to-peer replication and merge replication using SQL Server?
Guy
  • 65,082
  • 97
  • 254
  • 325
11
votes
1 answer

Why is the word "entropy" present in anti-entropy protocols?

Anti-entropy protocols are a form of gossip protocols. http://en.wikipedia.org/wiki/Gossip_protocol. I was wondering if someone could explain, the the significance of word entropy here.
11
votes
5 answers

synchronize two pg databases

I have a postgresql server process each running in my desktop and the laptop. Both servers have a database called MG with exactly same scheme/layout. Now I enter the data in to similar tables but at differing times. I generally keep the primary keys…
yjfuk
  • 1,415
  • 4
  • 13
  • 12
10
votes
2 answers

Methods to Verify Cassandra Node Sync

I have a 3 node Cassandra cluster with replication factor of 2. Because one of the nodes has been replaced with a new one. And I have used "nodetool repair" to repair all the keyspaces. But don't know how to verify that all the keyspaces are…
stephon
  • 103
  • 1
  • 1
  • 5
10
votes
3 answers

How to ensure MySQL replication SLAVE is fully synchronized with the replication MASTER?

Using simple replication settings with one MASTER and one SLAVE, how can one ensure that the SLAVE and MASTER are fully synchronized? Now yes, they both started from the exact same image and replication is working and reporting that everything is…
Collector
  • 2,034
  • 4
  • 22
  • 39
10
votes
2 answers

MySQL replication for fallback scenario

When I have two mysql servers that have different jobs (holding different databases) but want to be able to use one of them to slip in when the other one fails, what would you suggest how I keep the data on both of them equal "close to realtime"?…
BlaM
  • 28,465
  • 32
  • 91
  • 105
10
votes
2 answers

SQL Server script to remove replication?

I have been asked to write a SQL script that can be run, which will stop replication and remove the subscriber/subscription. Is this at all possible? Or do you have to use the GUI?
Craig
  • 18,074
  • 38
  • 147
  • 248
10
votes
8 answers

SQL Replication "Row Not Found" Error

I have transactional replication running between two databases. I fear they have fallen slightly out of sync, but I don't know which records are affected. If I knew, I could fix it manually on the subscriber side. SQL Server is giving me this…
jeremcc
  • 8,633
  • 11
  • 45
  • 55
10
votes
3 answers

mongodb single DB replication

I've a working MongoDB "replica set" made up by 3 servers. It is storing two DBs, I wonder if is it possible to replicate only one of the DBs without running more than one mongoDB instance(one per DB). Here is a sketch of the "problem" Server1…
Lopoc
  • 1,308
  • 5
  • 16
  • 26
10
votes
2 answers

Postgresql replication: londiste vs. slony

Has anyone had much experience using londiste? It is an alternative to slony for postgres replication. I have been beating my head against the wall trying to get slony to work the way I need it and was looking for any easier way. londiste seems…
Eric Snow
  • 1,198
  • 8
  • 21
10
votes
2 answers

Embedded couchDB

CouchDB is great, I like its p2p replication functionality, but it's a bit larger(because we have to install Erlang) and slower when used in desktop application. As I tested in intel duo core cpu, 12 seconds to load 10000 docs 10 seconds to insert…
Chang
  • 3,953
  • 2
  • 30
  • 43
10
votes
4 answers

Repository has not been enabled to accept revision propchanges; ask the administrator to create a pre-revprop-change hook

HI I am trying to mirroring my repository with another server/machine repository I have two different machine(window) at two different server.at one machine I have already a SVN repository(source repository) and I want to mirror this repository with…
Rakesh Bhagat
  • 397
  • 2
  • 5
  • 22
10
votes
2 answers

What connection string to use for Azure SQL DB using Active Geo Replication?

I have a database in SQL Azure which is being actively replicated to 2 different regions. They are both read-only accessible (tested from SQL management studio by connecting to their respective servers) but what connection string do I need to use…
IvanL
  • 2,475
  • 1
  • 26
  • 39