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

11
votes
4answers
2k views

Windows Domain replication monitoring tool

I am looking for web-based interface GUI, or some kind of monitoring tool that will show replication status for a domain. I know I can use repadmin with various options on the command line to query ...
7
votes
6answers
5k views

Is it possible to use an EC2 RDS MySQL instance as a slave to an external master?

I have a master MySQL instance running on our local network, but I was wondering if I can get an EC2 RDS instance to replicate the master or is this locked down by amazon?
42
votes
10answers
6k views

PostgreSQL Replication

We constantly bat this around the office, and the question continues to come up. How do you deal with PostgreSQL replication? I'm not even necessarily talking about advanced clusters, just keeping it ...
5
votes
4answers
5k views

Create a MySQL slave from another slave, but point it at the master

Problem I have MySQL replication setup between 2 servers, master (A) and slave (B). I need to add a new slave to the mix (C). I want this slave to get it's updates directly from the master, I do not ...
11
votes
4answers
2k views

Has anyone ever used SMTP site links?

A simple real-life question, inspired by a comment here: Active Directory has supported inter-site replication using SMTP instead of direct RPC since its first introduction in Windows 2000. But did ...
3
votes
1answer
1k views

M-M or M-S replication of EBS volume across multiple EC2 instances

I would like to share EBS backed file system of size up to 20GB in 200K files across multiple EC2 instances. Master-master would be ideal, but I'd be happy with master-slave solution too. I know that ...
2
votes
2answers
3k views

Options for continuous one-way replication of tens of millions of files on Windows Server?

We have a very large Windows file store (several terabytes and tens of millions of files) that I want to keep in continuous replication over to another server, in as near to real-time as possible. I'm ...
3
votes
1answer
3k views

Redis sentinel + HAProxy failover

I am looking to implement a HA redis implementation using Master-Slave redis servers. The web servers will connect to these through an HAProxy instance installed on each box. The situation is easy ...
1
vote
2answers
5k views

Server 2008 DC rejecting replication requests

Have a DC that has recently been part of a business continuity test. From what I understand the server (which is virtual) was snapshotted, test carried out while the link between the two sites was ...
15
votes
3answers
4k views

How fast is MySQL replication?

I'm considering setting up replication of our mysql db to be able to have local slaves in each of our branch offices, while having the master in the main office to improve application performance (...
14
votes
3answers
5k 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 ...
4
votes
3answers
5k views

Using GlusterFS for simple replication

newbie question. I need to build this: /shared folder ~500GB of files, ~1MB each one. Two boxes (server1 and server2) connected by a 1Gbs LAN Every box needs to get r/w access to the files, so ...
6
votes
9answers
9k views

Make identical copy of Centos

I have a CENTOS server running and i want to make identical copy of it(all software,users), like twin server for mirroring purposes. how do i do that?
6
votes
2answers
3k views

Way to avoid server downtime when creating Master - Slave relationship?

I am preparing for setting up a MySQL master-slave or master-master relationship. Right now I have a single MySQL production server, and of course I don't want a lot of downtime while I connect the ...
2
votes
2answers
2k views

Amazon RDS to EC2 replication [duplicate]

Possible Duplicate: Is it possible to use an EC2 RDS MySQL instance as a slave to an external master? My read-intensive application needs to scale horizontally. It will be deployed by various ...
1
vote
2answers
3k views

How can I set up an Amazon RDS for PostgreSQL database to act as a replica to a non-RDS PostgreSQL database?

I'm trying to set up an PostgreSQL database on Amazon RDS as a replica to another PostgreSQL database that lives on a regular server. Most of the instructions I've found online require shell access so ...
4
votes
2answers
4k views

MySQL says replication is fine but data is not copied

The setup The setup is very simple and straightforward. It's a pair of Debian servers with a Gigabit link in between. MySQL is stable Debian Lenny version and OS is Debian Lenny. Configuration The ...
2
votes
8answers
4k views

Windows Server Almost Real-Time Directory Replication

The environment Windows 2003 R2 Standard File server Windows 2003 Web Edition server The challenge Need a way to mirror a directory (or share) from the file server to the web server. It needs to ...
2
votes
4answers
653 views

Solution for two-way file-system transparent solution

