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

SQL Server replication error

"The identity range managed by replication is full and must be updated by a replication agent." This has started happening. We recently broke replication on purpose and don't plan to re-establish the replication. What else do I need to do to fix…
Matt Dawdy
  • 429
  • 1
  • 9
  • 19
0
votes
2 answers

How to replicate windows server 2008?

We have 2 servers let's call them server A and server B. Server B is never used unless something goes wrong with server A. I need a system that can replicate server A to server B but this doesn't have to be continues. This only has to be done once…
0
votes
2 answers

SAN Replication for Fault tolerance using EVA4400

I hope that someone would point me in the correct direction - it looks like I have no enough konwledge in the subject and timeframes are too tight for me to explore different scenarios in depth.. We have two datacenters few miles away from each…
Sergei
  • 1,226
  • 16
  • 25
0
votes
1 answer

Sequential MySQL dumps and overwriting updated data

I'm looking to do MySQL dumps on a nightly basis. I already have a solution for outputting just a diff of the data, but what I need is a way to import the data back into MySQL so the data in MySQL is UPDATED, instead of INSERTED if it's already…
aronchick
  • 695
  • 3
  • 7
  • 15
0
votes
2 answers

How to Set Intra-site Replication Delay Time (Active Directory)

Cannot configure replication delay. I have 2 domain controllers (DC1 and DC2, Windows Server 2019), both in the same site. I set the replication delay time in the Server Manager snap-in "AD Sites and Services" on DC2, but this setting does not help,…
0
votes
1 answer

How to know if an S3 bucket with Cross-Region Replication is fully replicated?

I want to setup my S3 bucket to replicate in another region. Once it's fully replicated, I will make that bucket the main one (the idea is to migrate all data from one region to another). I know how to setup cross-region replication, but my problem…
laurent
  • 179
  • 3
  • 12
0
votes
1 answer

How to know if an AWS RDS instance is fully replicated?

I setup a replica in a different region for my RDS instance. It seems to be working except that the status is always "Replicating". How can I know that the instances are fully in sync? Eventually I would like to promote the replica to master but I…
laurent
  • 179
  • 3
  • 12
0
votes
1 answer

How Object-GUID replicated

since Object-GUID is a non replicated attribute, then how All DCs have same object-GUID for an object? how object-GUID is replicated to all DC
0
votes
1 answer

How to add a new database on replication?

I have a mysql replication with two servers. There are actually 3 databases on it. On master : server-id = 1 log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 4 max_binlog_size = 1G bind-address …
0
votes
1 answer

Active Directory Replication Issue

I have 2 DCs in my lab environment. So I just wanted to check the replication status using repadmin /replsummary but it throwed me an error : 1722 The RPC server is unavailable. I forced replication using the command repadmin /syncall /AdeP. It…
0
votes
1 answer

Monitoring of MySQL replication and alerting when replication is not working

I have a question about monitoring of MySQL replication and in particular about alerting using Grafana/Prometheus. We have 2 MySQL(MariaDB to be exact) instances for which replication is configured: One Master and one Slave. They can change roles…
Dmitry
  • 11
  • 4
0
votes
1 answer

In terms of replication, can an OpenLDAP consumer act as a provider to another OpenLDAP server?

If I have an OpenLDAP server configured as a replication provider and a second OpenLDAP server configured as a consumer, can I configure the second server to act as a provider for a third OpenLDAP server? If so, is there minimum OpenLDAP version…
loris
  • 232
  • 1
  • 12
0
votes
1 answer

Why it asks me to input password here to restart db

I just have done pg_basebackup -h primary_host -p primary_port -D PGDATA -U replication user and I jsut wanted to restart the db, so I did sudo su - postgres sudo service postgres restart and the ec2 says to me Respect the privacy of others,…
0
votes
1 answer

PAM deems Kerberos password as expired

I run Kerberos / LDAP authentication in a small network for years. Kerberos is held in LDAP, which in turn is replicated to another site. Machines at the second site authenticate to the replica, the old site authenticates to the original server.…
Lars Hanke
  • 285
  • 3
  • 16
0
votes
0 answers

Problems with MySQL 8.0.29 Data Corruption, Need Upgrade Path Advice

I have a master and 3 slaves running the buggy 8.0.29 version of MySQL. Yesterday 2 of my slaves stopped synchronizing and I couldn't complete a full resync from a fresh dump because I kept getting "error 2013 lost connection to SQL server" when…