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
129 views

raid with replication

We are planning to buy two servers which will going to host an SQL database(PostgreSQL). The second server will work as a live replication of the first database server (hot standby). The question I'm ...
0
votes
2answers
5k views

Active Directory Cross-Site Replication Speed - Should I select Preferred Bridgehead Servers?

I have 2 sites. Site1 with 2 DCs and Site2 with 1 DC. If I create a new user on Site1 the 2 DCs replicate the user instantly. The Site2 DC doesn't get the new user replicated to it until some time ...
1
vote
0answers
231 views

PostgreSQL 1 master, multiple slave replication over slow links

I have a current use case in which remote computers query a central PostgreSQL database over a internet connection (read-only). We would like to implement a "stand-alone" system for these terminals so ...
16
votes
4answers
499 views

Starting a branch office on the other side of the world

Going to cut right to the point on this question, as I'm after as diverse range of solutions as possible so don't want to effect any opinions with the question too much. Client is a UK based ...
3
votes
1answer
438 views

MySQL slave server restart

What's the secure/proper way of restarting the MySQl slave server. I need to reboot the machine in order to update the kernel and apply some configuration changes. I've tested it on my lab and ...
1
vote
0answers
188 views

DFSR: Break large replication group into multiple smaller replication groups?

Is there a way to break a very large replication group into smaller replication groups while avoiding a huge backlog while it re-syncs or verifies the files in each smaller replication group? I have ...
8
votes
2answers
5k views

Windows DFSR - Changed replicated directory permissions and now have a 350,000 backlog for more than a week

Question: Is there a way to make this 350,000 file backlog complete faster? For nearly every file the only change was a change to the ACL for each affected file. Some files have changed content, ...
0
votes
1answer
1k views

dnslint and redadmin, why and when?

A pretty small query really - dnslint and repadmin - what really differentiates these tools in terms of troubleshooting replication? When and why would you use either one.
2
votes
3answers
182 views

Create a full replica of web server using different hosting company, is it logical?

Is it logical to create a full replica of our webserver, just on a less powerful machine, using other hosting provider ( just because its cheaper ). The idea is to have a plan B, in case main server ...
-1
votes
1answer
217 views

Repadmin and DNScmd

A little query really in terms of the usage of Repadmin and DNScmd when forcing replication of DNS zones. I'm currently studying for my 70-640 (Active Directory Exam) and was wondering what the ...
0
votes
2answers
245 views

what is a good frequency for setting up snapshot replication in sql server 2008

My requirements: I have a publisher database from which I intend to replicate to a subscriber. Not all tables need to be replicated. Amount of data could be ~20-30GB. Given the above: is ...
0
votes
1answer
1k views

Mysql: What to do if a disc full happens on master OR slave and ther is no space left to binary logs

Recently I configured master-slave replication for my production with out considering all the user cases. I am started on all the possible use cases at hard ware level again to ensure we will be ...
0
votes
1answer
59 views

Is it possible that newer data is overwritten by old after MySQL replication slowdown?

I've set up master-master replication of 2 servers and in one of the tables I use REPLACE INTO to update the data in a table. Is it possible that a link between the 2 servers goes down, then server 1 ...
0
votes
1answer
219 views

Remote to remote block level replication

I have to sync 2 iSCSI LUNs together at block-level (mandatory), asynchronous, only in the night, I found some tools to do it when Remote to Local or Local to Remote, but I cannot install anything on ...
0
votes
2answers
842 views

How to move the files of a replicated database (SQL Server 2008 R2) to a different drive

I would appreciate if someone could help me with the following problem: We use two SQL Server 2008 R2 databases under transactional replication: transactional publication with updatable ...
4
votes
2answers
261 views

Possible to make mysql server both master and slave?

I am getting ready to move a database from one server to another. In order to reduce downtime for the client, I am wondering if it would be possible for me to turn on replication and give it time to ...
3
votes
3answers
1k views

MySQL to PostgreSQL replication

Is there way to replicate in near-realtime MySQL changes to equal PostgreSQL database?
2
votes
2answers
3k views

--log-slave-updates is OFF but some updates are still logged to the slave binary log?

MySQL version 5.5.14 According to the document, by the default, slave does not log to its binary log any updates that are received from a master server. Here are my config. on the slave: # egrep ...
5
votes
2answers
821 views

How to scale out OpenStreetMap data efficiently

For over a year now, I'm running an in-house PostGIS server filled with OSM data, used for both Mapnik-based tile generation and Nominatim-based geocoding, updated with day replicates. This works ...
4
votes
3answers
241 views

Converting our budget-strapped dev environment to ESXi - how to maximize availability on the cheap

We've already run through the process of virtualizing our production servers and now we want to do the same with our dev environment. However, our provider took care of all of the ESX host and cluster ...
1
vote
0answers
527 views

Offline Address Book Not Replicating Between Exchange 2010 and Exchange 2003

I have recently installed Exchange 2010 in our Exchange 2003 (SP2) environment. So far everything has been great, until we noticed creating new users does not populate the OAB for people still logging ...
7
votes
1answer
579 views

ZFS replication between 2 ZFS file systems

I initially replicated tank/storage1 --> usb1/storage1-slave (depicted below), and then (deliberately) destroyed the snapshot I replicated from. By doing this, did I lose the ability to incrementally ...
-1
votes
4answers
981 views

