Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
The results are in! See what nearly 90,000 developers picked as their most loved, dreaded, and desired coding languages and more in the 2019 Developer Survey.

Questions tagged [master-master-replication]

1
vote
1answer
35 views

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 ...
0
votes
1answer
43 views

help understanding galera consistency (certification-based replication)

Galera uses a certification-based replication to achieve strong consistency. While doing a transaction after doing a COMMIT the other nodes will certify it and if is ok it will be successfully ...
0
votes
1answer
23 views

MySQL Replication ignore few columns

I have setup MySQL replication, is there a way to skip replicating one column or multiple columns from few tables?
0
votes
1answer
54 views

How to solve replication in MongoDB only with two machines?

I have two machines connected in a ring network, each one running Wildfly in HA mode using JGroups ant MongoDB in HA Mode using Replica Set. The machine 1 is the primary and machine 2 is secondary. ...
0
votes
1answer
36 views

Auto increment gap in percona xtradb cluster master master setup

I was using mariadb 5.5 before but now I have upgraded it and using percona xtradb cluster 5.6 I have 3 nodes cluster. I am only using single node for read and write. I saw some increment gaps in ...
0
votes
1answer
22 views

What's the difference between Replicate_Wild_Ignore_Table & Replicate_Ignore_Table?

In my site's master/slave setup: Replicate_Wild_Ignore_Table = %.cache%, & Replicate_Ignore_Table is empty. What's the difference between the two?
0
votes
1answer
66 views

Mysql Slave Claims to be Running but New Records Not Appearing and No Delay

I've created a new mysql master and a slave. My master is also a slave of another running instance. The replication between those two works fine so I don't believe my issue is there. I created a dump ...
1
vote
3answers
284 views

Mysql master-master: single table out of sync

I have a master-master MySQL 5.7, everything works fine except for one error which is rising from time to time. If I run a show slave status\G on server2 I have an error on a table: ... Last_Errno: ...
1
vote
0answers
115 views

SQL Server with peer-to-peer replication migration from on-prem to AWS EC2 instances

I need to move three on-prem servers with peer-to-peer replication to AWS. SQL Server version is 2012. The AWS SQL Server will be on EC2 instances as the SQL Server RDS doesn't support replication yet....
0
votes
1answer
83 views

Master_ master replication on Mariadb

I have a nagios application running on 2 servers, i am planning to have have master-master replication for HA. for master-slave replication, slave should be read-only. in this manner is there any pre-...
3
votes
3answers
314 views

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 ...
1
vote
1answer
141 views

Setup replication between two Galera nodes

I've been using MariaDB 10.2 Galera with 3 nodes successfully on local servers. Now, I have a second 3-nodes Galera cluster on another location, joined by an Site-to-Site IPSec Tunnel. I can't really ...
-1
votes
1answer
82 views

MySQL Replication Relay for Peer-to-peer replication for Multi-master replications [closed]

Any one knows about MySQL Replication Relay for Peer-to-Peer Replication for Multi-master replications? Please share if you know anything with example and syntax for multiple clients with as masters ...
1
vote
1answer
379 views

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 ...
0
votes
2answers
285 views

Add database to existing MySQL master-master replication which uses binlog_do_db?

We have 2 Mysql 5.7 servers running in master-master replication mode. And there is a database replicating between these 2 servers: binlog_do_db = database1 Now we need to add a new database into ...
0
votes
1answer
140 views

MariaDB 10.2 Encrypted at rest log files not being written

We're running MariaDB 10.2 with InnoDB tables that are encrypted at rest. I've also specified that the log files be encrypted at rest but they remain empty files. The tables seem to be encrypted just ...
0
votes
1answer
190 views

Replicate data between MySQL servers with a different structure

As part of a system upgrade I need to sync a database between 2 different servers (master-master). The catch is that the structure is slightly different between the 2. Most of the differences are:- ...
4
votes
3answers
1k views

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. ...
0
votes
1answer
338 views

Master-Master replication MariaDB failover resync

I'm working on a project to replicate two sites running MariaDB 5.5 version. Replication works flawless until a host restarts, losing connection still works after reconnecting. When the node restarts ...
1
vote
1answer
658 views

Galera multi-nodes Master-Master issue with READ right after INSERT

I have a multi-nodes Galera setup which is master-master. An API call to a web server A could write data to either database 1, 2, 3 or 4 (we are not using HaProxy). Another API call right after that ...
0
votes
1answer
294 views

Can drbd be used for mongodb replication or active/passive setting?

From this guide we know DRBD can used for PostgreSQL Active/Passive setting: https://www.howtoforge.com/how-to-set-up-an-active-passive-postgresql-cluster-with-pacemaker-corosync-and-drbd-centos-5.5-...
3
votes
1answer
221 views

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 ...
3
votes
2answers
2k views

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 ...
0
votes
1answer
46 views

SQL Database mirroring \ replication capabilities? [closed]

I've looked through the similar questions, but they are a little further down the line, more into details already. While I'm still researching the concept of mirroring and what can and can not be ...
3
votes
0answers
350 views

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 ...
2
votes
0answers
52 views

Fault tolerant cross datacenter MySQL replication & failover strategy [duplicate]

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 ...
1
vote
0answers
180 views

Master-slave + master-master replication at the same time

Can a MySQL database which is doing master-slave replication to a number of slaves be configured to do master-master replication to a new server at the same time? I have an application that has a ...
0
votes
1answer
238 views

Write on MySQL master-master replication

I have set up MySQL MM replication and they work well. I also know that it's not good to write simultaneously on both servers since it may cause inconsistency. However, I wonder if I write on both ...
2
votes
2answers
10k views

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 ...