Stack Overflow
Stack Overflow

Questions tagged [multi-master-replication]

102 questions
12
votes
1 answer

Heroku multi region support

Does Heroku offer multi region support for it's implementation? I'm specifically interested in a master-master database setup in multiple AWS regions. Thanks
Jon
  • 3,985
  • 7
  • 48
  • 80
9
votes
6 answers

Amazon RDS MySQL and Master-master replication

I can't find it from documentation, but it seems Master-Master replication is not supported at this time. Is this correct?
DmitrySemenov
  • 9,204
  • 15
  • 76
  • 121
5
votes
1 answer

How to create read replicas from multiple postgres databases into a single database?

I'd like to preface this by saying I'm not a DBA, so sorry for any gaps in technical knowledge. I am working within a microservices architecture, where we have about a dozen or applications, each supported by its Postgres database instance (which is…
icki
  • 51
  • 1
  • 2
5
votes
1 answer

Does Redis support master-master replication?

From my understanding from the below questions which were asked quite some time back, Redis doesn't have a built-in support for master-master replication. Question 1 Question 2 Question 3 The official website as of now looks like there is nothing…
Caroffrey
  • 235
  • 3
  • 10
4
votes
2 answers

Multi Master vs Peer-to-Peer DB Architectures

My understanding is that in a multi-master DB architecture: You have 2+ DB servers, both acting as read/write masters; and It either up to some type of load balancer to balance operations across these multiple masters; and Whenever a server gets a…
smeeb
  • 27,777
  • 57
  • 250
  • 447
4
votes
2 answers

Load Balancing using HAProxy for Postgresql 9.4

I have made a setup of multi-master replication of PostgreSQL using BDR (Bi-Directional Replication) among 4 nodes (virtual machines). Now i want to put a load-balancer for High Availability. For this i have installed and configured "HAProxy" on a…
Devesh Dashora
  • 61
  • 1
  • 1
  • 5
4
votes
3 answers

MySQL architecture. When multiple users have a local database and all sync to a cloud one

I am creating this web application in Node.js and MySQL and I am struggling on data synchronisation. Here's the scenario: Suppose we have 1000 customers that all have a local webserver-database in their office/site. A user can login, edit data,…
opcode
  • 419
  • 5
  • 11
3
votes
1 answer

Deadlock on MTS replication

Situation: we have a master-master-replication using GTIDs on Percona MySQL 5.6.32-78.1. On server, there are about 10 databases and we've set slave_parallel_workers=5. One server is used for frontend handling and one for backend. Two or three times…
rabudde
  • 7,498
  • 6
  • 53
  • 91
3
votes
3 answers

How to fix Multi-Master Replication Error in MariaDB

I have a Multi-Master Ring Replication setup in MariaDB. 3 Servers. One of my server's ran out of disk space and I eventually needed to restart the server. Now after doing that the two slave servers are reporting this error in the slave…
Wasca
  • 81
  • 1
  • 5
3
votes
2 answers

MySQL Multi-master replication

We have some (10-) MySQL server nodes and we want them to be replicated in a way that if one goes down the rest never get affected. I know MySQL provides Master/Slave (not good for us) and Multi-Master replication. Does MySQL Multi-Master…
ehsun7b
  • 4,796
  • 14
  • 59
  • 98
2
votes
1 answer

MySQL slave replication not writing binlog file

I have installed 3 MySQL Server (8.0.29-0ubuntu0.22.04.2) to create a master-slave replication like Master -> Slave -> Secondary Slave My issue is when i change database in master it is replicated in Slave by binlog writen by Master but that change…
Kavin Kumar
  • 73
  • 5
2
votes
0 answers

How to effectively use Galera Load Balancer with JDBC URL?

I am going to use Galera Load Balancer for Java JDBC URL for a multi-master Galera DB cluster. What are the correct states for that? My JDBC URL is like this: jdbc:mariadb:loadbalance//10.0.0.4:3306,10.0.0.5:3306/mydb?galeraAllowedState=4,2 Is it…
user15012700
2
votes
0 answers

Postgresql 10.x how to configure Master - Master replication

I need to configure Master - Master Postgresql replication servers. I guess psql 10 or 11 will be used for this. But I can`t find any information about master-master configuration, only master-slave. Here is a quick example for logical replication…
prosto.vint
  • 1,403
  • 2
  • 17
  • 30
2
votes
2 answers

PostgreSQL 10 logical replication trigger function not executed

I've implemented the Logical replication in PostgreSQL 10 within 2 db in 2 different server and I'm aware that the sequences are not sync so I created a trigger function like this in both database: CREATE FUNCTION update_ogc_fid() RETURNS…
Seba
  • 617
  • 1
  • 8
  • 33
2
votes
1 answer

How does CosmosDb charge RUs for write operations in a multi-master enironment?

Multi-Master Database with single region: SDK reports ~10 RU to perform a write operation Multi-Master Database with 5 regions:: SDK reports ~46.86 RU for the same operation (~5x to incorporate replication to all regions. Makes sense) If you have a…
Joshua Hayes
  • 1,938
  • 2
  • 21
  • 39
1
2 3 4 5 6 7