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.

learn more… | top users | synonyms

3
votes
1answer
548 views

Rails/Mongo across multiple different geo-regions

I have a system that by necessity requires physical presence in three or more different locations and I need advice on structuring in such a way that my database stays replicated in a timely manner ...
1
vote
1answer
154 views

Postgres 9.1 replication - force select operations to specific slave

I've configured postgres stand by replication using 1 master and 2 slaves. Master and slave1 are located in USA datacenter while slave2 is located in a datacenter in London. Is there any way of ...
2
votes
1answer
273 views

Mongodb Slave replication lag

We using standard mongo setup: 2 replicas + 1 arbiter. Both replica servers use same AWS m1.medium with RAID10 EBS. We experiencing constantly growing replication lag on secondary replica. I ...
1
vote
3answers
619 views

failsafe RAM drive solution [closed]

I'm looking for a production solution to create a RAM drive that will be safely synchronized with HDD. I have a piece of custom software with heavy I/O load (this is some kind of proprietary ...
0
votes
1answer
195 views

Netstat shows Time_Wait in MySQL Master to master replication

During my master to master replication, I got a problem on telnet. After fixing it also my replication on both side doesn't work. Master 2 replicates all the database of Master 1 but Master 1 is ...
1
vote
0answers
276 views

SQL Server 2005 Mirror table between databases on same server

I've been using transactional replication to mirror a table from one database to another and lately it's been a pain to keep running. My goal is to simply keep an exact copy of a table in another ...
1
vote
1answer
1k views

MySQL replication - rapidly growing relay bin logs

Morning all, I've got a really strange situation here this morning much like a reportedly fixed MySQL bug. http://bugs.mysql.com/bug.php?id=28421 My relay bin logs are rapidly filling with an ...
4
votes
2answers
1k views

Hyper-V 2012 replication to multiple hosts

With Hyper-V 2012, it is possible to configure the primary server to replicate to a slave server, to allow virtual guests to be live migrated to the slave server, when maintenance is required on the ...
0
votes
1answer
59 views

Oracle replication A->B and B<-A?

If you have two unrelated Oracle databases on separate servers, can you replicate A to B and B to A so both servers have a copy of both db's? Idea is for DR "on the cheap" without buying more Oracle ...
0
votes
1answer
392 views

How to enable telnet with port 3306 during Master to master replication on MySQL Server

I am trying to do Master to Master Replication in Windows Server 2008. I am successfully able to replicate all the database of Master 1 to Master 2. But I am unable to replicate the changes made on ...
1
vote
1answer
123 views

SAN Snapshot backups

In our environment, we have three physical servers that are running Windows Hyper-V to host various server images. The Images themselves are stored on a Dell Equallogic SAN connected via the iSCSI ...
2
votes
2answers
172 views

“distributing” ftp server?

Is there an ftp server that behaves as a 'distribution front end' to multiple other servers? So that when I upload a file, it accepts the contents, puts them on all of a list of other ftp servers and ...
2
votes
1answer
366 views

DFS Replication on 2 existing duplicate shares

I have 2 sets of data in separate sites that are mirrors of each other. The 2nd set is a clone of the 1st set. However, the 1st set will be the live data and therefore will be changing going forward. ...
0
votes
1answer
92 views

replica set with multiple primary nodes

I am trying to configure a replica set with three nodes: node A, B and C. I execute the rs.add()'s from node A and after that rs.status() shows that the three nodes are PRIMARY. Moreover node B and C ...
2
votes
4answers
97 views

Looking for a solid redirection infrastructre [closed]

We have critical servers (webservers and databases) that are fully replicated, except for the reverse proxy that we use to hide the internal stuff. This proxy is acting like a router that filters and ...
1
vote
1answer
367 views

Cloning a VM to add a new MySQL Slave

I am in the process of adding a new slave to a replicated MySQL setup. I'm proposing the following process: clone one of the nodes to a new VM start it with no networking stop mysql change the ...
0
votes
1answer
115 views

Move MySQL master

