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

SQL Replication alternative?

Hey, I have a big database in sql server 2005, and since it´s so big I need to replicate it to other sever. I set up sql replication publisher and subscriptor but it doesn´t behave in a stable way. It´s not replicating for every insert and it´s not…
Ragalante
  • 341
  • 2
  • 5
  • 13
1
vote
1 answer

Bootstrap for Confidence Intervals

My problem is as follows: Firstly, I have to create 1000 bootstrap samples of size 100 of a "theta hat". I have a random variable X which follows a scaled t_5-distribution. The following code creates 1000 bootstrap samples of theta…
1
vote
1 answer

When does a leader ACKs client in DistributedLog?

I'm having difficulty to understand when does a leader actually ACKs client. Here is part of a DistributedLog documentation: Each batched entry appended to a log segment will be assigned a monotonically increasing entry id by the log segment…
Majid Azimi
  • 5,575
  • 13
  • 64
  • 113
1
vote
0 answers

is django db able to have a secondary db set as back up? django

What I am trying to say is, I have two database and they are replicates. Is it possible for django to have settings that if first (primary db) is down / cannot be connected then connect to the second one until the first one is back up? I believe…
Dora
  • 6,776
  • 14
  • 51
  • 99
1
vote
1 answer

SQL Transactional Replication - Removing Articles

I have a transactional replication setup between database 'A' and 'B'. If I remove articles from the publication, and save the changes, will this immediately get reflected to all current subscribers?
Randy Minder
  • 47,200
  • 49
  • 204
  • 358
1
vote
0 answers

Can mongodb report failover status?

I have 3-node Replica Set in MongoDB. Is there any possibility to configure it to automatically run a shell script when failover happens or one of nodes goes down? I believe this is not a role of database but maybe there are some mongo plugins/tools…
zmija
  • 11
  • 2
1
vote
1 answer

Replicate Remote DB Mysql

I´m following this tutorial (http://www.linux-party.com/42-mysql/8628-como-replicar-una-de-base-de-datos-de-mysql-2-de-2).. When I configure slave (my.cnf) with this…
Andres Zambrano
  • 23
  • 1
  • 10
1
vote
0 answers

Performance impact of HDFS dfs.replication factor

I have few questions over hdfs replication factor. There is a Hadoop cluster in which the replication factor is set to the default value 3. We have some issues with disk space so some guys suggested to reduce the replication factor to 2. Does this…
thanuja
  • 546
  • 1
  • 8
  • 22
1
vote
2 answers

Run procedure after replication finish

I have 2 dbs and use replication between them to replicate one schema. (Oracle Streams) Is it possible to add on one table trigger or smthing like this to be invoked after new data added in remote db (better for each row)? I try triggers on update…
den bardadym
  • 2,747
  • 3
  • 25
  • 27
1
vote
0 answers

How to do the MySQL master-master replication with conflict resolution,auto sync after fail over

We have a business requirement in that, We need to do the MySQL Master-Master replication by solving the below possible issues. Conflict resolution Auto sync after MySQL server failure Here, We are going to write the data in both the Master MySQL…
1
vote
0 answers

Snapshot Agent access is denied to ReplData folder

I am setting up replication and am receiving the following error Message: Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\ReplData\unc' is denied. I have set up the repl_snapshot agent and it has full access to…
1
vote
0 answers

What might be causing MySQL replication error 1594 (Relay log read failure, corrupted logs)?

I have 3 similar master-slave replication setups and only 1 of them fails daily, sometimes a couple times a day. Every time it's slave's relay log that is corrupted. So all it takes to recover is to reset slave and run again. Internet is full off…
1
vote
2 answers

Google Cloud MySQL and Master-master replication

I have two servers in different regions (eu, us) connected to the same mysql database, I've started with google cloud sql second generation but it's only available on us region. The idea is to add a second sql nodes in the new region eu but I can't…
1
vote
0 answers

How replicate-ignore-db OR replicate-ignore-table works internally?

In MySQL replication we have replication filters: replicate-ignore-db replicate-ignore-table These filters are used to ignore the database / table to replication on slave server. During the creation of relay log, slave server check the rules and…
1
vote
1 answer

Mongodb - Can I use one arbiter for many replica sets?

Simple question, can I reuse one dedicated arbiter machine for many replica sets, or do I need one arbiter machine per replica set. This is significant because in the worst-case scenario I will need one arbiter per shard, which could get…
mils
  • 1,878
  • 2
  • 21
  • 42
1 2 3
99
100