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

Is it safe to set MySQL isolation to “Read Uncommitted” (dirty reads) for typical Web usage? Even with replication?

I'm working on a website with typical CRUD web usage pattern: similar to blogs or forums where users create/update contents and other users read the content. Seems like it's OK to set the database's isolation level to "Read Uncommitted" (dirty…
Continuation
  • 12,722
  • 20
  • 82
  • 106
8
votes
3 answers

Is it possible to have a Heroku Postgres DB replicate down to a slave DB on my laptop?

I'd like to have my master Postgres DB, which is is hosted on Heroku, replicate down to a slave DB on my laptop. Is this possible? Heroku's documentation talks about both master and slave hosted within…
Shahaf
  • 413
  • 5
  • 11
8
votes
2 answers

How do I configure Solr replication with multiple cores

I have Solr running with multiple cores. Because of the heavy load, I want to set up a slave containing the exact same indexes. The documentation http://wiki.apache.org/solr/SolrReplication states "Add the replication request handler to…
DionS
  • 125
  • 2
  • 6
8
votes
5 answers

Database replication. 2 servers, Master database and the 2nd is read-only

Say you have 2 database servers, one database is the 'master' database where all write operations are performed, it is treated as the 'real/original' database. The other server's database is to be a mirror copy of the master database (slave?),…
public static
  • 12,702
  • 26
  • 66
  • 86
8
votes
3 answers

MySQL replication not running updates in binlog

I have a number mysql servers running version 5.1.63 and whilst running some queries against the slave earlier this week, I noticed some data on the slave that should have been removed using an update statement on the master. My initial thoughts…
8
votes
3 answers

How does Replication work in a Distributed Database

I would like to know how replication works in a distributed database. It would be nice if this could be explained in a thorough, yet easy to understand way. It would also be nice if you could make a comparison between distributed transactions and…
8
votes
2 answers

what is the best way to replicate database for SSRS

I have installed SQL server database (mainserver) in one instance and SQL server database for RerportServer in others. what is the best way to replicate data from mainServer to report Server? Data in mainServer changes frequently and actual…
loviji
  • 12,620
  • 17
  • 63
  • 94
7
votes
0 answers

Postgres 9.1 Replication vs MySQL Replication

Since Postgres now has built-in replication/clustering/HA support, how does it compare to the built-in features and functionality of MySQL replication/clustering/HA? What are the PRO/CONs of Postgres vs MySQL related strictly to…
nickb
  • 9,140
  • 11
  • 39
  • 48
7
votes
1 answer

SQL Server Replication not replicating Foreign Keys

I am replicating several tables to a database on the same server as the source database. Those tables have several foreign keys between them. When I look at the replicated tables, they do not have the foreign keys on them. So, here are my…
Vaccano
  • 78,325
  • 149
  • 468
  • 850
7
votes
3 answers

Is it possible to get sub-1-second latency with transactional replication?

Our database architecture consists of two Sql Server 2005 servers each with an instance of the same database structure: one for all reads, and one for all writes. We use transactional replication to keep the read database up-to-date. The two…
Paul Suart
  • 6,505
  • 7
  • 44
  • 65
7
votes
4 answers

What happens during Server to server replication if reader access is revoked

I would like to understand what happens in the following Lotus-Domino server to server replication scenario: Server A has a replica of A database. Server B has a replica of the same database. Both servers have manager access on the database,…
Jasper Duizendstra
  • 2,587
  • 1
  • 21
  • 32
7
votes
3 answers

Transactions and Master + Slave Replication

I'm looking to clear up a bit of confusion. I have a master + slaves setup. I have one master, and 3 slaves. All writes (INSERT|UPDATE|DELETE) go the master. All reads (SELECT) go to one of the slaves, which is chosen at random. All of my tables are…
mellowsoon
  • 22,273
  • 19
  • 57
  • 75
7
votes
1 answer

Redis wants to replicate with an unknown IP address

I developed a small application with a Redis datastore. I encounter no problems on my development machine. The application is built using docker images and defined in a docker-compose yml file. I have deployed the project to a VPS. The environment…
erik404
  • 595
  • 1
  • 6
  • 22
7
votes
2 answers

SQL Server 2005 Transactional Replication Fails to Publish Stored Procedure Containing an Index Create

I've experienced a bizarre problem with a SQL Server 2005 Transactional Publication. The issue is this: If the publication contains an article that is a stored procedure that contains a create index statement, then there is an error thrown when…
7
votes
1 answer

AWS MySQL RDS fail over - replication lag handling?

In normal MySQL replication setup that when a primary is having an issue, chances are, the slave are lag behind and didn't have the latest data. In AWS RDS when a slave is being automatically promoted to master, questions: Is the lagged data…
Ryan
  • 10,041
  • 27
  • 91
  • 156