I currently have a master db server (lets call it db1) and 6 slaves (slave1-6). I've setup a new server (db2) as a slave of db1 and it's in sync. I want to change all the slaves to use db2 instead of ...
1
vote
1answer
2k views

Ubuntu 12.04 glusterfs volume failed to mount at boot time

I have just setup 7 KVM guests, all running Ubuntu 12.04 LTS 64bit Minimal server to test out glusterfs 3.2.5 from the Ubuntu official repo. Two of them form a mirrored pair (i.e. replica 2), and five ...
0
votes
1answer
63 views

Preparing a server for mysql replication and use it as standalone

I want to host an application on a single server running MySQL server. To get the best performance I plan on using a UNIX socket connection (to avoid TCP overhead). Later, I would like to scale up by ...
1
vote
1answer
1k views

Replicating EFS encrypted files

Recently I attempted to configure Microsoft's DFSR on Windows 2008 R2 to replicate a folder which was encrypted with EFS. The setup gave no errors or warnings, but later I read that DFSR does not ...
2
votes
1answer
162 views

Using TrueCrypt with File Replication on Windows Server

We have a few folders that are set to replicate to a DR file server off-site. One of these folders contains a file that is a TrueCrypt volume container. When this file is mounted in TrueCrypt, the ...
0
votes
1answer
209 views

Should I never put a transactional replication distributor on a subscriber server?

What factors into choosing a distribution server for transactional replication? In our topology, we've always had the distributor reside on the publishing server. We rarely generate snapshots and ...
2
votes
1answer
713 views

How to install Percona XtraDB Cluster on x86 server?

I'm going to migrate from MySQL replication to Percona XtraDB Cluster. The problem I'm facing is one node is running on x86, and I cannot install Percona-XtraDB-Cluster-server from the Percona repo ...
0
votes
3answers
132 views

MySQL replicate multiple places

Very trick task to find a good title for this question, but here goes the q: I have a few development machines, where I develop my PHP applications on, and testing via a local webserver. This works ...
1
vote
1answer
56 views

Any pitfalls for replicating MySQL to a remote server

Are there any pitfalls or gotchas for replicating (master->slave) MySQL DB to a remote server about 100ms ping away?
5
votes
4answers
677 views

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 ...
-2
votes
2answers
169 views

What replication should I use for my Sql Server

We have a dedicated server that will host our client's database for a web portal. To connect to this database, you need an ip address. I figured I'd try Merge Replication since I already have the ...
2
votes
2answers
529 views

Postgres: Replicating over ssh at specific time frames

Can someone help me with the most common stable replication mechanism for postgres that I can run at specific times of a day(know it sounds weird) postgres that can run over ssh? Over ssh is ...
5
votes
2answers
2k views

KVM Hosting: How to efficiently replicate guests

I have three KVM servers each with 1 guest VM, running directly on it's local storage, (so they are essentially getting a dedicated box worth of computing power each). In the event of a host failure I ...
3
votes
3answers
7k views

New Domain controller is having trouble replicating from an existing DC, 13508 Event ID for FRS

This question is related to a previous one I asked regarding backing up Domain Controllers and RODC's. Basically I am making some changes in regards to the DC's in my network. I am looking to add a ...
0
votes
1answer
658 views

DFS trying to replicate back to source folder?

I'm not very familiar with how DFS works, and since someone else administers the servers in question I don't know what the DFS setup looks like. I'm just wondering if something is possible. ...
4
votes
3answers
2k views

How do I configure active directory when Sql Server 2012 is using a Virtual Account?

I'm getting the following event log entry from Sql Server 2012: SQL Server Scheduled Job 'Replication agents checkup' - Status: Failed - Invoked on: 2012-08-04 10:00:00 - Message: The job failed. ...
1
vote
2answers
492 views

mysql master slave “table already exists” but table not exists

I have 1 master mysql process, and 2 slave. Today on both slaves i see : Error 'Table 'bgbilling.contract_status_balance_dump' already exists' on query. Default database: 'bgbilling'. Query: ...
1
vote
1answer
240 views

maakit: mk-table-sync issue with index

