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

2
votes
1answer
4k views

Why does replication fail with error Duplicate entry for key?

We have been replicating for a year or two now with little problem. Sometimes we get an erroneous SQL query which stops replications, and we use the following commands to get it going again: STOP ...
1
vote
1answer
229 views

One Way Replication of Oracle 11g to MSSQL 2008R2

We're in the midst of a major LOB system change which will use Oracle 11g, but we need to maintain a LARGE number of existing reports in SSRS. What is a good method to automate a one-way, read-only ...
9
votes
2answers
920 views

Expected performance of e-SATA port multiplication?

For a certain read/write workload, I get 30 MiB/s from a 4-disk array using esata port multiplication. When I move the exact same array to four individual sata connections, I get 90 MiB/s for the same ...
4
votes
2answers
209 views

Is there a safe way to bypass a non-replicating DC?

We have a domain controller that was virtualized a while back; this caused issues with replication that we're now seeing fallout from. I've moved the PDC Emulator and other fsmo roles to a new DC and ...
1
vote
2answers
402 views

Distributing SQL Server on Internet regarding security issue

We are going to put our servers in two places to keep high level redundancy and to avoid bandwidth critics. The two servers are on different LANs but communicate over a WAN network (via Internet). One ...
0
votes
2answers
64 views

SQL server backups - backwards situation

Hi I'd like to know if it seems feasible to do things in this manner. We have several application servers (a web server for intranet applications, a couple of different app servers). Each server is ...
1
vote
1answer
1k views

How can I provide live replication of a Linux server?

I need to be able to do live replication of a running Ubuntu server, so if the main machine goes down I can automatically failover to the other machine. I found mklivecd, but that seems to only get ...
0
votes
1answer
69 views

Aggregating data from multiple MySQL servers

I have 10 MySQL servers and each one holds a database that needs to be replicated to a single, centralised MySQL server. The complexity is that each server must replicate its database to the same ...
3
votes
1answer
148 views

What are possible results/side effects if replication between DC's in a Windows domain is unable to occur?

There's plenty of administration literature out there how to properly manage Windows servers. But in dealing with real life, things don't always occur like you want them to. In Microsoft's Windows ...
5
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 ...
1
vote
1answer
1k views

Very poor optimization: Riverbed-Test-Appliance and NetApp SnapMirror replication

We are actually testing Riverbed Steelheads in order to accelerate replication using SnapMirror between two sites. The distance ist 100km between the sites. Connection: 150Mbit MPLS Network Systems: ...
0
votes
1answer
237 views

How to use AppScale

There are some wiki which explain how to install and setup AppScale. But I didn't find anything related to the extensive use of AppScale. I mean, what to do in case of major outage ? If the node ...
1
vote
1answer
265 views

DFS Replication, Losing folders

We lost a lot of folders in one part of our AD. I tracked down that we get a lot of errormessages about this in this form: How do we solve this? Why does this happen? (Some information edited) ...
3
votes
3answers
5k views

Run a MongoDB configuration server without 3GB of journal files

For a production sharded MongoDB installation we need 3 configuration servers. According to the documentation "the config server mongod process is fairly lightweight and can be ran on machines ...
2
votes
3answers
1k views

multi-master replicated dynamic dns subdomains

For lack of a better title. Our environment requires having subdomains where we allow dynamic updates using bind as the DNS server and its nsupdate utility authenticating via keyfiles. We're looking ...
2
votes
1answer
196 views

Secure Microsoft Active Directory DC to DC communications through firewall boundaries

We are currently looking to flatten our AD structure a bit to make things a bit more manageable, but we still want to keep our security posture as near as possible to where it is now. Currently, we ...
0
votes
1answer
22 views

2 databases locked, but only one can be successfully dumped (backed up do *.sql file) … fail

i have this situation 2 large databases on mysql server - srv1 I need to transfer both to new server - srv2 so I use sql command "FLUSH TABLES WITH READ LOCK;" to stop all modifications Then I ...
6
votes
1answer
304 views

