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
9
votes
1 answer

SQL Server Merge Replication Schedule

We're replicating a database between London and Hong Kong using SQL Server 2005 Merge replication. The replication is set to synchronise every one minute and it works just fine. There is however the option to set the synchronisation to be…
Marius
  • 2,494
  • 6
  • 31
  • 41
9
votes
1 answer

LMAX Replicator Design - How to support high availability?

LMAX Disruptor is generally implemented using the following approach: As in this example, Replicator is responsible for replicating the input events\commands to the slave nodes. Replicating across a set of nodes requires us to apply consensus…
coder_bro
  • 10,503
  • 13
  • 56
  • 88
9
votes
3 answers

mysql replication - table locking?

I am currently working for a company that has a website running mysql/php (all tables are also using the MYISAM table type). We would like to implement replication, but I have read in the mysql docs and elsewhere on the internet that this will lock…
user30410
  • 91
  • 1
  • 1
  • 2
9
votes
1 answer

MySQL Slave Warns: Configuration does not guarantee that the relay log info will be consistent after a crash

I wanted to set up a new replication slave for MySQL 5.6. Just after a CHANGE MASTER and starting the slave, I saw this line in the error log: [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will…
Raje
  • 95
  • 2
  • 6
9
votes
6 answers

mongoDB set name does not match

I have got 3 mongod demo replicates servers running on my machine. I have used following command to create replicated server: F:\>mongod --replSet test2 --dbpath 2 --port 27112 --oplogSize 50 --logpath log.2 --logappend all output going to:…
sadaf2605
  • 7,332
  • 8
  • 60
  • 103
9
votes
1 answer

Failover with mongodb

I have to setup a database that can handle failover (if one crashes the other takes over). For that, I decided to use mongodb: I set up a replica set with two instances. Each instance is running on a separate VM. I have several questions: It is…
rmonjo
  • 2,675
  • 5
  • 30
  • 37
9
votes
4 answers

How to prefer reads on secondaries in MongoDb

When using mongodb in a replica set configuration (1 arbiter, 1 primary, 2 slaves); how do I set a preference that read be performed against the secondaries and leave the primary only for writes? I'm using MongoDb 2.0.4 with Morphia. I see that…
Paul Gregoire
  • 9,715
  • 11
  • 67
  • 131
9
votes
1 answer

SQL Server 2008 transactional replication 'Missing end comment mark '*/''

I'm trying to set up transactional replication on a Dynamics NAV database on SQL Server 2008 R2 SP1. Using the same servers I have been able to set up replication successfully on a different DB. I'm able to create the publication, subscription and…
9
votes
1 answer

CouchDB - Filtered Replication - Can the speed be improved?

I have a single database (300MB & 42,924 documents) consisting of about 20 different kinds of documents from about 200 users. The documents range in size from a few bytes to many KiloBytes (150KB or so). When the server is unloaded, the following…
Colfax
  • 177
  • 2
  • 8
9
votes
2 answers

CouchDB not replicating design documents

I have a CouchDB 1.2.0 instance running on my laptop and I want to replicate a local database named "soup" to a remote machine, which runs a CouchDB 1.1.1 instance. I issue the replication from futon and I can see the request is alright: Request…
blurrcat
  • 1,278
  • 13
  • 23
9
votes
1 answer

MongoDb arbiter can be used with multiple replicaSets?

If I have different webpages for differents countries and each webpage have a mongodb replicaSet of 2-3 nodes, can I use an arbiter with more than one replicaSet so it votes in all? Or I need to initiate an arbiter per replicaSet?
Wiliam
  • 3,714
  • 7
  • 36
  • 56
8
votes
6 answers

MySQL dual master replication -- is this scenario safe?

I currently have a MySQL dual master replication (A<->B) set up and everything seems to be running swimmingly. I drew on the basic ideas from here and here. Server A is my web server (a VPS). User interaction with the application leads to…
Jake
  • 5,379
  • 6
  • 19
  • 19
8
votes
3 answers

when insert length of lob data to be replicated exceeds configured maximum 65536

I am trying to insert a value into a column of datatype image in SQL Server. I am getting the following error: Length of LOB data (70823) to be replicated exceeds configured maximum 65536. The statement has been terminated. The data length is…
gopal
  • 3,681
  • 5
  • 24
  • 25
8
votes
1 answer

Replication Framework for Mono

We are considering adopting MonoTouch and MonoDroid for building a cross platform business App. This App will handle a local database that needs to be synchronized with a master database (only one way replication). The only project remotely like…
rufo
  • 5,158
  • 2
  • 36
  • 47
8
votes
1 answer

How to disable replication_slot on postgres

Is there a method to disable a specific replication_slot? When I try to drop it I got an error because it is Active. Thanks