Questions tagged [master-master-replication]
The master-master-replication tag has no usage guidance, but it has a tag wiki.
57
questions
0
votes
1
answer
19
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
0
answers
114
views
Multi-Master Replication for PostgreSQL in two geographically distant locations
I have an Odoo 13 instance running with a PostgreSQL 12 database on the same instance in one location. I want to create another instance in another location with the same codebase and database. I want ...
- 1
0
votes
1
answer
207
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
795
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 ...
- 11
2
votes
0
answers
33
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 ...
- 167
0
votes
1
answer
422
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
3k
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
1k
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
109
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
345
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
75
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
378
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
722
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
364
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
74
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
298
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
45
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 ...
- 135
1
vote
2
answers
536
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
892
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
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 ...
- 63
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
95
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
101
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
142
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
482
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
491
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
566
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
256
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
261
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
544
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
508
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
333
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....
- 555
0
votes
1
answer
594
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
306
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
304
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
752
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
747
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
222
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
646
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
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.
...
- 51
0
votes
1
answer
604
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
0
votes
1
answer
772
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-...
- 343
2
votes
1
answer
674
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 ...
- 153