Questions tagged [master-master-replication]
The master-master-replication tag has no usage guidance, but it has a tag wiki.
39
questions
2
votes
1answer
42 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 ...
0
votes
0answers
6 views
How to handle mysql slave being down for several days
I have a couple of mysql instances that are set up as master-master replication across two data centers.
I'm facing a situation where one of the data-centers is going to be out of action for ...
0
votes
2answers
187 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 ...
0
votes
0answers
9 views
Is it possible to replicate a cluster (not just a node)?
Making a master-master cluster is easy, as is replicating one of the master nodes to a read only slave. As is replicating that RO slave to other slaves.
But, of course if the master node which ...
1
vote
1answer
121 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
0answers
26 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
0answers
389 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
0answers
34 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
0answers
20 views
Master- Master breaks after server Reboot
I have a Master-Master Replication with the following Configuration. Due to some patches, we have to Reboot the both the masters. But when i check the replication i s broken.
MASTER 1:
[mysqld]
...
0
votes
0answers
21 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 ...
1
vote
1answer
99 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
126 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
131 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
106 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.
...
-1
votes
1answer
114 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
93 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
199 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
598 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
214 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
149 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
498 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 ...
1
vote
1answer
181 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
121 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
514 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
424 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
176 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
302 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
3k 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
418 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
1k 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
396 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-...
2
votes
1answer
295 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
2answers
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 ...
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
526 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
64 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
219 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 ...
-1
votes
1answer
295 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
10k 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 ...
