Questions tagged [replication]

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.

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.

It is common to talk about active and passive replication in systems that replicate data or services. Active replication is performed by processing the same request at every replica. In passive replication, each single request is processed on a single replica and then its state is transferred to the other replicas. If at any time one master replica is designated to process all the requests, then we are talking about the primary-backup scheme (master-slave scheme) predominant in high-availability clusters. On the other side, if any replica processes a request and then distributes a new state, then this is a multi-primary scheme (called multi-master in the database field). In the multi-primary scheme, some form of distributed concurrency control must be used, such as distributed lock manager.

1036 questions
0
votes
1 answer

How to debug Hyper-V replication issues

We are hosting some VMs that are virtualized with Hyper-V. For these we have set up replication which works fine in the beginning but starts to fail pretty soon. The error it shows when looking at the replication status is: "Last successful…
0
votes
1 answer

Master DB latency with AWS RDS cross region replication

I have my app setup in 3 regions (EU, AP, US) and the master MySQL RDS resides in eu-west-1, with read replicas in the other regions. This works great for read queries, with the region specific app connecting to it's local read replica RDS very…
Ryan
  • 21
  • 2
0
votes
2 answers

AWS EC2 MySQL Replication: Config To Query Slave From Master

I have successfully set up a MySQL master-slave situation on separate AWS EC2 instances. The slave is running and is successfully replicating the master. So far so good. Now I want to be able to query the slave (for analytics, etc.) but I can't find…
0
votes
1 answer

hyperv replica multiple sites

I wanted to know if that is possible with a hyper-v replica before I start with the implementation. I have 3 sites hosting 3 stand-alone hyper-v servers (acting as primary) and I wanted to set up a single replica server for the 3 sites. all servers…
Maroon
  • 1
0
votes
1 answer

OpenLDAP replication error

I have 2 OpenLDAP servers with replication activated and everything used to work fine. A few days ago, the "replica" account's password expired. And since then I was unable to make replication work again. I tried changing password,…
fearhack
  • 1
  • 3
0
votes
1 answer

2nd lvl slave can't conect to 1st lvl slave mysql replication

Simple exercise but not working. Help me plase. Context: Lptp1, Lptp2 -> Ubuntu20.4 both Lptp1 dbmaster, Lptp2 dbslavetwo, Lptp1 dvsubslave -> all Ver 8.0.24 for Linux on x86_64 (MySQL Community Server - GPL) in dockers Configs: dbmaster…
0
votes
1 answer

keepalived delay before bringing ip up

Is it possible to configure a delay before bringing the virtual IP up in keepalived? Background: I have multiple Master/Master MySQL Setups. Only one Master is used at time. Keepalived is used for VIP that is used for mysql traffic. When the VIP is…
0
votes
1 answer

Prevention of replication in Azure blob storage

I have a ton of Azure storage accounts. I would like to prevent any of my users from replicating data to a storage account outside the subscription e.g. they can replicate to another region for the same environment but not a different account. Is…
Jackson
  • 113
  • 3
0
votes
0 answers

How does one go about using master to master replication along with something like rsync to keep two identical copies of an application identical?

I have servers that do things for me at home, for instance they keep copies of my bookmarks in the way that del.icio.us used to (nextCloud) and keep copies of my code (gitea). Initially I thought that connecting back to them at my house was the…
leeand00
  • 4,869
  • 15
  • 69
  • 110
0
votes
2 answers

Can not drop subscription, probably due to stale publication articles

I'm having trouble dropping a subscription from my replication setup. The subscriptions do not appear (in SSMS, at least) on the subscribers, but do on the publisher. When trying to drop the subscriptions via either SSMS or sp_dropsubscription, I…
Samantha Branham
  • 221
  • 3
  • 11
0
votes
1 answer

Numbers of bricks is not a multiple of replica count - glusterfs

I have 10 servers and want to use all as storage so tried to create volume with following command but its throwing error gluster volume create gv0 replica 3 server1:/data/brick1/gv0 server2:/data/brick1/gv0 server3:/data/brick1/gv0…
ImranRazaKhan
  • 150
  • 3
  • 15
0
votes
1 answer

Mysql replication, one database server process

Possible Duplicate: Mysql replication server both master slave On my development box, I want to experiment with a replication setup. But I don't want to create several mysqld processes (is it even possible?). I figured I have the main database in…
Jonny
  • 153
  • 5
0
votes
1 answer

Mixing Galera and MariaDB/MySQL replication

reading about it online, it appears we can use both Galera replication and native MariaDB/MySQL replication together. Can anyone confirm that this is correct? I'm thinking of a scenario where Data Center A has 3 Galera nodes synchronously…
0
votes
1 answer

What are the steps to re-enable replication if replica-server lost the replicated vms?

We just lost our logical drive for a few replicated VMs and couldn't restore them. Now we ran into the issue that we can't re-enable the replication process on the primary Hyper-V Host. We get the following error: [Window Title] Enable…
ptr2n0
  • 1
  • 2
0
votes
1 answer

OpenLDAP syncrepl does not recover after network interruption

We have an issue we have discovered where syncrepl does not recover after a network interruption. Environment: Centos 7 replicas OpenLDAP 2.4.44(-21.el7_6) Loglevel set to comm sync (produces nothing useful) synchronization configuration: syncrepl…
Drew
  • 83
  • 6