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.

Filter by
Sorted by
Tagged with
2 votes
1 answer
944 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/...
0 votes
1 answer
496 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 ...
1 vote
1 answer
527 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 ...
0 votes
0 answers
22 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 ...
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 ...
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 ...
0 votes
1 answer
37 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 ...
2 votes
2 answers
926 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 ...
0 votes
1 answer
835 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/...
0 votes
1 answer
612 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
10 views

MySQL replication status not reporting mysqld.cnf parameters

I am running a multi master replication from 3 master servers to 1 slave. Each of the masters has 2 DBs but I am replicating just 1 of the DBs. Server version: 8.0.35-0ubuntu0.20.04.1 (Ubuntu) ...
7 votes
4 answers
18k views

Master-master Replication with 3 Nodes

I need to configure mysql master/master replication with 3 nodes. Currently I have master/slave setup and I need to move it to master/master with 3 nodes. I have gone through some posts about ...
2 votes
1 answer
825 views

galera wsrep_cluster_address value

I am trying to deploy galera multimaster replication but faced some problems, google does not solve it it seems, but I see some people had the same problems in the past. Say, I have 3 servers 192....
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 ...
0 votes
1 answer
528 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 ...
0 votes
1 answer
179 views

Geo-distributed DBaaS with MySQL compatible DB with multi-master?

There are a few NewSQL engines exist, most of them Postgres-compatible, but there are MariaDB Xpand and others, MySQL-based. Plus Galera-based clusters. My question - is there production ready DBaaS ...
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 ...
2 votes
2 answers
685 views

How do you update one side of a MySQL master-master replication setup?

I have a master-master (circular) replication configured between two MySQL servers, call them West and East. There is also a web app that interfaces with each DB, also on its own West and East server,...
0 votes
2 answers
1k views

MySQL Error 1062 after reboot node in multi master replication

I setup 2 MySQL Community Server (8.0.20) with a replication master to master. Today one of the nodes went down, and when it went up, the replication failed. I tried to just ignore a registry with SET ...
2 votes
1 answer
7k views

MySQL master master replication, safe to delete rows on both masters?

We have a MySQL (v5.1.61) cluster with two masters (and two slaves). We have a table logs with a primary key column logID. This log table grows rather huge, and we'd like to delete data from it. So I'...
0 votes
1 answer
575 views

galera cluster how to run an ALTER without using RSU/TOI

I need to run an alter statement but would like to prevent locking/stall the cluster. The Galera docs advised using: SET wsrep_OSU_method='RSU'; Then Run the ALTER statement, once finich: SET ...
0 votes
1 answer
669 views

Why does my Group Replication plugin fail in MySQL 5.7.24?

I've been using the group_replication plugin with MySQL without issues before 5.7.24. With this version, the server starts up without the plugin because of failure. I confirmed it manually (see steps ...
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 ...
0 votes
1 answer
99 views

Multi master single slave replication mysql

I have a scenario in which there are two masters master 1 and master 2 and i want to add slave to master 2 , so when i update in master 1 it will replicate for master 2 so how do i get slave of master ...
0 votes
0 answers
996 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-...
1 vote
1 answer
125 views

MySQL replication not finished on next site call

I have 3 MySQL8.0 instances. Two of them are slaves. Each site call I‘m reading the slave till the first write Request is made. Afterwards Only the Master is used during the request. Now, if I write ...
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 ...
5 votes
2 answers
2k views

Many-to-One replication / Transactional Replication

I have several PostgreSQL DBs in different geographical locations (local sites). Each local site DB have the same schema, but unique data. For example, Take a table with columns: Site_ID, ...
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 ...
-1 votes
1 answer
557 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. ...
0 votes
0 answers
583 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 ...
0 votes
2 answers
1k views

What to do in times of data inconsistency in Master-Master Replication in MySQL?

I am building an architechture consisting MySQL Master-Master replication with HAProxy in its front. For HAProxy i am using round_robin algorithm to distribute loads between two masters. My question ...
5 votes
2 answers
5k 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 vote
1 answer
572 views

Galera Arbitrator system requirements compared with the actual Galera MariaDB node requirements

Right now our setup is CloudFlare > 1x HAProxy (Dallas,TX), 3x App servers (Dallas,TX), 3x MariaDB nodes in a Galera multi-master cluster (Dallas,TX). The App servers auto-scale horizontally to handle ...
0 votes
1 answer
257 views

Is there an option to prioritize a table while replication conflict occurs?

I have a master slave configuration for my production stage environment. Sometimes I need to write to some tables of my stage server i.e slave server. In that case conflicts occurs as content from ...
1 vote
1 answer
685 views

Statement Based Replication still giving duplicate Entry Error

New to the replication. I am configuring multi-master replication. I did the following steps: made one slave. configured two masters to it. Now i am performing following scenario: disconnect both ...
0 votes
1 answer
541 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 ...
2 votes
2 answers
697 views

Single Slave with Multiple Masters. Does this pattern exist in MongoDB?

Can we have a single mongoDB remotely (online) which can act as a slave to multiple master mongoDBs (which operate offline)? For example, I have huge number of transactions which I like to perform on ...
0 votes
1 answer
1k views

1236 On Slave After Master Master Failure

I have a master (master 1) that replicates to another master (master 2), which then replicates to its slave. So master 2 had an issue with the binary logs: Relay log read failure: Could not parse ...
3 votes
1 answer
1k views

How to convert MySQL master-slave to master-master

I've searched around, but can't find the exact details to point me in the proper direction. I currently have 2 MySQL instances under 5.5.41 running as a master-slave setup. I followed these ...
1 vote
1 answer
532 views

MongoDB how to achieve asynchronous geo-replication

I have read a lot of background about MongoDB replication and sharding. None of the default solutions that I know can actually do what I'm trying to achieve. Current situation We have a time ...
2 votes
1 answer
761 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 ...
1 vote
1 answer
728 views

MariaDB Galera Multi-Master Performance

I am playing around with a MariaDB Galera Multi Master Cluster and I have some performance issues which I do not understand. I have 2 virtual test machines with Ubuntu 16.04 and MariaDB 10.1 ...
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 ...
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'...
4 votes
2 answers
2k views

Is group replication available in Mysql community?

Group replication for Mysql server seems to be a great functionnality. It is available from version 5.7.17 of MySql Enterprise and Cluster CGE edition. But is it available for Mysql community ? and ...
2 votes
1 answer
718 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 ...
0 votes
1 answer
580 views

Install galera cluster without remove existing mariadb

I have to setup Galera cluster in one of my production servers. OS: Ubuntu 14.04 Existing mysql: maridb 10.1 While installing this cluster, its asking to remove the existing mariadb-server-10.1 How ...
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 ...
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 ...