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

Windows Server 2008 - AD Replication

I have 3 Windows Server 2008 servers. Here's the breakdown... 1.) Windows 2008 Standard - Configured as primary AD, DNS and File server 2.) Windows 2008 Enterprise - Secondary DNS / Lansweeper 3.) Windows 2008 R2 - FTP - Web services I'm trying to…
DevNULL
  • 161
  • 1
  • 1
  • 7
0
votes
5 answers

mysql replication stop/start causes duplicate rows

We're using pretty simple MASTER->SLAVE MySQL query-based replication. Every midnight a cron script on the slave stops the replication SQL_THREAD, backs up the slaves databases with mysqldump and then restarts the replication SQL_THREAD. After…
myk00
  • 73
  • 6
0
votes
1 answer

DFS-R pre-populated target folders STILL overwrite. How to avoid that?

I have 2 servers that I'm testing with, before I do this in live environment. Server 2003 R2, fully patched. I have 20 gig of data on server1 and I want to replicate that to a folder on server2. If I use robocopy to make an exact copy of the…
Aszurom
  • 463
  • 2
  • 8
  • 19
0
votes
1 answer

Do I need to disable access to a publisher database when setting up SQL Server 2000 Transactional Replication?

I have a production database i.e. where there are constant updates and I've configured this to be published to another server using Transactional Replication. When I configure transactional replication I've been doing the following: disable access…
Kev
  • 7,877
  • 18
  • 81
  • 108
0
votes
1 answer

Adding FK Index to existing table in Merge Replication Topology

I have a table that has grown quite large that we are replicating to about 120 subscribers. A FK on that table does not have an index and when I ran an Execution Plan on a query that was causing issues it had this to say --> /* Missing Index…
0
votes
2 answers

Exchange 2010: Replication Service Still Trying to Replicate Deleted Mailbox Store

In advance, thank you for your opinions! I just migrated from Server/Exchange 2003 to Server 2008 SR2 running Exchange 2010. I had an extra mailbox that appeared with some system mailboxes in it. I used the EMS to move those mailboxes over and then…
0
votes
1 answer

Git push from post-receive

I have two servers, let's call them first and second. First one is where the real development is done, and second one should be the replica. What I would like to do is put "git push" in post-receive, but there is one problem. Post-receive is…
meka
0
votes
1 answer

Schema changes with replication

What are the steps to make a schema change to a SQL Server 2005 database using transactional replication? I'm trying to add a database column. I thought if I removed the article for the table, made the schema change, and then added the article for…
Even Mien
  • 657
  • 2
  • 12
  • 19
0
votes
1 answer

DFS replication initial step problem

I just setup DFS on my network and it's working fine, and now I'm trying to setup DFS-R on a test folder, but then at the end of the procedure (all went fine, selected my 2 folders, primary folder, replication topology and such) I get this error…
vn.
  • 375
  • 2
  • 10
0
votes
1 answer

SQL Server 2005 transactional replication break before a configured number of retries

We have a SQL Server 2000 Standard database with some tables being replicated (continuous transactional replication) to dozens of SQL Server 2005 Express and MSDE computers. The step 2 of the replication agent job (Run agent) is configured by…
ti2
0
votes
2 answers

Can SQL Server 2000 replicate system databases and/or logins?

Can SQL Replication be used to publish SQL Server 2000 system databases to another SQL Server 2000 server, i.e master, model, msdb? If this is not possible, what is the correct strategy for keeping SQL Logins synchronised (more specifically their…
Kev
  • 7,877
  • 18
  • 81
  • 108
0
votes
2 answers

Database cluster... without Master/Slave?

I'm wondering if it is possible to have a set of SQLdb servers to which data is written and have them replicate, avoiding conflicting information. I imagine that a Master/Slave structure would be mandatory, I would like to know if a system where…
RadiantHex
  • 547
  • 2
  • 9
  • 18
0
votes
1 answer

Make a snapshot of a live mySQL database with myISAM & innoDB tables without locking

We have a live database in production where we are running out of space on the server. So I would like to transfer to a new server without any downtime (or as little downtime as possible). In general, I would also like to have a hot failover copy of…
Artem
  • 183
  • 1
  • 1
  • 6
0
votes
2 answers

Echange Server 2003 Replication

We have 2 Exchange 2003 Servers. 1 is the master and is currently hosting all the mailboxes and public stores. I would like to setup a standby exchange server that is replicating all the mailboxes and public stores from the primary exchange…
Campo
  • 1,609
  • 17
  • 33
0
votes
2 answers

Ideas for scaling out database architecture

We're looking to scale out our existing database architecture and need some advice on which way to go. We currently have 2 web servers behind a load balancer that both read & write to a single master database which replicates to a slave. Ideally,…
andrew