Stack Exchange Network

Stack Exchange network consists of 174 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

Questions tagged [master-master-replication]

1
vote
0answers
10 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
29 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
17 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
46 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
32 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
15 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
46 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
204 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
86 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
69 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
273 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 ...
0
votes
0answers
250 views

Should we use slave_pos or current_pos with MariaDB 2 node GTID master-master replication?

We are currently migrating our DB cluster from "traditional" binlog based replication to GTID based one. We use MariaDB 10.1.31 and the topology is pretty straight forward - 2 nodes each is master and ...
1
vote
1answer
119 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
74 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
334 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
257 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
130 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
173 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
319 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
559 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
260 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
208 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
1answer
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 ...
-1
votes
0answers
59 views

Multimaster MySQL behind keepalived problems?

I used MySQL about an hour, and need to setup a multi master infrastructure. Why shouldn't I start multimaster MySQL under a load balance? Can LB flapping and replication lag cause a freeze state.
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
329 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
46 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
175 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
223 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
9k 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 ...