Questions tagged [master-master-replication]
The master-master-replication tag has no usage guidance, but it has a tag wiki.
53
questions
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 ...
- 167
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 ...
- 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 ...
- 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 ...
- 111
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 ...
- 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. ...
- 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 ...
- 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. ...
- 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 ...
- 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 ...
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 ...
- 61
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 ...
- 11
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 ...
- 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 ...
- 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 ...
- 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
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-...
- 42
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 ...
- 149
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 ...
- 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 ...
- 133
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 ...
- 1
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 ...
- 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 ...
- 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 ...
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 ...
- 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 ...
- 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?
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.
...
- 117
-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 ...
- 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?
- 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 ...
- 139
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
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....
- 445
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-...
- 11
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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 101
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 ...
- 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:-
...
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.
...
- 51
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 ...
- 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
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-...
- 295
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 ...
- 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 ...
- 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 ...
- 101
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 ...
- 31
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 ...
- 121