I need to implement some sort of HA setup where 2 servers need to be able to always be in sync, no matter on which one you write on. The DB part can be covered by a master-master replication setup. ...
2
votes
3answers
650 views

Mysql Replication - are per-database threads possible?

I manage a MySQL server hosting over 100 databases. We have set up standard master-slave replication, but the SQL Thread tends to break every so often, and requires manual intervention to re-start ...
2
votes
2answers
287 views

Should I avoid SQL Server Replication?

I have an app that is used by people in the US and in China and the database sits in the US. The people using it in China complain that the performance is poor, so I was thinking of using SQL Server ...
2
votes
2answers
2k views

MySQL 5.1 Replication Topologies: Multi-Master

Hallo :-) Once again I'm on the hunt for new knowledge, I'm a part-time DBA as part of my current job, and am particularly interested in any documentation or reading around doing bulletproof multi-...
2
votes
1answer
2k views

mysql - SQL slave thread is not applying changes

I have master/slave replication with 5 slaves and 1 master. The master is mysql 5.1.37 and the slaves are 5.5.8. Two days ago one of the slave stopped working. In "show slave status" I see that both ...
2
votes
5answers
4k views

A simple Volume Replication Tool for large data set?

I'm looking for a solution to the following: Server A (Site A) - Win 2008 R2 - approx 10TB (15TB max) of data - well over 8 million files Server B (Site B) - Win 2008 R2 I want to ...
1
vote
1answer
2k views

Windows Server 2003 SP2 - JRNL_WRAP_ERROR (Sysvol)

SETUP: Windows Server 2003 SP2 with a replication error (this is the only DC in the domain) [image below]: Journal Wrap Error on sysvol share Is there a way to find out what is broken/corrupt/...
1
vote
1answer
2k views

Clearer understanding for glusterfs for replication

On server01 I have installed and configured glusterfs-server and glusterfs-client to replicate directory /var/appdata to server02. It seems that anything works fine, but I'm not sure that I ...
1
vote
3answers
1k views

Sharing / replicating EBS across AWS nodes

I would like to use single EBS storage across multiple EC2 nodes (web/app servers). I've read some articles on snapshot sharing, but that doesn't suit well for what we need. We use filesystem for ...
2
votes
2answers
12k views

What is the correct way to configure AD replication in a hub-spoke design

Our AD is a basic hub/spoke design. We have a headquarters in London, and remote offices. The remote offices are connected via VPN to HQ. We have 3 domain controllers at HQ, and one in each remote ...
2
votes
3answers
978 views

Active Directory set up with replication — need a way to control login authentication host

I have two Active Directory servers set up with replication, ad2 and ad4. ad4 has a higher latency than ad2 as it is offsite. All clients are supposed to log in and authenticate to the ad2 server. The ...
2
votes
1answer
3k views

MySQL replication of only one database

I just wanted to check on the replication setup I've got working. The plan was to replicate just one database, so per the MySQL documentation I used the replicate-do-db flag in my MySQL configuration. ...
1
vote
1answer
500 views

Can't connect to MySQL 5.5 with SSL

I am trying to get MySQL SSL replication setup for two brand new RHEL 6.6 x64 servers. I have replication working without SSL, but I can't get it set up with SSL, and can't connect directly using SSL ...
1
vote
4answers
2k views

DRBD or similiar RAID over net on slow/limited networks

I am looking for ways to create some kind of file replication without losing too much performance on file operations. A real RAID is not an option due to non-technical constraints. As far as I ...
0
votes
1answer
661 views

SQL Server 2005 on 2008 DC - Cannot change service user

I cannot start SQL Server 2005 transactional replication after I promoted my 2008 Server to a DC. A required privilege is not held by the client. This site suggests that I need to change the ...
0
votes
1answer
118 views

MySQL replication shuts down after rotate of binlog

I have following issue. I had successfull setup of master-replica(row-based). It has been running for 2-3 hours. After bin-log was rotated -> mysql-bin.index file got corrupted on master. Here is ...
0
votes
3answers
2k views

Two way, multi-site replication in MySQL

We have MySQL 5.1 databases at 5 separate locations that we need to keep as synced as possible. Each office needs to read/write from/to the local server at that office, but I need the DB at each ...