Replacement for MySQL proxy

We have a standard MySQL Master/Slave replication for our database. In order to use the slave server we have set up MySQL Proxy. However we have been strongly discouraged to use it as it still alpha ...
1
vote
2answers
2k 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 ...
4
votes
2answers
953 views

Multiple VPS with mirrored database and filesystem

I've developed interest in VPS clusters lately and it seemed like a great idea to try to set up a multi-VPS setup, which I will describe below. It isn't really meant for production use, but more as an ...
2
votes
1answer
1k views

Setup a mysql replication, but new data are not updated

I have setup a MySQL replication for an existing database server. The setup seems fine, but the database never update on slave server after I start the replication. Both servers are using CentOS 5.7 ...
3
votes
2answers
329 views

SAN replication

My company has only a single storage box (SuperMicro hardware + chassis with a LSI raid card and 12 SAS 7.2k drive) in its current setup. It runs on linux and we hook it up to our fileserver via ...
2
votes
3answers
719 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
2answers
845 views

How to ensure that a MySQL slave server is using the SSH tunnel to replicate from the master?

I need to secure MySQL database replication between two CentOS 5.7 servers. Server 1 has the live database, and replication is already working fine to Server 2 which is located elsewhere on the ...
1
vote
1answer
133 views

MySQL replication - Query is replicated even if explicitely ignored

I have a MySQL Master 5.0.77 replicating on a slave 5.5.13. So I'm using STATEMENT based replication. I have a query 'CREATE TEMPORARY TABLE blah' that is replicated even if it's not in the ...
0
votes
1answer
128 views

switching master with minimal downtime

Currently have a MySQL replication setup in which Master A is replicated on another server db Slave B. I'm shutting down the server that hosts Master A and need to start a new server that houses ...
-1
votes
1answer
148 views

Domain controller replication and distribution

What is the proper way to distribute work from the pdc to a bdc for authentication. If the bdc handles authentication, when it increments the bad password count, how is that relayed to the pdc? Does ...
1
vote
1answer
326 views

mysql replication - slave seems up to date but data not synchronized

I have a master-slave setup with 2 servers over a network. Due to an error, the slave IO thread stopped, though I could get it started and running, the slave is way behind the master. Also, SHOW SLAVE ...
2
votes
2answers
299 views

MySQL multi level replication breaks constantly

I have replication setup as follows Master A ----> Slave B ------> Slave C \-------> Slave D \------> Slave E - H I use this setup because I need a local copy at the office ...
1
vote
1answer
152 views

MySQL inconsistent data when using mysqlbinlog utility

I am having a problem in mysql replication. I have a mysql raw data snapshot and my master host have 2 binary logs (binlog.01, binlog.02 - start to log after snapshot was created) What I want to do ...
0
votes
2answers
107 views

MYSQL master-slave fail if slave behind proxy?

I have two linux machines, A and B. A is master and B is slave. Besides, B is behind proxy. In B , I have set http_proxy and socks_proxy env variable. However, B cannot connect to A and report ERROR ...
0
votes
1answer
54 views

Bind slave creating domain without any records

i have the same version of Bind running on two different host. When a new domain is created it is also created on the slave but there are no records within the domain. I am not sure what i need to do ...
4
votes
6answers
3k views

Need help with estimating required bandwidth for SAN array to SAN array replication over WAN

I have a long-term goal of setting up a DR site in a colo somewhere and part of that plan includes replicating some volumes of my EqualLogic SAN. I'm having a bit of a difficult time doing this ...
2
votes
1answer
197 views

DFS Replication across WAN

I have setup both sites in ADSS, set the subnets properly (I think), and setup a DFS share with replication. How can I test that to see which physical machine I'm actually accessing when visiting ...
2
votes
4answers
503 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. ...
0
votes
1answer
61 views

