Skip to main content

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
1 answer
546 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
0 answers
24 views

Can't get hostname for your address flooded in error log even if skip-name-resolve is enabled and many unauth users in processlist in percona 8.0.25

Information about the currently configured percona servers : We are using percona 8.0.25 server. Mysql service is running with skip-name-resolve enabled. host_cache_size=753 but the ...
1 vote
1 answer
319 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 vote
1 answer
713 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:- ...
0 votes
2 answers
782 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
1 answer
612 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
0 answers
415 views

MASTER-MASTER replication failed on Production: Coordinator stopped because there were error(s) in the worker(s)

This error occured after I was importing a database dump to master1. In production our MASTER-MASTER replication failed UPDATE SELECT CHANNEL_NAME, WORKER_ID, THREAD_ID, SERVICE_STATE, ...
0 votes
1 answer
30 views

Master master relationship getting "too many connections" error after extended outage

I have a master master database setup with an onprem and cloud hosted MariaDB server. I can stop one database or the other for testing purposes and start it back up and everything seems fine. The ...
1 vote
2 answers
564 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 ...
0 votes
1 answer
243 views

MySQL replication fails with permission error for unknown reason

Since 36h I'm struggling to setup a simple Master <-> Master replication with MySQL 8. None of the found solutions on the Internet works here and meanwhile I'm a bit desperate. Even the first ...
0 votes
2 answers
1k views

How do we switchover a slave to another master instead of promoting the slave to be the master?

We have a replication configuration wherein there are 2 Masters and 20 Replicas(Each master has 10 replicas). Now, we need to perform MySQL version upgrade on these instances. The approach for this ...
2 votes
0 answers
37 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 ...
0 votes
1 answer
528 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 ...
1 vote
3 answers
4k 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 ...
1 vote
3 answers
2k 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 ...
-1 votes
1 answer
414 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. ...
2 votes
0 answers
112 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 ...
1 vote
1 answer
404 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 ...
2 votes
1 answer
85 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 ...
0 votes
1 answer
490 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. ...
0 votes
1 answer
880 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 ...
1 vote
1 answer
4k 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 ...
2 votes
2 answers
1k 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 ...
0 votes
1 answer
81 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 ...
1 vote
2 answers
354 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 ...
0 votes
1 answer
59 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 ...
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 ...
0 votes
0 answers
996 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-...
-1 votes
1 answer
272 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 ...
3 votes
1 answer
1k 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 ...
6 votes
2 answers
3k 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 ...
-1 votes
1 answer
470 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 ...
0 votes
0 answers
106 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 ...
1 vote
0 answers
5k 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 ...
0 votes
0 answers
107 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 ...
0 votes
0 answers
154 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 ...
5 votes
2 answers
5k 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
1 answer
590 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 ...
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 ...
0 votes
1 answer
259 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
1 answer
603 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?
4 votes
3 answers
7k 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
1 answer
541 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
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: ...
1 vote
0 answers
339 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....
3 votes
3 answers
1k 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
1 answer
640 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-...
-1 votes
1 answer
317 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 ...
2 votes
1 answer
761 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
1 answer
225 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 ...