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

What's the cleanest way to reversibly break SQL Server replication?

I'm playing around with SQL Server Agent alerts, hoping that I can get some reliable error notifications sent out when our transactional replication breaks. To test it however, I need to break it. I have a subscription that's safe to break, but I…
Samantha Branham
  • 221
  • 3
  • 11
4
votes
1 answer

MySQL slave server restart

What's the secure/proper way of restarting the MySQl slave server. I need to reboot the machine in order to update the kernel and apply some configuration changes. I've tested it on my lab and unfortunately it didn't work properly: I powered down…
HTF
  • 3,148
  • 14
  • 52
  • 82
4
votes
2 answers

Possible to make mysql server both master and slave?

I am getting ready to move a database from one server to another. In order to reduce downtime for the client, I am wondering if it would be possible for me to turn on replication and give it time to replicate fully, then just point the customer to…
4
votes
3 answers

Converting our budget-strapped dev environment to ESXi - how to maximize availability on the cheap

We've already run through the process of virtualizing our production servers and now we want to do the same with our dev environment. However, our provider took care of all of the ESX host and cluster configuration (SAN, physical switches, host…
tacos_tacos_tacos
  • 3,250
  • 18
  • 63
  • 100
4
votes
1 answer

Adding a new location through Active Directory. How should it be done?

Our entire Active Directory forest is currently on a single 10/8 private subnet. We're looking to migrate most of our servers to a cloud provider, but I'm not sure how to set up the first domain controller in the new cloud location. I've read a lot…
4
votes
2 answers

Safe initial sync for SQL Server OLEDB/ODBC Replication

I am trying to setup one-way, transactional replication from SQL Server 2008 R2 to PostgreSQL 9.1. I'm trying out the PGNP OLE DB provider. I can successfully create a subscription, and transactions are indeed replicated to the PG server. I am using…
MichaelGG
  • 1,739
  • 8
  • 25
  • 30
4
votes
6 answers

Oracle real time database mirroring

Does Oracle have any built-in features to support a master-slave mirroring mechanism ? I am looking to mirror/replicate the production server on to a read-only database. The read-only database would be used for reporting and such purposes. We are…
Sathya
  • 157
  • 1
  • 1
  • 6
4
votes
3 answers

multi-master replicated dynamic dns subdomains

For lack of a better title. Our environment requires having subdomains where we allow dynamic updates using bind as the DNS server and its nsupdate utility authenticating via keyfiles. We're looking to make this more redundant. Currently we have…
sbr9132
  • 61
  • 1
  • 3
4
votes
2 answers

Multiple VPS with mirrored database and filesystem

I've developed interest in VPS clusters lately and it seemed like a great idea to try to set up a multi-VPS setup, which I will describe below. It isn't really meant for production use, but more as an experiment to improve relevant skills and…
zatatatata
  • 91
  • 1
  • 4
4
votes
2 answers

SAN replication

My company has only a single storage box (SuperMicro hardware + chassis with a LSI raid card and 12 SAS 7.2k drive) in its current setup. It runs on linux and we hook it up to our fileserver via iSCSI. We can't afford a high-end SAN. While it has…
gostan
  • 53
  • 1
  • 3
4
votes
6 answers

Need help with estimating required bandwidth for SAN array to SAN array replication over WAN

I have a long-term goal of setting up a DR site in a colo somewhere and part of that plan includes replicating some volumes of my EqualLogic SAN. I'm having a bit of a difficult time doing this because I don't know if my method is sound. This post…
4
votes
1 answer

mysql replication over long distance - many tcp/ip reconnects

We are doing offsite mysql replication over long distance and limited bandwidth - latency of about 200ms and about 70KB/s (max). The replication works sporadically, transferring several tens of kilobytes and then reconnecting. I have traced the…
Arie Skliarouk
  • 608
  • 1
  • 6
  • 12
4
votes
3 answers

Automated failover strategy for master-slave Mysql replication - why would this not work?

I'd like some feedback about this failover strategy for a couple of MySQL servers I'm speccing up for a cluster, and I want to check if there's something obvious I'm not missing here. One app server that connects to a mysql master server in day to…
Chris Adams
  • 709
  • 3
  • 11
  • 18
4
votes
2 answers

DFS-R Event ID 4412 The DFS Replication service detected that a file was changed on multiple servers

To prepare DFS replication, we used robocopy /DATSOU... to copy the contents of a shared folder (~170G) to another server. After that, a DFS replication group was configured with the two folders. Now after some hour we get tons of 4412 errors…
MaxHQ
  • 43
  • 1
  • 4
4
votes
3 answers

How to: Hot Standby SQL Server in another datacenter?

For our SaaS app, I want to have a system in place for a datacenter wide failure. In the main datacentre, we have two servers set up with MSSQL Database Mirroring (synchronised). This provides us with a good enough high availability solution for…