how mysql replication

I'm doing mysql replication (master - slave). There are a few questions Can I assign replication for some databases and not all databases that are on master (for example, ON master server there are ...
4
votes
2answers
4k views

datetime format changed between mysql 5.0 and 5.1?

I've upgraded a mysql slave from mysql 5.0 to mysql 5.1. during the catch up, the replication failed on a query with incorrect datetime value: 110919 13:56:18 [ERROR] Slave SQL: Error 'Incorrect ...
0
votes
1answer
94 views

Bind9 (on local DNS) taking a long time to use zones from public DNS servers

My local DNS servers (ubuntu, bind9) are supposed to simply forward from my public name servers. However, if I make changes to public IP addresses, the information will replicate to Google, ATT, etc. ...
2
votes
1answer
693 views

pg_basebackup: could not get WAL end position from server

I want to create a Base Backup with the pg_basebackup tool of postgres 9.1. After some seconds I receive: `pg_basebackup: could not get WAL end position from server What can be the reason for this ...
3
votes
1answer
272 views

Is it possible to backup an Amazon RDS database to another service?

I moved my site's database to RDS a few months ago. At the time, I finally decided I was ready to have a dedicated database server, and during the process of setting one up on EC2, I discovered RDS. ...
2
votes
1answer
273 views

mysql replication over long distance - many tcp/ip reconnects

We are doing offsite mysql replication over long distance and limited bandwidth - latency of about 200ms and about 70KB/s (max). The replication works sporadically, transferring several tens of ...
0
votes
1answer
578 views

master-slave MySQL replication with special characters in column name?

I am trying to get a simple master-slave MySQL replication running, but I have some strange errors when LOAD DATA INFILE is used: 110908 23:59:42 [ERROR] Slave SQL: Error 'Unknown column 'N°_Site' ...
1
vote
1answer
269 views

Can a DC Computer Account be recreated?

We have a problem with an active directory, Aftrer some replication issues existing over the years, the first dc has no DC Computer account in the same domain on the other dcs. So is it possible to ...
0
votes
1answer
88 views

SQL 2005 Replicated Database Indexes

I have setup a SQL 2005 database replication (transactional) between two servers. I have noticed today that the non-clustered indexes do not seem to have gone across to the replicated database. I ...
1
vote
1answer
541 views

MongoDB: Fixing ReplicaSet Error on reconfig - “Server::doWork task:rs Manager exception:unauthorized db:local lock type:2 client”

Question: How do I fix my servers and get them back to the normal ReplicaSet with no error messages? I'd offer a serious bounty, but all my points are on SO :( Details of the Problem I'm running a ...
1
vote
1answer
463 views

Running MySql replication between datacenters

I run my website from EC2. Due to AWS outages, I am contemplating replicating my setup on Rackspace and switch over from DNS in case of an outage. I am looking to learn ways to replicate my MySql ...
3
votes
3answers
3k views

How to actually use mysql slave as soon the master is failover or got burnt

I have MySQL master-slave replication that works fine; I googled the whole net and MySQL site to find the standard procedure to make use of the replication but found nothing. It is as if admins are ...
1
vote
2answers
362 views

Windows Server 2003 AD Folder Replication

I have a folder on my Windows 2003 Server AD machine that is shared out to clients at Location A. The people in Location B are currently mounting this folder across a network link. The problem is of ...
2
votes
2answers
187 views

What happens if services like DynDNS to control failovers fails? It's probably?

In the next diagram I'm trying to have a backup web page in another datacenter and a service like DynDNS that controls failovers in SERVER A to switch to SERVER B. But, what happens if DynDNS fails? ...
2
votes
1answer
3k views

When seeding a Windows DFS replication copy, do you need to copy security?

I may need to rebuild a 1TB Windows 2008 DFS replication folder between our UK and USA sites. It's good practise to seed the other copy before starting replication so that the bulk of the data doesn't ...