Stack Overflow
Stack Overflow

Questions tagged [database-replication]

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.

Database replication can be used on many database management systems, usually with a master/slave relationship between the original and the copies. The master logs the updates, which then ripple through to the slaves. The slave outputs a message stating that it has received the update successfully, thus allowing the sending (and potentially re-sending until successfully applied) of subsequent updates.

1836 questions
0
votes
0 answers

Not able to connect to mongodb replica set running in docker in different machine

I am using mongo server in which there are three dockers that are running and another one which maps all the three mongo dockers and creates replica from them. Config for same is: mongo1: build: mongodb/ hostname: mongo1 expose: - "27017" …
Akansh Agrawal
  • 1
  • 1
0
votes
0 answers

SQL merge replication - Violation of PRIMARY KEY constraint on download only table

Recently some synchronizations have been failing. The last message shown in the replication monitor and in their local replication logs is: The process is waiting for a response from the query '{call …
nycfdtd
  • 404
  • 7
  • 23
0
votes
2 answers

Replica - MongoDB EC2 instances

Added 3 EC2 instances in in AWS cloud. Installed 3 MongoDB instances in 3 different instances and all are running fine. I am adding replication for the same DBs. below are the steps i followed: sudo service mongod start --sslPEMKeyFile…
Chowdappa
  • 1,580
  • 1
  • 15
  • 31
0
votes
1 answer

how to manage user sessions in distributed databases?

Since i have zero experience in developing web applications which can be scaled up horizontally, i need someone with experience guide me in right direction. I had difficulties to figure out the right way of storing login sessions in database, so i…
Mike Brown
  • 3
  • 1
0
votes
1 answer

Replication, how to encrypt a column at subscription side and keep publication side non-encrypt?

In replication case. Instance B pull some tables from instance A(for other users). I want to encrypt a column of one table in instance B (But don't want to encrypt the original table at instance A). How can I make this work? When I try to encrypt…
Nexus Roc
  • 1
0
votes
2 answers

What solution can I use for MySQL replication across cities?

We are looking into options for our MySQL replication architecture, the relevant details of our current setup: We manage several branches on different cities. Every branch has the same database structure. Every primary key on all tables are…
kR105
  • 864
  • 9
  • 15
0
votes
1 answer

Test Connections Between all Members Fails

I am setting up a replica set of three members in mongodb. All three members of replica set are running mongod instances Active: active (running) But when i try to check the connectivity using mongo --host 172.x.x.x --port 27017 by following the…
Abdul Moiz
  • 1,317
  • 2
  • 17
  • 40
0
votes
0 answers

How to setup clustering in Postgresql?

Do I have to setup replication to have clustering setup in PostgreSQL? Can I not have just clustering setup in two servers. PostgreSQL 9.1 Ubuntu 12.04
Pavan Teja
  • 21
  • 3
0
votes
3 answers

Options for a secondary SQL database

I have a VM in Azure running a single SQL Server instance. I also have recently setup Power BI to refresh from this source at 1am every morning. Unfortunately, this refresh is causing performance issues, where all queries/operations are timing out…
RPM1984
  • 72,246
  • 58
  • 225
  • 350
0
votes
1 answer

distributed postgres deployment out of sync

I setup a distributed postgres database system and configured replication using hot_standby wal_level. There is one central master database in place with multiple replicas (15 currently across the world) that are used as read only instances - so no…
roegi
  • 183
  • 1
  • 16
0
votes
0 answers

How to stop replication in SQL Server 2012 using code

I want to add column in a table but this message appears: 'Students' table - Unable to modify table. The data definition language (DDL) command cannot be executed at the Subscriber. DDL commands can only be executed at the Publisher. In a…
Alnebras Murtada
  • 13
  • 8
0
votes
1 answer

Postgresql server to server replication

Say I have two remote servers 10.0.0.1 and 10.0.0.2. In both the servers I have postgresql database installed with the same databases. Now what I need is, whatever changes or alterations that are done to the database on server 10.0.0.1 should…
Karthik
  • 629
  • 2
  • 8
  • 12
0
votes
0 answers

How to have a replication of a live database on an offsite using Postgresql?

I have a live server running on postgres 9.5. I would like to have an offsite replication of the same database hosted on a cloud server (Let's call this the standby server). We are okay with anywhere between 10 minutes to even 1 hour of delay…
Kim Stacks
  • 10,202
  • 35
  • 151
  • 282
0
votes
1 answer

Database Replication Software

I've seen a few questions related to softwares that replicate data on databases but I haven't seen one that might work for my needs. I need to replicate many slaves to a single master. The master will have all the data from the slaves merged into…
Tacitus86
  • 1,314
  • 2
  • 14
  • 36
0
votes
1 answer

What is the best of two approaches to achieve DB Replication?

we have two approaches to achieve DB Replication: Master-Master replication. Master, 1 Primary Slave, 1 Secondary slave. I am planning to analyze these two approaches and prepare a comparison report with a recommendation.Currently, I have setup…
vijay.shad
  • 2,444
  • 6
  • 27
  • 33
1 2 3
…
99 100