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

Replicate Database

I want to execute proc of database 'A' from database 'B'. My situation is this that I have a database 'A' and a database 'B'. I want that when a proc is executed on database 'A' it will also execute on database 'B'. This is because the whole…
Vikas Kumar
1
vote
1 answer

Looping through several string variables. How to account for replicates?

As mentioned in a prior question (kindly answered with perfectly working syntax) I have a very large dataset of multiple diagnoses (25) per patient represented by ICD 10 codes in SPSS. For brevity sake I have posted a snapshot of what I am…
Walkeram
  • 25
  • 4
1
vote
0 answers

Frozen replication on MySQL 5.7.23 and 5.7.24

We have seen repeatedly this problem on MySQL 5.7.23 and 5.7.24. Replication is frozen on error and I cannot manually restart it using "stop slave; start slave;" MySQL runs on Debian 9 on VMs on Google compute engine and all packages are up to date.…
JosMac
  • 2,164
  • 1
  • 17
  • 23
1
vote
2 answers

SCM replication using Hudson

Here is my question: Is there any way to replicate a project from svn 'A' to svn 'b' using Hudson? Here is the context: We are working on a project using customer's SVN and we want to replicate (automatically), using SCM Hudson's polling, all the…
Samuel García
  • 2,199
  • 14
  • 21
1
vote
1 answer

Replicate index from master at specific time in Solr 7

I have a use case where we have a Solr master that is replicated to three replicas in a cluster, and is also replicated to a separate replica in Hong Kong. We were initially replicating all of them every 00:01:05, but that's too much to do at once…
wonder95
  • 3,825
  • 8
  • 45
  • 74
1
vote
0 answers

Is a single member replica set OK?

I am trying to find an authoritative answer to the following question: Is a single member replica set a supported deployment setup? While this question may seems weird or silly, my specific use case follows: A team wants to upgrade from Mongo 2 to…
Clément MATHIEU
  • 3,030
  • 23
  • 25
1
vote
2 answers

What actually gets replicated to a MySQL slave?

I have two MySQL servers configured in a multi-master replication setup. Each is a slave and master to the other. My application requires that some large queries be ran in the background, and the results of these queries would be used to populate…
Brad
  • 159,648
  • 54
  • 349
  • 530
1
vote
1 answer

mysql - my.ini server-id variable won't change

I want to set up replication on mysql. I replaced the contents of the my.ini file in the slave with the following contents: [mysqld] log-bin = mysql-bin server_id = 2 server-id = 2 innodb_flush_log_at_trx_commit = 1 sync_binlog = 1 replicate_do_db =…
1
vote
1 answer

Replication Path Cassandra NoSQL

In data replication, is it correct to claim that the time for replication is the write time on the source server plus the delay between the nodes plus the write time on the target server?
1
vote
0 answers

Inconsistency between mysql dump file and binlog

I'm trying to do a point-in-time-recovery of our production database, but when reading the binary logs after restoring the dump, I get ERROR 1062 (23000) at line x in file: 'binlogs_file.sql': Duplicate entry 'y' for key 'PRIMARY'. I've double…
Darth-Erik
  • 13
  • 3
1
vote
2 answers

what is the advantage of having Replication partition by setting STORAGE_LEVEL

What is the advantage of having Replication partition by setting the STORAGE LEVELS like MEMORY_ONLY_2, MEMORY_AND_DISK_2, etc? If we already have the HDFS replication, what is the use of having this one?
Shankar
  • 8,529
  • 26
  • 90
  • 159
1
vote
1 answer

What's the most efficient way to replicate data from Postgres (RDS) to AWS Redshift while keeping data integrity

I'm looking for an efficient way to replicate data from AWS RDS to Redshift. Based on my research, copying to s3 and loading it from there seems to be the recommended approach. However, this doesn't guarantee data integrity as it produces duplicate…
1
vote
1 answer

Complete sql synchronization using query

I would like to sync data from offline database to online database. Currently I am performing it using query with some conditions. But data that are edited in offline database after syncing will not be synced again to online in next sync. Is there…
1
vote
0 answers

Azure Database for MySQL and Azure VM replication connection error

I have provisioned a Azure Database for MySQL instance and for the purposes of debugging I have added to the rule under the connection security section as below: Name: allowAll Start IP: 0.0.0.0 End IP: 247.255.255.255 It does not allow me to…
1
vote
0 answers

MongoDB add replica-set to external server by ip

I have created 3 Digitalocean droplet. By default, I choose Ubuntu 18.06 and MongoDB 4. Here I have 3 droplets by default MongoDB config and all are up. I have access to "mongo" shell for all of them. Now I want to run a replica-set setting by this…
Abdol Seed
  • 1,227
  • 1
  • 14
  • 23