Database replication is used to ensure consistency between redundant databases and to improve reliability and increase fault-tolerance. The replication process commonly involves continuously duplicating a "master" database to one or more additional "slave" databases.

learn more… | top users | synonyms

2
votes
0answers
97 views

How efficient is Meteor's DDP at syncing very large collections?

Meteor's DDP protocol works very well for syncing a small collection of data from a server to a browser-based client, which inherently limits the amount of data that is processed. However, consider a ...
2
votes
0answers
178 views

MySQL Replication: struggling with replicate-rewrite-db to change the database name

I have my master database with the one table in it, products (will have more later, this is just dev). OS: CentOS 6.4 I have set it up as the master for replication using this: In /etc/my.cnf: ...
2
votes
0answers
817 views

SQL Replication 'The process could not connect to Subscriber'

I have three servers, all Windows 2008 + SQL Server 2008 R2: Server 'A' Server 'B' Server 'Z' A and B are publishers, Z is a subscriber to both A and B. The subscriptions are configured in 'Push' ...
2
votes
0answers
81 views

Use NHibernate generated sqls to sync with read-only database

I'm trying to leverage a sync mechanism inside my application, I need to provide read-only database throughout my application since my data is not frequently updated (for performance and scalability ...
2
votes
0answers
116 views

Microsoft Merge replication for Android and iOS

Microsoft Sync Toolkit is extensible by design and allows you to connect databases on Android and iOS clients to sync. Can you get Merge replication to work with iOS and Android?
1
vote
0answers
24 views

initiate of replica set make unavailable db for long time - mongoDB

I have the big database with 35m documents and 11GB size. I want to create replica set for it. so i should rs.initiate(), first. As you know since set --replset to rs.initiate() completion, mongod ...
1
vote
0answers
126 views

What is the difference between passive master and slave in mysql replication?

There are several ways to configure mysql replication. I know how to configure the replication cluster to use master-master-active-passive model or master-slave model. If I configure passive master ...
1
vote
0answers
24 views

Oracle Advanced Replication - Remote Packages Under Permanent Access

As descriped in the documentation it seems to be possible to replicate packages (spec and body) beside other database objects. But what will happen if the packages of the remote database (slave) are ...
1
vote
0answers
142 views

How to implement real-time replication of MongoDB (or CouchDB) to many remote clients

I'm considering how to design a mechanism for replicating a (potentially large) MongoDB or other NoSQL (CouchDB, etc) database to dozens of clients at once. The clients would function like a replica ...
1
vote
0answers
298 views

Mongodb exists after claiming that there is no disk space while disk was not full

We run a Replicaset with 2 Datanodes and an Arbiter. The Secondary failed at 03:29 on saturday claiming that there is no disk space ==> error 28. Although there were about 200 GB of space left on the ...
1
vote
0answers
32 views

django database routing with transactions

Referring to the example in Django documentation for multiple databases in one application, https://docs.djangoproject.com/en/dev/topics/db/multi-db/#an-example " It also doesn’t consider the ...
1
vote
0answers
107 views

Sql Sync over internet

What is the best solution to sync tables between Servers over the internet? Situation is that there is one SQL- Server lets say "Main", and a lot of SQL-Servers "Crowd", which all got the same ...
1
vote
0answers
35 views

Replicate EAV data model as Conventional data model and use Conventional model for querying in SQL Server

We have an EAV database model built on SQL Server 2008. Knew about the performance problems with EAV before choosing EAV (benefits from EAV outweighed performance problems). To reduce performance ...
1
vote
0answers
49 views

Order Publisher table after replication

I've got two database servers. The remote server replicates to the local server. The data that is sent is basically an XML description of transactions. The two database servers compile this XML data ...
1
vote
0answers
314 views

Rubyrep with Postgres-> PG::ERROR: Connection is closed when trying to scan

I setup the rubyrep config file with the server information. No extra options. I tested if i could connect to both databases externally with PGAdmin. When I try it out I see the connection spike on ...

15 30 50 per page