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
1
vote
2 answers

Symmetricds one way setup

I am a little confused on how to setup a one way 3 tier replication using symmetricds. What I am trying to setup is something like this: The company server is not connected to the internet and as you can see it's one way, and basically the final…
1
vote
1 answer

Merge Replication fails to replicate UD type

I have a DB that includes some User Defined Types. As I understand, Merge Replication will automatically include the UD types that are been used. One of those types is a table variable witch is used in a function. And on publisher site works fine…
Manos
  • 77
  • 1
  • 10
1
vote
1 answer

SQL Server Replication not able to use proxy

I have setup a replication publication through the SSMS wizard on a 2012 SP3 CU10 SQL Server, but the replication keeps on locking out the Replication Agent account. Looking at the SQL Agent replication jobs, they are failing with Error…
Luke
  • 776
  • 9
  • 24
1
vote
0 answers

Automatic Seeding Fails in Always On Replication

I am running SQL Server Standard Edition 2016 (13.0.4001.0). I create a new database and then create an Always On Availability Group using the wizard. I set Synchronous Commit for both replicas and use Active Directory account for…
Xolve
  • 22,298
  • 21
  • 77
  • 125
1
vote
2 answers

How does Elasticsearch recover from a quorum that is not unanimous

When using replication with a quorum, Elasticsearch allows writes to fail for some (a small number of) replica shards. Writing to a replica might fail only because it is temporarily unavailable (because of a temporary network partition, for…
Raedwald
  • 46,613
  • 43
  • 151
  • 237
1
vote
1 answer

Error while trying to configure ArangoDB replication

While trying to configure an async replication on an ArangoDB database (using the document https://docs.arangodb.com/3.3/Manual/Administration/Replication/Asynchronous/Components.html) I got this error: JavaScript exception in file…
One of many
  • 547
  • 1
  • 4
  • 8
1
vote
3 answers

DynamoDB replication using Stream + Lambda

I am trying to set up DynamoDB table replication using Stream + Lambda. I was wondering how I should handle the failures. For example, I have table A and table B and I'd like to copy any update from table A to table B. I can set up a trigger using…
codereviewanskquestions
  • 13,460
  • 29
  • 98
  • 167
1
vote
1 answer

Notify from trigger on pglogical replicated table

I'm trying to setup a push-from-server functionality based on PostgreSQL, pglogical and PostgreSQL's listen-notify mechanism. On my replicated table I've setup a trigger that uses pg_notify to push messages to queue after insert. Altered the trigger…
Jacek Chmielewski
  • 1,763
  • 4
  • 16
  • 18
1
vote
1 answer

Are there any performance effects on master when using postgres streaming replication with hot_standby_feedback on

We are using postgres 10, with a setup of master and a hot standby with streaming replication. We use the standby to divide workload of read queries. We can't find information regarding how hot_standby_feedback will effect the master beside…
dor.elmaliach
  • 515
  • 5
  • 14
1
vote
2 answers

How to set Replication Factor in multi data center Datasatx cassandra

My Architecture is as follows: Two data centers DC1 and DC2 in my test cluster named Test Cluster1, DC1 has two spark nodes and DC2 has two transactional(data) nodes, that is i have 4 nodes in my cluster.Then my doubt is that is it possible to set a…
Nithin
  • 43
  • 1
  • 8
1
vote
0 answers

MySQL: Difference between "Group Replication" and "Multi-master replication"

Is there no difference? I'm now trying to decide which method to use on my project. I'm bit confused...
takumi
  • 11
  • 1
1
vote
2 answers

Unable to set Cross Region Replication on S3 bucket with SSE

I am not able to setup Cross Region Replication when the objects are server side encrypted. I am using awscli to set it up. This is what I have done. Cross region replication role IAM policy looks like this: { "Version":"2012-10-17", …
Asdfg
  • 11,362
  • 24
  • 98
  • 175
1
vote
1 answer

Cassandra Database replication to another instance

Is it possible to do Cassandra data replication into another server instance to run read only data operations on it? As we have explored SAN and it become more hardware expensive Note: I am not allowed to copy data into file and therefore. It should…
Sathish
  • 69
  • 8
1
vote
1 answer

Hadoop filesystem size du command

I want to know what the two outputs of hadoop fs -du means. It's not clear on the documentation: In [16]: subprocess.call(["hadoop", "fs", "-du","- h","/project/crm/warehouse/"]) Output: 5.9 G 17.8 G …
Carmen Pérez Carrillo
  • 1,019
  • 2
  • 12
  • 15
1
vote
2 answers

PostgreSQL - using log shipping to incrementally update a remote read-only slave

My company's website uses a PostgreSQL database. In our data center we have a master DB and a few read-only slave DB's, and we use Londiste for continuous replication between them. I would like to setup another read-only slave DB for reporting…
Shahaf
  • 413
  • 5
  • 11
1 2 3
99
100