Apache replication

I don't know what I need to search for. I need information about how to "replicate" an Apache server, if one would go down another would take over. Also the Apache server holds a lot of data files. ...
1
vote
3answers
4k views

Active Directory Replication across Sites slow or not working

I've just inherited (isn't it always the way!) a Windows Domain. The domain is spread across 2 sites. Site01 has 3 DCs & Site02 has 2 DCs. If I create a user in either site, the other DCs in ...
1
vote
3answers
43 views

database replication for new user signup

I have a database that stores the users of my application. When a new user signs up, a record is inserted into the database for that user. I have a replicated version (slave) of this database (using ...
3
votes
1answer
7k views

DRBD Not syncing between my nodes

Some version info: Operating system is Ubuntu 11.10, on EC2, kernel is 3.0.0-16-virtual and the application info is: Version: 8.3.11 (api:88) GIT-hash: 0de839cee13a4160eed6037c4bddd066645e23c5 build ...
0
votes
1answer
227 views

SQL-Server 2008 : Table Insert and Range Check ?

I'm using the Table Value constructor to insert a bunch of rows at a time. However if i'm using sql replication, I run into a range check constraint on the publisher on my id column managed ...
3
votes
3answers
227 views

What backup method should I choose to backup database on high-load server

I have a mysql (MyISAM) database with size around 30Gb. It has single large table (and some smaller ones but it makes no difference). It performs around 2000 selects (single row by primary ...
2
votes
2answers
342 views

Windows Server 2003: Replication between DC's takes place only after changes are made?

I just finished the 70-294 Kit, and I am left with a huge knownegde gap: The instructor says that replication taked place 15 seconds after a change is made, and 3 seconds addition for any additional ...
3
votes
2answers
3k views

DFS-R alternatives?

I was wondering what alternatives to DFS-R are out there on windows machines for real-time bidirectional file & folder replication? DFS-R requires active directory and a domain controller which I ...
2
votes
1answer
87 views

Strange issue with one CCR node exchange 2007

When I fail over to one of our exchange nodes, the store.exe has a very high CPU. It goes to about 50-60% even with no users connected. With users connected it stays up near 100%. On the other node ...
3
votes
1answer
2k views

Exchange 2003 to 2010 public folder replication

I've found several guides and tutorials on public folder replication from 2003 to 2010, but am still a little bit confused. What we have, is a 2003 exchange server obviously holding all of our public ...
1
vote
1answer
687 views

Very slow MongoDB replica set

I have set up two Mongo instances in EC2 having RAID10. I set up replica set using those two servers and found that this replica is very very slow over network. If I log in locally and issue query ...
3
votes
3answers
3k views

Ubuntu + ZFS: How to migrate entire system to new disks?

Here's my scenario: I have Ubuntu with native ZFS installed on a server with 2 x 500 GB SATA disks. I installed it following this guide: ...
0
votes
2answers
257 views

Fault tolerant DBMail with PostgreSQL Replication - what are my options here?

I'm currently planning a more fault tolerant setup for my organizations Mail setup. We currently have two machines available in different datacenters, that we're planning to use for this, one being a ...
1
vote
1answer
175 views

How hard is it to setup SQL Replication? Can it be done by a Semi SQL User? [closed]

I'm a semi SQL user, not a DBA, just a regular programmer. One of my upcoming jobs require a SQL replication configuration. I have never done such configuration before My colleagues have been ...
4
votes
1answer
291 views

Adding a new location through Active Directory. How should it be done?

Our entire Active Directory forest is currently on a single 10/8 private subnet. We're looking to migrate most of our servers to a cloud provider, but I'm not sure how to set up the first domain ...
1
vote
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 ...
2
votes
2answers
183 views

MSDE 2000 to MSSQL 2008 SQLExpress replication

I have an old database on MSDE which I need to replicate (one-time process) to a new MSSQL 2008 SQLExpress installation. What are my best options to replicate without involving messy sql scripting? ...
0
votes
1answer
1k views

Memcache Master and slaves

I'm using memcached-1.4.5-1.el5 & memcache-2.2.6 as php extension and memcached-1.2.8-repcached-2.2.1 for replication. The above packages are installed on 4 servers. How can I do the following? ...
1
vote
4answers
1k 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
368 views

MySQL init.d script with different configuration file

I have two instances of mysql running on a server. I need two different init.d scripts. The two instances have different configuration files /etc/my.cnf and /etc/my-slave.cnf. I copied the ...
2
votes
1answer
168 views

MySQL Replication: Move slave to be slave of another slave, without any (or least possible) downtime

I have the following setup: M1 = Master 1 S1 = Slave 1 S2 = Slave 2 S3 = Slave 3 Where all slaves are replicating directly from M1. I would like to move S2 and S3 to be slaves of S1. I'm not sure ...
3
votes
2answers
940 views

Safe initial sync for SQL Server OLEDB/ODBC Replication

I am trying to setup one-way, transactional replication from SQL Server 2008 R2 to PostgreSQL 9.1. I'm trying out the PGNP OLE DB provider. I can successfully create a subscription, and transactions ...
2
votes
1answer
5k 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
395 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 ...
10
votes
2answers
1k 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
212 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
490 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
65 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 ...