Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [master-master-replication]

In a master-master or multi-master database configuration, each member of the group can store and update data. Updates made to one master are shared with the other masters to keep them in sync. Benefits include increased reliability, and multiple physical server locations.

60 questions
7
votes
2 answers

Multi-Master Multi-Region MySQL Cluster

I am hosting an application (a game) in multiple regions around the globe. Performance is critical to this application since it's a game, and therefore I need to host a database instance in each of these locations that will serve the local…
Opalium
  • 73
  • 1
  • 3
5
votes
2 answers

MySQL - Master to master replication without downtime in Live production

I want to setup 2 node master-master replication. Im aware of the point of failiures in this replication. Its a huge database around 1.5TB. Heavy OLTP is going on. But its mandatory to implement right now. I have 2 servers. 1. Master1 2.…
TheDataGuy
  • 1,986
  • 5
  • 36
  • 67
5
votes
0 answers

Setup to allow creating new tables in PostgreSQL replica

My goal is to create a replica of an existing database that would allow me to create new tables and populate them. I don't care about writes to replicated tables - those can and probably should throw errors. Ideally I would like to accomplish this…
Paperdrone
  • 51
  • 2
4
votes
2 answers

Master - Master replication Duplicate entry error

I've got a Master - Master replication setup and it worked fine for a couple of days but I keep getting: Duplicate entry errors after a few days. My setup is as follows: One server in The Netherlands and one server in Washington D.C. both servers…
gijs007
  • 41
  • 1
  • 1
  • 2
4
votes
3 answers

Migrating 300 GB mysql database from one server to another cleanly with minimum downtime

I have a 300 GB mysql database which i want to migrate to another server in order to setup Master-Master replication between the two and my main aim is to achieve this with least possible downtime. My database has only one table around 30GB where…
Ajay Ganvir
  • 151
  • 1
  • 3
3
votes
1 answer

multiple archive_command in PostgreSQL

I have replication with PostgreSQL, so I want to set archive_command = 'cp %p /var/lib/postgresql/11/main/archive/%f' but I also want to save WAL files to another safe place: S3. So is it possible to have multiple archive_commands? And can I put…
raring-coffee20
  • 149
  • 6
3
votes
3 answers

High disk IO with MySQL master-master replication

We've been evaluating an active-passive master-master replication setup for our MySQL database, running on version 8.0. While diagnosing some general slowness issues, we were surprised to see very high disk IO ranging from 500MB/s - 1500MB/s on both…
billyw
  • 151
  • 5
2
votes
0 answers

Why would my MySQL replica server experience an sql integrity constraint error after losing connection and attempting to start again?

I have a master-master replication setup between two different servers using MariaDB. One is the primary server (server A) that is connected to my web applications, and the other is a replica that would be used for disaster recovery if the primary…
Timothy Fisher
  • 177
  • 1
  • 7
2
votes
0 answers

Issues with failback for logical replication using postgres

I am using PostgreSQL 13 to set up logical replication. When the original active node (A) becomes the secondary, the prior secondary(B) which is now active node needs to sync to the (A) node. To summarize the issue: Node A is active and fails at…
nishi
  • 121
  • 1
2
votes
1 answer

Sync MySql Replication from Master2 to Master1 after failover

Due to Disk space issue Master2 server crashed and it was rebuilt again using mysqldump of Master1. Both Master 1 and Master2 are in sync and Master2 is in Read_only mode. During the crash, I stopped the Slave instance in Master1 and it's been over…
Jos
  • 27
  • 4
2
votes
2 answers

MariaDB/MySQL SSL Replication Failure

After searching for a solution for the last 6 hours, I have come up dry in my attempt to add SSL to the replication. I managed to get it to connect with SSL via the mysql command line tool without issues, however I cannot seem to solve this…
Timberwolf
  • 133
  • 1
  • 5
2
votes
1 answer

How to setup two mysql servers with group replication to work individually, when no network

I have two mysql servers in two different places. Both servers must be able to read and write. All tables are designed to based on unique id (UUID) primary key. I want to sync these two databases live using a replication method when networks are…
LahiruTM
  • 146
  • 7
2
votes
1 answer

Mysql database replication with geo-distributed servers

I am just a developer, who doesn't have deep knowledge in DBA. So need experts suggestions in this. I have two offline databases in two cities, I want to make a synchronization between two databases using a third database which will be stay alway…
nixon1333
  • 145
  • 6
2
votes
1 answer

Avoiding infinite loop in a master-master replication

As an exercise, I am implementing a master-master replication in PostgreSQL, using triggers (requirement of the task). Basically there are 2 databases with tables that have almost exactly the same structure. How do I avoid going into infinite loop?…
syntagma
  • 163
  • 1
  • 4
2
votes
0 answers

Fault tolerant cross datacenter MySQL replication & failover strategy

Which of the following method is the most fault tolerant way to achieve cross datacenter MySQL replication using DNS failover and why? MySQL master-master replication with one primary/active node and the other acting as hot spare. When the active…
Pavin Joseph
  • 121
  • 4
1
2 3 4