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

Is MySQL replication possible with different versions of MySQL

Should MySQL slave have the same version or higher than Master for replication to work properly?
Kourosh Samia
  • 321
  • 1
  • 5
  • 12
5
votes
1 answer

How do I remove Slony from a restored PostgreSQL database?

I've restored a database which came from a server on which Slony was running. The server on which the database has been restored does not have Slony installed. When the database restored, there were a lot of errors reported, with Slony related…
Scott Herbert
  • 586
  • 1
  • 6
  • 13
5
votes
1 answer

Replication from OSX OpenDirectory to OpenLDAP

I have an OpenDirectory server running on an OSX Server machine, and I'd like to increase the reliability of the service by having a slave server. The problem is, I only have 1 OSX Server but I have plenty of Linux servers available. I'm happy with…
natacado
  • 3,367
  • 29
  • 27
5
votes
2 answers

MySQL says replication is fine but data is not copied

The setup The setup is very simple and straightforward. It's a pair of Debian servers with a Gigabit link in between. MySQL is stable Debian Lenny version and OS is Debian Lenny. Configuration The dump has been inserted on both nodes and replication…
Antoine Benkemoun
  • 7,314
  • 3
  • 42
  • 60
5
votes
8 answers

File replication on linux?

I would like to have 2 identicals web servers : one master and one slave. File newly modified/create on the master should be replicated at once on the slave (in the minute). I do not want to use rsync because it scans all the files to calculate the…
Eric
  • 229
  • 4
  • 15
5
votes
1 answer

why use mixed-based replication for mysql

I am in the process of configuring MySQL replication and am intending to use row-based-replication but I was also reading up about mixed-based replication. This is where statement-based is the default and then for certain circumstances…
Alistair Prestidge
  • 806
  • 1
  • 7
  • 19
5
votes
1 answer

Which SQL Server edition?

We need a new install of windows server and sql server to replicate a couple of databases to a geographically separate location from an existing application (over a site-to-site VPN). The source database is SQL Server 2005. However, this is a…
StaringSkyward
  • 115
  • 2
  • 4
5
votes
3 answers

Is real-time or synchronous replication possible over WAN link?

The company I work for is looking to implement truly real-time file replication with file locking over a WAN link that spans over 2000 miles. We currently have a 16-drive SAN setup in our east coast office. We also have an office out in Colorado…
4
votes
1 answer

Design Replication between 2 Always On Groups in SQL Server 2012

I am using MS SQL Server 2012 version. I have 2 Always on groups, 1 in DC and another in DR. How can set up replication between a database with in DC and DR. I studied that the Distributed Always on Availability Group is available only from 2016…
4
votes
0 answers

Copy nginx cache between two servers

I have a nginx caching server with at least 2tb of cache files at any moment, i need to migrate this server to another hosting provider but none of my clients can handle that traffic without cache. At my first try, just copying the cache object to…
4
votes
0 answers

IIS Content and Configuration Sync

We have a Web Farm with IIS 7.5 that has a 3rd party application that syncs IIS Content and Configuration. We used this back in IIS 6 days, when there were no tools in the OS that handled this easily. The software is nice, but it has become…
Chris
  • 41
  • 2
4
votes
1 answer

Migrate SQL 2008 database to Azure

I am migrating a SQL server 2008 R2 production database to Azure SQL database service in the cloud. Is it possible to mirror/replicate the Azure database from the 2008 R2 database? So I can just switch over to just using the new one. Instead of…
Andreas
  • 309
  • 1
  • 5
  • 17
4
votes
1 answer

How to lower AD inter-site replication interval below 15 minutes?

When configuring Active Directory inter-site replication, there is a lower limit of 15 minutes for the replication interval; or at least, this limit is enforced by the AD Sites & Services console. Is there any way to configure the inter-site…
Massimo
  • 70,200
  • 57
  • 200
  • 323
4
votes
1 answer

How to do storage replication on Windows Server 2012 R2 in a lab?

I want to mock up an architecture for a proof-of-concept and need to synchronously replicate a volume from one Windows Server 2012 R2 to another. Can anyone suggest a (ideally free) way to do this in a lab environment? I just want to mock up some…
Mark Allison
  • 2,188
  • 7
  • 26
  • 45
4
votes
1 answer

How do i measure redis replication delay?

Which of these can be considered to monitor replication delay ? Redis_master_repl_offset, Redis_master_last_io_seconds_ago , Redis_slave_repl_offset
karan sindwani
  • 53
  • 1
  • 1
  • 7