Skip to main content

Questions tagged [multi-master]

Multi-master refers to a configuration in which more than one node in a cluster is a full read/write member. It takes many forms - synchronous MM network clustering, async MM replication, shared-storage MM clustering, and more.

26 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2 votes
0 answers
1k views

MySQL multi-master group replication on kubernetes

We are trying to setup MySQL multi-master group replication (GR) on kubernetes Group replication configuring instances. GR is starting on one pod after all the configurations. However the second node ...
Raghavendra V's user avatar
2 votes
2 answers
950 views

MySql Multi Master Active Active Mutli Write

I am establishing Multi Master Replication [All mater can write to their database], Initially I started with two server. After establishing connection and sync data on both servers. There are some ...
Arjun Kaushal's user avatar
2 votes
1 answer
947 views

MySQL Semi-synchronous replication with Multi-Master

Is it possible to use semi-synchronous replication with a Multi-Master setup? I've tried to follow this guide to setup a semi-synchronous replication for a master-slave setup: https://avdeo.com/2015/...
TheOddGuy's user avatar
  • 183
1 vote
1 answer
543 views

Proxysql setup for Percona PXC Multimaster cluster

I have a clean Ubuntu lab setup for PXC Cluster and Proxysql (each a separate VM)and i'm seeing this issue (error below). Is there a specific installation that needs to be followed for PXC cluster? I ...
Storm's user avatar
  • 11
1 vote
0 answers
132 views

Replicate Specific Tables with fully qualified statements removed

Currently we have a replication system that is a master to slave, which that slave is also a master. We are replicating our web server to our stats server so we can report on users traffic as well. We'...
chris85's user avatar
  • 105
1 vote
1 answer
86 views

runtime replication

We have a master-master replication setup with 3 databases being replicated between both masters; 'database a', 'database b', 'database c'. Replication is row-based. 'database c' had an issue and we ...
joebegborg07's user avatar
1 vote
0 answers
512 views

Restoring MySQL Master-Master Replication

I am trying to restore Master-Master MySQL 5.6 servers. The replication failed between DB1=>DB2 and so DB2 went out of sync. GTIDs are enabled. I have done an export and import from DB1 to DB2 and ...
Sam's user avatar
  • 111
1 vote
0 answers
761 views

Master/Slave and Master/Master replication - MySQL

What is the difference between having a master-slave replication and having a master-master( where in the second master acting as hot-standby - active-passive) replication? Also, what are the issues ...
tesla747's user avatar
  • 1,896
1 vote
0 answers
190 views

MySQL Cluster Master Master Replication - broken Leg

I have two MySQL Clusters which normally operate with Master - Master Replication between two of their nodes. Site 1 gets the majority of the write traffic, with Site 2 writing small amounts of ...
Josh's user avatar
  • 11
1 vote
0 answers
52 views

How to update all primary keys in the existing database

I'm moving mysql multi-master replication to production using tungsten. I had setup the auto increment and offset values in my.cnf file. To achieve this i'll have to update my all primary keys of all ...
Swaroop Kundeti's user avatar
0 votes
0 answers
34 views

How do I convert master-slave to multimaster database replication in MySQL?

Currently, I have one master and two slaves in my setup. How can I convert it so that I have three masters instead? I need all three nodes to be writable and to update each other accordingly. Most of ...
flyerz's user avatar
  • 1
0 votes
1 answer
60 views

Alternative to multi-master replication between local and cloud db when writes are infrequent and only 1 db at a time

Background: I have a closed-source app on my laptop that saves its data in a local SQLite database. I'm working on creating a mobile app for myself that would replicate the functionality of the ...
mikemykhaylov's user avatar
0 votes
1 answer
40 views

DR For MySQL multi master nodes

I’ve planned to build MySQL master-master replication and need DR for this setup. I was thinking for replication from any of the node as a slave. Please help, which option is best and how to switch ...
Fasil CV's user avatar
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-...
devilboy477's user avatar
0 votes
1 answer
170 views

How to use a MySQL database both remotely and locally

I cannot find the best solution for my problem. I made a C++ application which runs on a Kiosk under Ubuntu that needs to store and retrieve data from a MySQL database and these same data need to be ...
Marcus Barnet's user avatar
0 votes
0 answers
595 views

mariabackup slave info and multi-master replication

I have several master databases using mariadb 10.3 and replicate then all to one replica using multi-master replication. All is working fine. I want to backup that replica server, so i can restore it ...
higuita's user avatar
  • 51
0 votes
1 answer
620 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?
Andy natty's user avatar
0 votes
1 answer
850 views

Mariadb Galera cluster empty set

I am playing around with a MariaDB Galera Master Master Cluster and I have some issues which I do not understand. [mysqld] bind-address=0.0.0.0 [galera] wsrep_on=ON wsrep_provider=/usr/lib64/galera/...
mohan reddy's user avatar
0 votes
1 answer
6k views

Internal MariaDB error code: 1927 ('Connection was killed')

Edit: filed a bug report at https://jira.mariadb.org/browse/MDEV-14493 Mariadb nodes freeze occasionally with the following error in the logs, any clues? (drupal app, db freezes on clearing ...
a_at_cyber_dot_training's user avatar
0 votes
1 answer
67 views

Mysql replication, allow inserts while database is disconnected

I've tried getting information on this elsewhere but can't really find what I'm looking for. I'm making a system to handle sales, etc for a company that has different branches. They want to have the ...
patrickdamery's user avatar
0 votes
1 answer
1k views

Galera Cluster Setup - Primary and Secondary Site Scenario

I'm very new to Galera Cluster and is exploring a potential setup with reasonable resiliency to node failure and network failure. Looking at the very bottom part of this documentation, the Weighted ...
CLDev's user avatar
  • 141
0 votes
1 answer
59 views

Multi Master Replication With One Slave

I'm in the middle of my little project here and i had some problem here, this is the detail of it. I have 4 server, 3 server using for getting data from my sensor module and 1 is using for storing ...
irvan sandoval's user avatar
0 votes
1 answer
498 views

Restoring a MySQL database to a failed master

I have a master-master configuration in MySQL with two servers. One server should stay live on the network to serve requests (call it server A) and the other should be taken offline to push new code ...
nwrobel's user avatar
  • 11
0 votes
1 answer
136 views

is Master-Master replication ok for me?

I have two separated locations connected by a not too reliable VPN. I have a common system that depends on MYSQL that read/write tables. Will master-master replication keep both locations in sync? I ...
Otrovagomas's user avatar
0 votes
1 answer
53 views

Table Not Created On All MySQL Masters

Here is the multi master setup. Table is not created on middle master. log-slave-updates is not enabled in my.cnf file. Master 1 mysql> create database replication; mysql> use replication; ...
Julio Fong's user avatar
-1 votes
1 answer
563 views

How to get user Insert statistics in MySQL

I'm trying to get statistics on the write load on my MySQL servers. Something like what show global status like "Com_%"; gives me. but, here comes the catch - we're using Master-Master replication. ...
cohenjo's user avatar
  • 1,198