The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
3 views

Best design of mongo replica set for DB read/write speed

I'm building a Node app that uses MongoDB. Whilst it would probably be fine to have node and mongo sitting on the same VPS, I want to ensure that the MongoDB is backed up and maintain high ...
1
vote
1answer
30 views

How to Configure PostgreSQL Hotstandby Automatic Failover

So I have configured two postgeSQL servers to have hotstand by streaming, now my question is, how can I configure it so that when the master server goes down, the slave server will become the new ...
0
votes
0answers
48 views

SQL Server 2012 Transactional Replication Issue — Table Data not updating at subscriber

In my projects we configured Transactional Replication for my Database - one publisher, one distributor and two subscribers For 2nd subscriber every table data is updating properly But for 1st ...
0
votes
0answers
52 views

mysqldump hung indefinitely - locked tables - replication

I'm new to database programming. I had never written a simple SQL query before but recently I was asked to perform MySql DB replication for our redundant servers. It is a Linux server running as ...
0
votes
0answers
50 views

SQL Server Replication do not replicate DELETE statement

We have two servers A and B. Both of them have SQL Server 2005 on them. A is for data collection, just a "lightweight server". B is for archiving, data manipulation etc. From A to B we have ...
1
vote
0answers
49 views

MySQL SSL Master-Slave replication not syncing

I have originally posted this thread on stackoverflow and after a comment I moved it here. The original post can be found here. I have setup a typical Master-Slave replication scheme for my MySQL ...
4
votes
0answers
254 views

Migrate heroku database to Amazon RDS with minimum downtime

I have a heroku postgres database and want to migrate it to Amazon RDS to save cost. What's a way to do so with minimum downtime? Usually this involves replicating database in real time and then ...
0
votes
1answer
97 views

MySQl master - master replication not working [closed]

I'm trying to setup a master - master setup and I see both masters connect to each other in workbench: server 1: -- Thread Id: 112 -- User: slave -- Host: 207.244.73.38:55164 -- DB: None -- ...
0
votes
0answers
22 views

Alternative for Replication plan

I have a Windows host and some databases on it, but I don't have permission to create Replication Publications and Subscriptions for my databases. I want use replication to sync this database with ...
0
votes
1answer
48 views

Identity Column Behaviour After Replication

Say we have two Servers: Server A and Server B. Data is being replicated (vanilla Transactional Replication) from A to B. For one of the Tables, we have data as follows: Server A - Server B ...