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

Does mySQL replication have immediate data consistency?

I am considering a noSQL solution for a current project, but I'm hesitant about the 'eventual consistency' clause in many of these databases. Is eventual consistency different than dealing with a mySQL database where replication lags? One solution I…
inquiring minds
  • 1,785
  • 2
  • 15
  • 16
31
votes
4 answers

JVM heap replication between two machines

What are the basic principles of how two separable computers connected within the same network running the same Java application maintain the same state by syncing their heap between each other? I believe Terracotta does this task but I have no…
MatBanik
  • 26,356
  • 39
  • 116
  • 178
31
votes
3 answers

Can you index tables differently on Master and Slave (MySQL)

Is it possible to set up different indexing on a read only slave, from on the master? Basically, this seems like it makes sense given the different requirements of the two systems, but I want to make sure it will work and not cause any problems.
Scott Miller
  • 2,298
  • 3
  • 21
  • 24
31
votes
5 answers

SQL Server 2008 replication failing with: process could not execute 'sp_replcmds'

I have an issue with SQL replication that I am having trouble fixing. What I am doing is restoring two DBs from a production backup, and then installing replication between them. The replication seems to be configured without any errors, but when…
skb
  • 30,624
  • 33
  • 94
  • 146
31
votes
7 answers

Does SQLite support replication?

In an application which embeds SQLite3 and uses an in-memory database, is it possible to replicate the database between two running instances of the application? I could do this by hand with a homebrew protocol duplicating all my DB accesses, but…
kdt
  • 27,905
  • 33
  • 92
  • 139
31
votes
4 answers

Why do we need an 'arbiter' in MongoDB replication?

Assume we setup a MongoDB replication without arbiter, If the primary is unavailable, the replica set will elect a secondary to be primary. So I think it's kind of implicit arbiter, since the replica will elect a primary automatically. So I am…
卢声远 Shengyuan Lu
  • 31,208
  • 22
  • 85
  • 130
30
votes
7 answers

RealWorld HazelCast

Does anyone have any real world experience with Hazelcast distributed data grid and execution product? How has it worked for you? It has an astonishingly simple API and functionality that seems almost to good to be true for such a simple to use…
Bob Clyde
  • 309
  • 3
  • 3
30
votes
2 answers

List all tables that are currently published for replication MS-SQL

I need to get a list of all tables that are published for replication from MS-SQL databases. Is there a system stored procedure or a query I could run to generate such a list?
user26901
25
votes
10 answers

Copying storage data from one Azure account to another

I would like to copy a very large storage container from one Azure storage account into another (which also happens to be in another subscription). I would like an opinion on the following options: Write a tool that would connect to both storage…
David Airapetyan
  • 5,301
  • 4
  • 40
  • 62
25
votes
3 answers

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 ? The strangest thing is, when I run the fix sp_configure 'max text repl size', 2147483647 Go RECONFIGURE GO it works and I no longer get this…
ram
  • 11,468
  • 16
  • 63
  • 89
25
votes
11 answers

redis slave won't sync with master

The redis slave won't sync with the master. Connectivity: I can connect to the master when I issue HOST_NAME=fakehost redis-cli -h $HOST_NAME and check the master status using a command like INFO, so connectivity is not an issue. Settings: From the…
timsabat
  • 2,208
  • 3
  • 25
  • 34
24
votes
2 answers

How to track which data block is in which data node in hadoop?

If a data block is replicated, in which data node will it be replicated to? Is there any tool to show where the replicated blocks are present?
Varshith
  • 574
  • 1
  • 5
  • 14
24
votes
3 answers

Scaling a postgres server to multiple servers

Our postgres server is about hitting its capacity and we're looking into adding a second database server. Are there any scaling solutions that are particularly good for a postgres setup?
24
votes
1 answer

Apache ZooKeeper: How do writes work

Apache ZooKeeper is a kind of high available data-store for small objects. A ZooKeeper cluster consists of some nodes which all keep the whole dataset in their memory. The dataset is called "always-consistent", so every node has the same data at…
theomega
  • 31,591
  • 21
  • 89
  • 127
24
votes
3 answers

What are the scenarios for using mirroring, log shipping, replication and clustering in SQL Server

As far as i know SQL Server provides 4 techniques for better availability. I think these are the primary usage scenarios, in summary :- 1) Replication would be primarily suited for online-offline data synchronization scenarios (laptop , mobile…
Chakra
  • 2,525
  • 8
  • 43
  • 82