Trying to re-sync a slave, I run into troubles with some of my tables which do not have a auto-increment primary index, but a primary unique ID (not auto-increment). I run the re-sync with ...
3
votes
1answer
167 views

System Requirements of a write-heavy applications serving hundreds of requests per second

NOTE: I am a self-taught PHP developer who has little to none experience managing web and database servers. I am about to write a web-based attendance system for a very large userbase. I expect ...
2
votes
1answer
362 views

Is there an async FUSE filesystem for replication?

I have a low-power VIA x86 PC with one SATA port. I want to backup special files (ie: /var) from the SATA drive on this port onto a USB flash disk, but I don't want a RAID1 or fully-synchronous ...
2
votes
1answer
277 views

SQL Server Broker Service with Active - Active replication in place

We currently have two datacenters in Active - Active mode and using SQL replication between the two datacenters (with a small delay). I'm developing a new process that will use SQL Server Broker ...
1
vote
2answers
895 views

Best PostgreSQL replication solution that minimizes network costs

I'm looking into PostgreSQL replication solutions. I know two varieties of these solutions Low level - which involves streaming log-shipping, hot-standby features available in PostgreSQL 9.x High ...
12
votes
3answers
3k views

MySQL Replication Performance

I'm having a serious issue with MySQL 5.5 replication performance between two machines, mostly myISAM tables with statement based replication. The binary logs and mysql data directory are both located ...
1
vote
1answer
104 views

How does a replicated DC handles w32tm changes?

We have 2 replicated W2K8R2 DC's. I had updated one (DC1) with w32tm to get manual updates from asia NTP. Everything syncs correctly. My question: (In order to learn): How does this propagates to ...
2
votes
1answer
383 views

Queries Stuck on the 'Connect' Command

So, little back story. We have a master-slave set-up and multiple times per day, we see something like this on the slave database, trying to replicate whats come from the master Id User ...
0
votes
1answer
488 views

Monitoring MySQL replication through HAProxy Xinetd service

I have have set up MySQL multi-master replication with HAProxy as a load balancer following Alex Williams' tutorial found here; ...
3
votes
1answer
1k views

Quickly change Active Directory Replication Schedule for all Sites & Sitelinks

My company has more than 80 sites, and my predecessor for reasons unknown to me put in a large chunk of time preventing replication between the HQ's DC and the branches' RODC. I need to reset their ...
0
votes
1answer
209 views

hosted failover(proxy?) service - does it exist?

We're in the planning phase to make our web application services redundant. Right now we've got our own physical servers at a colo, running a VMWare cluster connected to an EqualLogic SAN. It's a LAMP ...
1
vote
0answers
227 views

Replication with Veeam causes timeouts on large VM's

I have been trying to replicate two of my larger VM's one being Exchange 2003 and once the snapshot begins to commit the server begins to time out. I have updates my ESX hosts from 4.0.0 to 4.1 and ...
2
votes
3answers
1k views

MySQL per-database replication?

So, my problem is interesting: we want to migrate from one server to another. We made a master-slave replication, but my boss came with the idea to make migration one database at a time. So he asked ...
2
votes
1answer
3k views

How can I check that DFS is replicating correctly? [duplicate]

Possible Duplicate: compare the contents of two folders that are replicating by dfs We use DFS to replicate files to a Disaster Recovery server. We have a task where we check the DR ...
0
votes
1answer
84 views

Weird Active Directory behavior after ADMT migration

We have multiple sites with multiple DC's. Since performing the migrations we have been experiencing all sorts of problems with DFSR etc. We have multiple objects in the AD .. DCNAME ...
2
votes
2answers
512 views

Checksumming mysql replicas over ssl

After hours of struggling to understand the way percona toolkits (2.1) pt-table-checksum works, I try to try you. Situation Running MySQL replication (Master-active:Master:passive) Slave user is ...
1
vote
2answers
251 views

mysql replication 1x master, 1x slave

I have just setup one master and one slave server, but its not working.. On my website I connect to the slave server and I insert some rows, but they do not appear on the master and vice versa.. What ...