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

HDP's HDFS replication process really slow

I am currently working with both CDH and HDP. My CDH system's replication process works very well but HDP doesn't For example: When I set the replication factor for large directory in HDFS (20TB) to 2, HDFS need to delete 2 millions blocks When I…
Minh Ha Pham
  • 2,566
  • 2
  • 28
  • 43
1
vote
1 answer

Postgresql Logical Replication issue

I had a server set up as a subscriber to our production server using postgreSQLs new logical replication feature. It seemed to be working well, however yesterday I needed to install the postgresql10-contrib10.4-1 package. Now, for some reason the…
Jayson
  • 11
  • 2
1
vote
1 answer

best practice to replicate MySQL to a non-MySQL database via binlog

There are a bunch of tools that read the MySQL binlog, e.g. Tungsten, Maxwell, StreamSets, Debezium, Talend, Attunity, etc... They all require that binary logging is enabled in MySQL, and they read those binary logs as they're being written. That's…
Alex Woolford
  • 4,433
  • 11
  • 47
  • 80
1
vote
1 answer

What is internal implementation for Redis master-slave communication?

I want to use Redis Master-slave feature for replication between active and backup servers. But I want to know how the master-slave communication works? Because I have limitations in production, I cannot use Master-Slave configuration if Master…
suragys
  • 15
  • 5
1
vote
1 answer

Ignoring schema name on sql select?

using SQL server 2014 I am able to select without specifying the schema name when it is NOT DBO. We are now switching over to SQL 2016 and I am no longer able to select without adding the schema name? Problem: Going back into each stored proc to…
1
vote
0 answers

Python mysql replication - Missing Data

Dear Developers/community I am using mysql replication library to stream my aws RDS binlogs to redshift. Everything is working fine except one thing, I am not getting some records from a table. After investigating, I came to know that data in this…
1
vote
1 answer

How to programmatically setup an incremental mirroring service using Java / .NET

I would like to replicate / mirror a shared file system location across several mirrors. Is there any .NET / Java library to do so? or even any out of the box solution (open source prefered so we can customize it) It should be…
Eran Medan
  • 44,555
  • 61
  • 184
  • 276
1
vote
1 answer

JBoss TreeCache vs PojoCache when using invaludation rather than replication

We are setting up a Jboss cluster and we are building an own distributed cache solution built upon Jboss cache (Cant use it as 2nd level cache to ORM layer in our case). We want to use invalidation and not replication as cache mode. As far as i can…
jonash
  • 103
  • 2
  • 8
1
vote
1 answer

SQL 2005 Transactional Replication: Behavior during snapshot processing?

So, I've got SQL (2005) Transactional Replication generally working well with a single publisher and single (read-only) subscriber. Data changes and updates flow perfectly, with about 5 second latency, which is just fine. My one nagging problem,…
user61307
  • 195
  • 2
  • 14
1
vote
1 answer

Error when adding replication logreader agent with login

On attempting to add the logreader agent for SQL Server replication with the following: exec sp_addlogreader_agent @job_login = 'DANSLAB\repl_logreader' , @job_password = 'replP4ss' , @publisher_security_mode = 1 I get the following…
ScubaManDan
  • 809
  • 8
  • 22
1
vote
2 answers

mySQL Replication

We have an update process which currently takes over an hour and means that our DB is unusable during this period. If I setup up replication would this solve the problem or would the replicated DB suffer from exactly the same problem that the tables…
DD.
  • 21,498
  • 52
  • 157
  • 246
1
vote
1 answer

Can Cassandra be used to both replicate, provide a 'master' and filter data at sites?

I'm researching tech for a new project. We have a number of sites, whose data should come from a master server. Each site can only have the data on it that is relevant to the owner (company) of the site. Each site may have a number of independent…
scornflake
  • 116
  • 1
  • 7
1
vote
2 answers

SQL Replication - Does simply adding an article cause it to replicate?

I am adding SQL Replication (Transactional, single-publisher/distributor with many subscribers, using SQL 2005) to a website and have searched everywhere in the manual and on Google for this. I am curious -- do I have to actually create a snapshot…
user61307
  • 195
  • 2
  • 14
1
vote
2 answers

Invalid column name 'deletebatchsize_xact' and 'deletebatchsize_cmd'

In a sudden my SQL Replication job not synchronizing data but in the history it says all are successful. After a details check, I'm getting below message from replication properties and from 'View Synchronization Status' window. The error message…
1
vote
1 answer

Slow INSERTs from SQL Server to MySQL Linked Server

We're doing a sort of roll-your-own replication from a SQL Server 2008 R2 database to a MySQL 5.1 database. This isn't true replication, as the MySQL box is acting as permanent storage and the SQL Server is what we're forced to use as a data…
GarlicFries
  • 8,095
  • 5
  • 36
  • 53