Questions tagged [master-master-replication]
The master-master-replication tag has no usage guidance, but it has a tag wiki.
59
questions
0
votes
0
answers
17
views
Reset replica of multi-master
We have a master-master binlog replication using MySQL 8.0 where only master1 is written to by the application and master2 is pretty much a hot standby. I had a replica of master2 where that server ...
- 101
0
votes
0
answers
49
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 ...
0
votes
1
answer
1k
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, ...
- 101
0
votes
1
answer
40
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 ...
0
votes
1
answer
282
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 ...
- 111
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 ...
- 21
2
votes
0
answers
41
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 ...
- 177
0
votes
1
answer
585
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 ...
- 3
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 ...
- 111
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 ...
- 111
2
votes
0
answers
115
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 ...
- 121
-1
votes
1
answer
441
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. ...
- 1
2
votes
1
answer
86
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 ...
- 27
0
votes
1
answer
545
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. ...
- 27
0
votes
1
answer
943
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 ...
- 27
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 ...
1
vote
1
answer
430
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 ...
- 61
0
votes
1
answer
84
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 ...
- 11
1
vote
2
answers
382
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 ...
- 121
0
votes
1
answer
69
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 ...
- 145
1
vote
2
answers
575
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 ...
- 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 ...
0
votes
0
answers
1k
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-...
- 42
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 ...
- 149
7
votes
2
answers
4k
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 ...
- 73
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 ...
- 133
0
votes
0
answers
117
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
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 ...
- 11
0
votes
0
answers
115
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 ...
- 101
0
votes
0
answers
162
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 ...
2
votes
1
answer
561
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 ...
- 146
0
votes
1
answer
606
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 ...
- 149
0
votes
1
answer
634
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
1
answer
262
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.
...
- 117
-1
votes
1
answer
280
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
0
votes
1
answer
634
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?
- 103
0
votes
1
answer
565
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 ...
- 149
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: ...
- 111
1
vote
0
answers
349
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....
- 565
0
votes
1
answer
667
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-...
- 11
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 ...
- 151
1
vote
1
answer
332
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 ...
- 11
-1
votes
1
answer
319
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 ...
- 99
2
votes
1
answer
772
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 ...
- 145
0
votes
2
answers
802
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 ...
- 101
0
votes
1
answer
235
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 ...
- 1
1
vote
1
answer
725
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:-
...
- 11
4
votes
3
answers
8k
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.
...
- 151
0
votes
1
answer
621
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
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 ...
- 113