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
6
votes
2 answers

SQL Server Failover strategies

In my infrastructure I have a SQL Server 2014 Standard standalone server. As databases and applications which are using SQL Server are growing up, I want to upgrade to SQL Server 2016 Standard and install two nodes to get an highly available SQL…
Mat
  • 1,873
  • 7
  • 25
  • 41
6
votes
1 answer

Active Directory replication target principal name incorrect

I have a small 2 DC domain using Win 2008 R2 machines. Recently, one had to be restored using backup exec system recovery. Now the two are failing replication. I have ran DCDIAG on both (see below) and see that several things fail with target…
6
votes
3 answers

Mongo secondaries stuck at startup state

I have a MongoDB replica set with secondaries that won't make it past the STARTUP state. The database is large but they should have moved to STARTUP2 by now. The correct ports are open as I can connect to the secondaries from the primary and…
Cris McLaughlin
  • 161
  • 1
  • 3
6
votes
1 answer

How can I set up an Amazon RDS for PostgreSQL database to act as a replica to a non-RDS PostgreSQL database?

I'm trying to set up an PostgreSQL database on Amazon RDS as a replica to another PostgreSQL database that lives on a regular server. Most of the instructions I've found online require shell access so that you can copy over a bunch of data files…
Dan Loewenherz
  • 913
  • 3
  • 10
  • 19
6
votes
1 answer

DFSr detected that a file was changed on multiple servers, but "winning" file and that moved to conflicts folder have same hash

We've just deployed a new DFS replication system between two Windows 2012 R2 servers. We cloned the DFSr database using MS's recommendations…
obrienmd
  • 261
  • 2
  • 5
6
votes
2 answers

How can I save a domain controller after a USN rollback without rebuilding the whole server?

Today I had (again...) to lobotomize a domain controller which had suffered the dreaded USN rollback; the standard solution to this issue is to demote it and then promote it back again, but the main problem is, the demote isn't going to work,…
Massimo
  • 70,200
  • 57
  • 200
  • 323
6
votes
9 answers

Make identical copy of Centos

I have a CENTOS server running and i want to make identical copy of it(all software,users), like twin server for mirroring purposes. how do i do that?
Good
  • 63
  • 1
  • 1
  • 3
6
votes
1 answer

Replication of lockoutTime attribute is not urgent on AD-LDS

I have two LDS servers on the same subnet. They replicate well. If I change an attribute, it gets replicated after 15 seconds. LDS is configured to honor password policies. When a user makes too many wrong password attemps, his account is locked…
ixe013
  • 1,018
  • 2
  • 10
  • 26
6
votes
4 answers

Testing MySQL Database Replication / Synchronization

I'm setting up a MySQL Master database which replicates to a few Slave databases. My question is what are the best practices to monitor and / or test that the slave databases are up-to-date, and that would alert an admin when there is an error…
6
votes
4 answers

How can I rebuilt MySQL replication without dumping the master?

Our MySQL database has grown fairly large, and I am running with master replication. Replication is broken. I am trying to rebuild the second master without freezing up the first master in doing a mysqldump. The database is big enough that the dump…
Chris Edwards
  • 161
  • 1
  • 3
6
votes
3 answers

MySQL to PostgreSQL replication

Is there way to replicate in near-realtime MySQL changes to equal PostgreSQL database?
datacompboy
  • 663
  • 2
  • 7
  • 16
6
votes
2 answers

DFS-R alternatives?

I was wondering what alternatives to DFS-R are out there on windows machines for real-time bidirectional file & folder replication? DFS-R requires active directory and a domain controller which I don't want utilize in this particular…
TJF
  • 391
  • 1
  • 6
  • 15
6
votes
2 answers

Way to avoid server downtime when creating Master - Slave relationship?

I am preparing for setting up a MySQL master-slave or master-master relationship. Right now I have a single MySQL production server, and of course I don't want a lot of downtime while I connect the slave. Is there no way I can make connect an empty…
Prof. Falken
  • 302
  • 7
  • 17
6
votes
1 answer

Replacement for MySQL proxy

We have a standard MySQL Master/Slave replication for our database. In order to use the slave server we have set up MySQL Proxy. However we have been strongly discouraged to use it as it still alpha and not very well supported. Our application is…
tostinni
  • 161
  • 1
6
votes
2 answers

Mysql master-master not replicating

I'm setting up a master-master mysql replication on two servers (db1 and db2). I started with setting up db2 as a slave to db1 and that works fine. But when I set up db1 as a slave to db2 it isn't replicating. On the face of it everything looks fine…
sorohan
  • 193
  • 6