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
9
votes
2 answers

Is it safe to compact a CouchDB database that has continuous replication?

We have a couple of production couchdb databases that have blown out to 30GB and need to be compacted. These are used by a 24/7 operations website and are replicated with another server using continuous replication. From tests I've done it'll take…
DaveO
  • 1,909
  • 4
  • 33
  • 63
9
votes
2 answers

PostgreSQL replication to Amazon RDS

Amazon recently introduced PostgreSQL support for their Amazon RDS service. I was wondering if this scenario could be possible: Setup a PostgreSQL instance on Amazon RDS Install PostgreSQL on my VPS Setup replication so that any changes I make on…
Jamie
  • 657
  • 7
  • 18
9
votes
1 answer

MongoDb arbiter can be used with multiple replicaSets?

If I have different webpages for differents countries and each webpage have a mongodb replicaSet of 2-3 nodes, can I use an arbiter with more than one replicaSet so it votes in all? Or I need to initiate an arbiter per replicaSet?
Wiliam
  • 3,714
  • 7
  • 36
  • 56
8
votes
1 answer

Where can I find the file my.cnf or my.ini file?

I've read about MySQL replication and i need to change some configuration but I can't find the file my.cnf or my.ini. I don't know which MySQL version I have but I've downloaded it a long time ago, as a .zip. My box runs Windows 7 64. Where can i…
cudalanda
  • 83
  • 1
  • 1
  • 3
8
votes
3 answers

Does AWS load-balance connections between master and read-replica DB

I created a read-replica for an RDS instance, Does AWS handles the load-balancing automatically or it needs another configuration or implementation in the code ? and if so Is there a reference for that ? Edit for more clarification When I create a…
t2149573
  • 335
  • 1
  • 3
  • 10
8
votes
2 answers

Microservice data replication patterns

In a microservice architecture, we usually have two ways for 2 microservices to communicate. Let’s say service A needs to get information from service B. The first option is a remote call, usually synchronous over HTTPS, so service A query an API…
Fabio
  • 3,020
  • 4
  • 39
  • 62
8
votes
3 answers

How to safely discard golang database/sql pooled connections, for example when they point to a read-only replica?

We have been using golang's database/sql and github.com/lib/pq with a PostgreSQL cluster, meaning that a certain database server that was a replication master might be a read-only replica after the previous master has failed. Recently, our low-usage…
borellini
  • 365
  • 5
  • 13
8
votes
6 answers

Replicate Master DB to Different Slaves

I have a master database which would be the cloud server that consisted of different schools. Dashboard type that has the details of each school. Can edit their information and other data. Now those schools are deployed to their corresponding…
Wesley Brian Lachenal
  • 4,381
  • 9
  • 48
  • 81
8
votes
3 answers

Stop PostgreSQL streaming replication

I want to make my PostgreSQL master / slave streaming replication setup into a single master slave setup without replication and without HA. How is it possible to tell master that it no longer has slave and it should not replicate its data to the…
user1409708
  • 953
  • 2
  • 11
  • 20
8
votes
3 answers

Mongoose not reading from Mongo secondary database

I've implemented a replica set that I'm using globally. I have my master in Oregon, US and 4 secondaries. California and Virginia, Frankfurt and Sydney. I also have web servers in those same regions as well. Those web servers connect to mongo using…
Josh Elias
  • 3,250
  • 7
  • 42
  • 73
8
votes
2 answers

What is syncobj in SQL Server

When I run this script to search particular text in sys.columns and I get a lot of "dbo.syncobj_0x3934443438443332" like rows. SELECT c.name, s.name + '.' + o.name FROM sys.columns c INNER JOIN sys.objects o ON c.object_id=o.object_id INNER JOIN…
hgulyan
  • 8,099
  • 8
  • 50
  • 75
8
votes
1 answer

Can MongoDB instance be a member of multiple replica sets?

I would like to know if it is possible to have one mongoDB instance that belongs to two replica sets. E.g: ReplicaSet1 has members 10.10.1.1 and 10.10.2.1 ReplicaSet2 has members 10.10.1.1, 10.10.1.2 and 10.10.1.3
user1584660
  • 856
  • 6
  • 6
8
votes
2 answers

MongoDB - how to handle write failures during primary re-election with Spring?

I configured my MongoDB replica set with Spring, and I'm trying to test the auto-failover. I know that if the primary goes down, it takes a few seconds for a new primary to be elected, so in that time period, all writes will fail. I have a test…
Ayelet
  • 1,713
  • 9
  • 29
  • 43
8
votes
0 answers

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 interaction of transactions with the database utilization…
kanishk
  • 713
  • 4
  • 15
  • 31
8
votes
2 answers

Replicate Microsoft SQL to other databases

I'd like to be able to replicate an entire database from Microsoft SQL to another web friendly database such as CouchDB or even mySQL. I'd need to do replication daily and was just wondering if it's possible and if so, how would I do it with the…
Eish
  • 1,051
  • 1
  • 9
  • 16
1 2 3
…
99 100