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.
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 ...