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
0 answers

High RAM Consumption with MariaDB

People that I would like to ask a question about. I have a replica between a laptop and a server. On the server I have no problems But on the laptop ... With Time, you notice that the RAM increases ... Until you reach the limit ... When you reach…
1
vote
0 answers

Database replication is very slow on updates

We've set up a database replication about a week ago, and we are having an issue with keeping it in sync. The setup is a master-master replication with MariaDB 10.1.35/MySQL 5.5.5. Only one database is being used to make calls on. The other database…
Raaamy
  • 91
  • 8
1
vote
2 answers

PostgreSQL WAL. Is it possitble to rollback/rollforward changes in 1 concrete database?

I have server with 4 bases on in. WAL registers changes in all databases. But if i want to rollback or rollforward changes in 1 database, excluding 3 others - how is it possible?
WesternTune
  • 199
  • 1
  • 1
  • 8
1
vote
1 answer

Can SQL Server replicate TO SQL Server Compact Edition?

Can SQL Server replicate TO SQL Server Compact Edition? To put this in some relevant context, I'm considering the implications of using SQL Server CE as a near line edge cache instead of querying & caching results from our database.
Chris Marisic
  • 32,487
  • 24
  • 164
  • 258
1
vote
2 answers

svn repository, update and commit from different remote locations

In our company we have a tricky environment where people work in several countries. For performance reasons (network access) we would like to replicate our SVN repositories using the following scheme. Let's say we have French people and German…
Jerome
  • 1,225
  • 2
  • 12
  • 23
1
vote
1 answer

SQL Azure and CDN

what is the best way to limit latency for SQL Azure in global applications? My Application uses SQL Azure and would like to know based on the network location of users if its possible to connect SQL Azure near to users. So Logically would need to…
Swapnil
  • 83
  • 1
  • 5
1
vote
1 answer

What does the t in Mongodb 4 oplog mean?

I have searched far and wide for all the fields in an oplog but the information is incomplete. I understand its for a term, but what does a term mean? Here is the oplog: { "ts" : Timestamp(1533734637, 2), "t" : NumberLong(5), "h" :…
Minh Nguyen
  • 140
  • 7
1
vote
1 answer

Performance impact of using NetworkTopology with 3 node cassandra cluster in One Datacenter

We are using 3 node Cassandra cluster in one data center. For our keyspaces as suggested in best practices we are using NetworkTopology for replication strategy using the GossipingPropertyFileSnitch. For Read/Write consistency we are using as…
1
vote
1 answer

Concept of a replication-stable sortKey

I am looking for material covering this idea: Given a list-like data structure (e.g. database table) a sortKey property (column) should be introduced that reflects the desired sort order (ORDER BY sortKey) is unique within the list makes insertions…
Steve Oh
  • 1,149
  • 10
  • 18
1
vote
1 answer

How to keep tables synchronized in different database?

Problem I have a problem where I need to synchronize some tables from one legacy database to another simpler database that will be used by an external application. Attempts So I started to analyze manual techniques to perform the management of the…
1
vote
1 answer

MySQL Remote Connection (Replication)

I have the following topology. One Ubuntu 16.04. Instance on the Amazon AWS where my global MySQL Server is running. I want to use this Server as a Slave (Multi-Source Replication) for many local Master (Windows Machines MySQL Server). For Testing…
Phil Aupke
  • 13
  • 3
1
vote
0 answers

MongoDB Replica establishment running on two different kubernetes cluster on different physical host

Objective : MongoDB Replica establishment running on two different kubernetes cluster on different physical host. Host 1 : kubernetes cluster -1 : A pod is running with let say (mongo1 instance with replication set name “my-mongo-set”). Service is…
1
vote
1 answer

Can I use database names without url to start replication in CouchDB?

When I create two databases 'foo' and 'bar' and then create a document { "_id": "whatever", "source": "foo", "target": "bar" } in the _replicator database this should initiate the syncing from 'foo' to 'bar'. However, I am getting this…
abc123
  • 11
  • 1
1
vote
1 answer

what are the risks and ramifications of changing the document validation criteria in a running Couch database?

To take the simplest possible example: Start with an empty database. Add a document Add a design document with validation function that rejects everything Replicate that database. To ask a concrete question to begin with, one with an answer that I…
user8599
1
vote
2 answers

Replicating rows based on index multiplies the rows instead of replicating

I have dataframe, where i would like to replicate few rows: X Y diff No Index 1d 0.000 0.017 0.000e+00 0 2D 0.083 0.017 3.000e-03 1 3D 0.250 0.017 7.200e-03 …
Magg_rs
  • 323
  • 2
  • 3
  • 12