Stack Overflow
Stack Overflow

Questions tagged [multi-master-replication]

102 questions
0
votes
2 answers

Which replication mechanism to chose in distributed system?

Having tough time in understanding few things. I have two replicated service host (A & B) (may be scaled to a max 3 in future) behind a gateway. Each service host needs to save some data/state (key-value) of its respective host. To avoid SPOF, the…
Rahul
  • 326
  • 2
  • 10
0
votes
1 answer

Postgres 12 logical replication to sometimes connected subscribers?

I've been asked to setup a Postgres 12 system with 2 servers. One local and one downrange with very unreliable network connectivity. We need to replicate data between the two systems with a multi-publisher setup. Will either native logical…
JimF
  • 139
  • 2
  • 13
0
votes
1 answer

PostgreSQL database replication failure because of duplicate key violation

I've configured two RHEL machines with redundancy configuration (master- master setup) with below software versions. Database: PostgreSQL 9.5 Bucardo: Bucardo 5.4 Database replication goes smoothly till some point of time, After that replication…
Prasad
  • 11
  • 4
0
votes
0 answers

openlap 2.4 syncrepl with tls

I have syncrepl all working for the config database and the ldap database, let just concentrate on the ldap database. in this solution we require encryption between consumer and provider in a multi master configuration. i have this working all well…
Ibrarhussain187
  • 1
0
votes
0 answers

Multi Node Cluster in Postgres

Is there a way we can setup multinode cluster in Postgres like Oracle RAC: Oracle RAC allows multiple computers to run Oracle RDBMS software simultaneously while accessing a single database, thus providing clustering. So far I went through several…
Swaroop
  • 31
  • 2
0
votes
1 answer

Python mysql replication client not showing values

We are using a Galera cluster for MySQL 5.6. We have been using python mysql replication client (https://github.com/noplay/python-mysql-replication) to keep track of all changes to DB mainly for debugging. This used to work fine. We got data that…
kargirwar
  • 536
  • 2
  • 7
  • 19
0
votes
1 answer

mariadb replication with data sharding and clustering

We have set up three node mariaDB galera cluster, which is basically a multi-master and does the synchronous replication of data across the nodes in the cluster.Eventually , the read/write can be performed through any nodes in the cluster. However ,…
Karthik
  • 1
  • 2
0
votes
1 answer

Different select results when using multimaster via pglogical in PostgreSQL

There are two PostgreSQL 9.6 nodes subscribed to each other via pglogical. If node A inserts a row into the replicated table then node B sees it and vice versa. However, when I update a row on one node, then subsequent SELECT queries on both nodes…
Henry Barker
  • 784
  • 1
  • 5
  • 9
0
votes
1 answer

How to obtain full collection throughput in a CosmosDB Multi-Master environment where partitionKey already has high cardinality?

Overview I have a user registration / onboarding flow that I am currently trying to optimise and better understand before scaling out to much larger load tests. Test Collection: (500 RU) PartitionKey: tenant_email Multi-Master: 5 Regions Below is…
Joshua Hayes
  • 1,938
  • 2
  • 21
  • 39
0
votes
1 answer

how to set up mongodb replication where you have 3 web servers being used to load balance?

We have plans to set up a web solution in 3 locations... fronted by a load balancer that will distribute based on the location of the client. So if the request for the web app is coming in from north america, we will route to the north american…
dot
  • 14,928
  • 41
  • 110
  • 218
0
votes
1 answer

OpenLdap replication

I'm working with openldap, every day i purge my ldap server and i import an ldif file. i have a master slave replication, so when i delete entries and import file, the slave delete all entries and update data and that was the problem, users can't…
MR ROBET
  • 1
  • 2
0
votes
0 answers

does galera setup cause db down and slower db read?

recently I realized after I setup master to master replication using galera, my db seems to be loading slower than usual. Also, sometimes it cannot be connected. I am currently using django and I have it setup that if main DB cannot be connected…
Dora
  • 6,776
  • 14
  • 51
  • 99
0
votes
0 answers

Questions About Load Balancing ProstgreSQL 9.6

I have a question regarding streaming replication in Postgres. I have this one DB server that runs Postgres and it's heavy on both reads and writes(runs bulk inserts, large selects, minute to minute etc.). I'm trying to find a strategy to handle the…
user8256294
0
votes
1 answer

MySQL Multi-Master Replication multi location

I have a database which runs in two remote locations. (A & B) The server is available locally on one location (A). However, the second location (B) accesess the database over the internet. Incase the internet at location A is down, Location B looses…
Ashwin Gupta
  • 1
0
votes
1 answer

Stop BDR from replicating DROP TABLE or CREATE TABLE

I have two databases with tables that I want to sync. I don't want to sync any other table. I'm using Postgres-BDR to do that. Those tables are part of replication set common. There are some circumstances where other tables share a name across nodes…
ABeard89
  • 911
  • 9
  • 17
1 2 3 4
5
6 7