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

0
votes
2answers
222 views

Synchronisation between MySQL databases on different hosts

I want to solve a data replication/data sync problem between two MySQL server instances. Both of them have the same database structure (databases, tables, columns, everyting ...) but each of them has ...
0
votes
1answer
514 views

Change DFS Replication scheduled time?

Is it possible to change the scheduled time for DFS replication between replication partners on Windows Server 2008? We have a backup that runs hourly and interferes with the replication. I then get ...
0
votes
1answer
61 views

AWS ElasticCache - Cross Site - Disaster Recovery

I'm using AWS ElasticCache (MemCached) and can see how instances can be created at different data centers/sites. (eg: singapore A or B) There is no AWS Automatic Replication of ElasticCache from ...
0
votes
1answer
147 views

Easiest way to replicate users between two (or more) servers?

I've got two webservers which takes part in a load balanced setup. The two webservers are in other words mirrors of each other. As it is right now I'm synchronizing data between these two servers ...
1
vote
1answer
77 views

Is failover with only two servers possible?

I'm trying to set up a basic high-availability solution with HAproxy and mysql. Currently it looks like this In case of host1 failing, the host2 is supposed to get it's IP and traffic (using feature ...
0
votes
1answer
301 views

MySQL replication re-sync

I'd like to set up a zero-maintenance hands-off MySQL replication regimen for backup purposes. It's been my experience, though, that these things inevitably eventually get out of sync. Perhaps it's ...
1
vote
1answer
479 views

MySQL error 2003 over ssh tunnel when replicating, not when using client

I am trying to set up replication on a MySQL server over an SSH tunnel. I've set up a port forward on the slave from port 7777 at localhost to port 3306 on the master, and I can connect to my ...
2
votes
1answer
148 views

Why is MySQL writing hundreds of 125 byte binary log files?

My MySQL Master (with no connected slaves right now) writes out a 125 byte file every minute or so: -rw-rw---- 1 mysql mysql 125 2012-12-28 16:46 snapshot-mysql-v2-bin.004876 -rw-rw---- 1 ...
4
votes
1answer
158 views

MySQL Master - Master Broken

I've Inherited a Mysql master master system, I've noticed the second master (lets call it slave from now on as it's running on a 'slave' machine) stopped getting its db's updated. I saw that Master: ...
1
vote
2answers
144 views

replicate an existing chef node

I have a VM (hosted "in the cloud") that has been provisioned with chef using my organisation's own chef server. I would like to replicate that VM locally (using a vagrant managed VM), in order to do ...
2
votes
3answers
97 views

MySQL Replication A->B->C

I was setting the MySQL Replication for master -> slave/master -> slave and Replication for master -> slave its works fine but when i have enable this option in my.cnf log-slave-updates=1 for ...
4
votes
1answer
286 views

MongoDB Replica-Set with Replication Lag on one node only

we experience a strange behaviour in our MongoDB Replica-Set, setup of 3 Nodes (all Xeon Quad-Core-Class CPUs, 16GB of RAM for one, 24GB for the other two nodes) The one node with less RAM is normal ...
2
votes
5answers
254 views

Master - Slave MySQL setup on a VMWare Cloud — Is it needed?

We currently are in the research phase of building a "Master" database for our e-commerce business that will centralize all data, including product information, vendor information, Magento ...
1
vote
1answer
345 views

MongoDB Replica Set, initiate() need to login error

I am trying to setup a replica set, but when I issue: rs.initiate() On the first server, I get the following error: { "errmsg" : "need to login", "ok" : 0 } That is strange though, because in my ...
5
votes
1answer
388 views

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 ...
2
votes
1answer
613 views

vSphere Replication Guest OS Quiescing

I am using vSphere Replication 5.1 to send virtual machines to a separate datastore every 24 hours. One option in configuring each VMs replication is the Guest OS Quiescing option. Options are None ...
1
vote
2answers
794 views

Server 2012 Data Deduplication Skipping Replica VHDs

I'm currently trying to use data deduplication on two seperate Windows Server 2012 Datacenter edition hyper-v hosts. On one, I am trying to dedupe replicas that are still being resync'd every 5 ...
1
vote
2answers
2k views

What can I really do with percona toolkit's pt-table-sync?

I have been looking for a tool to synchronize tables from 2 different databases and found pt-table-sync. I read the documentation and got confused: they mostly use examples referring to a replicated ...
1
vote
1answer
354 views

postgreSQL replication and failover with repmgr on Ubuntu

I'm new to Linux and have been tasked with setting up a redundant Linux DB server with PostgreSQL. preferably the fail-over needs to be automatic, but a manual process will be fine for now. What I ...
1
vote
2answers
155 views

Mirroring svn repository

I have an svn repository and I'd like to have it duplicated over multiple machines for availability purpose. By now when my vps goes down, I'm unable to connect to repository and this is very ...
3
votes
1answer
451 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
125 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 ...
0
votes
0answers
210 views

LDAP Replication Issue: Need to convert Slave server to a Master server

We have followed this url https://help.ubuntu.com/10.04/serverguide/openldap-server.html for setting LDAP replication and is working fine. Now our master server goes down so please help us to change ...
2
votes
1answer
216 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
515 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
170 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 ...
0
votes
0answers
204 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
965 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
861 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
53 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
322 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
115 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
134 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 ...
1
vote
1answer
265 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
82 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
96 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
274 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
88 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
55 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
710 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
155 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
177 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
677 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
120 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
51 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
479 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
161 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 ...
1
vote
2answers
462 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 ...