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

1
vote
1answer
680 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
165 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
249 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
286 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
115 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
420 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
338 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
489 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
558 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
1k 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
1k 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 ...
2
votes
2answers
4k 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
528 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
179 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
598 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
166 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
294 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
695 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
214 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
295 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
60 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
412 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
127 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
195 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
417 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
98 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
98 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
399 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
122 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
67 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
165 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
228 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
735 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
136 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
820 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
172 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
559 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
3k 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
9k 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
744 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
555 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
259 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
2answers
179 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
408 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 ...