Questions tagged [master-master-replication]

The tag has no usage guidance, but it has a tag wiki.

Filter by
Sorted by
Tagged with
2 votes
0 answers
14 views

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 ...
user avatar
0 votes
1 answer
76 views

do_table or ignore_table alternatives on MariaDB Galera Multi-Master

As far as I can see, there are no do_table or ignore_table configs in MariaDB Galera multi-master (master-master) to skip or ignore specific tables. And there are only binlog_do_db and ...
user avatar
  • 3
1 vote
3 answers
722 views

How to Sync MySQL Databases when offline?

My application that is running on a client uses a MySQL database running on a server. So multiple clients are connected to the same server. That works well when the server is online. But now I would ...
user avatar
  • 111
1 vote
3 answers
233 views

Getting fatal error 1236 from master when reading data from binary log in mariadb master master replication

I am facing the situation similar to this Error 1236 - "Could not find first log file name in binary log index file" I have tried all the answers but I am still not able to get rid of this ...
user avatar
2 votes
0 answers
45 views

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 ...
user avatar
  • 121
-1 votes
1 answer
117 views

Error in Master/Master replication between Mysql 8 and Mysql 5.6

I've setup master to master replication Between a Mysql 5.6 and Mysql 8.0 server. I can get both slaves to run on both servers. Except when there is a change made on the Mysql 8.0 server (e.g. ...
user avatar
  • 1
2 votes
1 answer
29 views

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 ...
user avatar
  • 27
0 votes
1 answer
102 views

How to change MySql Master-Master Replication to Master-Slave Replication

I currently have MySql Master-Master replication set-up with Read_only on Master2. There were lot of sync issues so I've stopped replication from Master2 to Master1 by stopping the Slave in Master1. ...
user avatar
  • 27
0 votes
1 answer
174 views

MySql Master Master out of sync

I have 2 MySql nodes with Master-Master Replication set-up. MySql1 has read and write access and is in current state. MySql2 has only read access and stopped working due to space issue. How can I fix ...
user avatar
  • 27
0 votes
1 answer
2k views

is Sql Server AlwaysOn AG a multi-site active-active replication technology? [closed]

Scenario FCI: I understand multi-site active-active replication in SQL Server can be installed with an FCI (Failover Cluster Instance). The replication part occurs at the storage level with a ...
user avatar
1 vote
1 answer
262 views

Why is disk IO higher on Debian 10 (MariaDB 10.3) with MySQL replication?

I have a MySQL/MariaDB master-master replication setup that has been working well for several years, the db and tables are not very large (under 200MB for 18 tables). These were on 2 servers running ...
user avatar
0 votes
1 answer
34 views

How to configure MySQL master master replication but use only one server for writing? [closed]

How to configure MySQL master master replication but use only one server for writing? Is it done at LB end and how? If two users work on same db and same table and they both enter a data into it which ...
user avatar
1 vote
2 answers
160 views

MySQL master to master race conditions, do I need to use transactions/locks for this code?

I'm playing around with master to master MySQL replication hoping I can run two copies on my C# application on two different servers to help improve performance. Rather than the one copy on one server ...
user avatar
  • 121
0 votes
1 answer
41 views

Do I need to redesign my Database and get rid of foreign keys for successful replication?

I plan to set up MariaDB replication either in master-master or master-slave mode. The main issue I have now are worries after reading this documentation. We use foreign keys a LOT and we also use a ...
user avatar
  • 115
1 vote
2 answers
372 views

Tuning MySQL on GROUP REPLICATION

I'm close to switch from old version of MySQL 5.6 ( master / slave configuration ) to MySQL 8 ( 3 nodes on multi-master configuration ) in GROUP REPLICATION. The tables are 99% InnoDB. The webfarm ...
user avatar
  • 11
0 votes
0 answers
22 views

after running Galera Replication for MariaDB , performance (TPS) does huge diffrence [duplicate]

I have two VM machines (with exact hardware-software configuration on two ESXI Servers in same rack and same subnet too) that is running with nginx + PHP-FPM + and MariaDB 10.4. in each ESXI server I ...
user avatar
0 votes
0 answers
339 views

How to implement master-master replication in PostgreSQL?

I am working on a project which requires my database client to scale horizontally for higher availability but it is required to use RDBMS for our solution. Therefore, we want to implement master-...
user avatar
3 votes
1 answer
596 views

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

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 ...
user avatar
  • 23
2 votes
2 answers
731 views

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 ...
user avatar
0 votes
0 answers
58 views

MySql 5.7 master-master (restore a master by replication vs dump)

We have MySql 5.7 running in Centos 7 in cloud environment. We have the master-master working properly. One master gets the writes which replicates to the other master. The second master is a hot ...
user avatar
1 vote
0 answers
3k views

Slave I/O for channel error connecting to master Error_code: 2003

i am trying a master master replication mysql with phpmyadmin using wamp server. everything seems to be fine, the configuration was well done, so the server is slave and master at the same time , but ...
user avatar
  • 11
0 votes
0 answers
69 views

Do I need client or server cert for mySQL master/master replication?

WE use pkitool to sign any certificate using our own CA and there are two options to sign a certificates: using --sign, which creates a client-cert Using --server, which creates a server-cert The ...
user avatar
  • 101
0 votes
0 answers
75 views

How can I keep both MySQL databases consistent in master-master replication after recovering from failed event?

I was given a task to fix the sync issue between 2 database servers where I had two MySQL database servers set up with master-master replication. They were working normally but one of the servers was ...
user avatar
2 votes
1 answer
256 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 ...
user avatar
  • 146
0 votes
1 answer
290 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 ...
user avatar
  • 139
0 votes
1 answer
403 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?
user avatar
0 votes
1 answer
174 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. ...
user avatar
-1 votes
1 answer
202 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 ...
user avatar
  • 3
0 votes
1 answer
353 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?
user avatar
  • 103
0 votes
1 answer
385 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 ...
user avatar
1 vote
3 answers
2k 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: ...
user avatar
1 vote
0 answers
303 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....
user avatar
0 votes
1 answer
459 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-...
user avatar
3 votes
3 answers
824 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 ...
user avatar
  • 151
1 vote
1 answer
245 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 ...
user avatar
  • 11
-1 votes
1 answer
242 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 ...
user avatar
  • 99
2 votes
1 answer
711 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 ...
user avatar
  • 145
0 votes
2 answers
613 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 ...
user avatar
0 votes
1 answer
209 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 ...
user avatar
  • 1
0 votes
1 answer
517 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:- ...
user avatar
4 votes
3 answers
5k 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. ...
user avatar
0 votes
1 answer
493 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 ...
user avatar
  • 1
1 vote
1 answer
2k 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 ...
user avatar
  • 113
0 votes
1 answer
652 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-...
user avatar
2 votes
1 answer
483 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 ...
user avatar
  • 153
4 votes
2 answers
4k 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 ...
user avatar
  • 1,688
0 votes
1 answer
51 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 ...
user avatar
3 votes
0 answers
889 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 ...
user avatar
2 votes
0 answers
91 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 ...
user avatar