Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
1answer
28 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
1answer
31 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 ...
0
votes
0answers
21 views

HA for Multi-Server Administration MSX - MSX to TSX

We have multiserver administration with a master server (MSX) to multiple targets. The MSX server databases are included in the Availability Group. We have a requirement to keep the MSX master as HA ...
1
vote
0answers
47 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
0answers
21 views

Does MySQL 5.7 support multi-source replication with GTID enabled?

The plan was to retrieve data to one MySQL db and keep replicating from different sources. The problem is all the upstream DBs are base on GTID, since GTID is globally identical, is this even possible ...
0
votes
1answer
80 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 ...
1
vote
1answer
81 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
0answers
24 views

How adaptable are docker containers for database?

All, We have started adopting docker containers in our organisation. As far as I understand correctly it is great for running applications with high availability and scalability but somehow I feel it ...
1
vote
1answer
60 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 ...
1
vote
1answer
279 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
1answer
207 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
1answer
34 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 ...
0
votes
1answer
246 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 ...
4
votes
1answer
375 views

How to Achieve Concurrent Write Transactions to MySQL Group Replication in Multi-Primary Mode

I've set up a MySQL "cluster" (four CentOS 7 servers running MySQL 5.7.19) using Group Replication in multi-primary mode, but I can't get it to accept writes from more than one thread at a time. This ...
1
vote
0answers
62 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'...
3
votes
1answer
173 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
1answer
197 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 ...
3
votes
1answer
1k 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
2answers
290 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 ...
0
votes
1answer
217 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. ...
1
vote
1answer
396 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 ...
1
vote
1answer
27 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 ...
2
votes
2answers
597 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 ...
0
votes
1answer
47 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 ...
0
votes
0answers
20 views

In a multi-master database, what is the name of a pattern where a single logical entity is represented as multiple database records (1 per master)?

I am trying to design a database (and an associated application) that would work well in a multi-master regime. While investigating such a design, it has become clear that modifying the same database ...
1
vote
2answers
234 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
1answer
347 views

How could duplicate entry on unique key happen if only one master is active?

Say, I we have master-master replication with only one master active at a time. We have users table: create table users ( id int auto_increment, email varchar(255), primary key id(id), unique ...
1
vote
0answers
349 views

Master-master replication, is it viable? [closed]

I'm trying to think of an architecture for my game server. Here is how it would work for two regions: A server instance runs on one machine For each machine there is a slave database to speed up SQL ...
3
votes
1answer
569 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
1answer
331 views

Setting up Master-Master Replication in MySQL on a live system

I've just recently taken on the task of looking after our mySQL databases, and have been given the task of setting master-master replication. We have a live server which has a mySQL database which is ...
1
vote
1answer
470 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
2answers
121 views

Chained MySQL replication from Master->Master replicated pair

This is a pictorial view of what I have: Master 1<----->Master 2 | | | | V V Slave 1 Slave 2 The masters are never written ...
3
votes
1answer
391 views

How to migrate from a MySQL master-slave setup to a master-master setup without downtime

We have an existing master-slave MySQL replication setup where we would like to promote the second slave to a master in order to achieve a master-master setup with no or only minimal downtime. Is it ...
1
vote
1answer
749 views

Will auto_increment always grow in master-master setup?

Let's suppose I have mysql master-master replication setup with only one server active at a time (i.e. all writes going to one server), and I have ability to manually switch to another master. Next, ...
2
votes
1answer
5k views

How to verify galera is synced

I have been using mysql master:master replication and was always able to check the status of replication using this command: mysql > show slave status\G I was able to see this in the show slave ...
0
votes
1answer
54 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 ...
6
votes
1answer
2k views

Multi-Datacenter design for SQL Server

I'm not a DBA and perhaps I can't explain myself properly. I'm looking for some fresh ideas about how, and what I need to deploy, to get a full SQL Server database available across different ...
2
votes
2answers
339 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
1answer
448 views

Mysql multi-master active-active replication : replication doesn't happen for all slaves

so i created a multi-master replication with bellow servers two for master and two for slave. hostname : master-1 ip : 192.168.120.107 hostname : master-2 ip : 192.168.120.111 hostname : slave-1 ip ...
0
votes
1answer
334 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 ...
5
votes
2answers
798 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, ...
1
vote
1answer
592 views

Multi master replication with MySQL and Django

I am working on scaling out a webapp and providing some database redundancy for protection against failures and to keep the servers up when updates are needed. The app is still in development, so I ...
2
votes
1answer
655 views

Master-Master Replication with MySQL Cluster - Duplicate Writes in Both Directions

I have created 2 MySQL Clusters; each cluster is located in a separate geographic location. I have set these clusters up in a Master-Master, Geographic Replication fashion, so that data can be written ...
1
vote
1answer
63 views

How to setup multi master replication in mysql

After hours of searching I find lots of tutorials that do only 2 server Master Master. Now I wonder how to setup multi master setup because this is more suitable in my business. Because when the WAN ...
1
vote
0answers
394 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 ...
13
votes
0answers
522 views

Low performance, high availability, replicated key/value store with audit trail [closed]

I'm looking for a database system with fairly specific specs. I've looked most of the major relational databases and NoSQL products out there and did not find one that even remotely satisfied my ...
2
votes
1answer
788 views

How to:: Master-Master replication

I have setup Master-Master replication on two servers. Now, my question is that if I need to have the second master as only read-only, what should I do? I tried doing mysql> flush tables with ...
1
vote
1answer
2k views

Remove particular table from being replicated in a Multi-Master replication

I have followed all the steps in this link to set-up MySQL Master-Master replication for two database servers. The master-master replication works fine. Here is my my.cnf file, which contains some ...
4
votes
2answers
824 views

MySQL Multi-Master Replication Topology

Disclaimer: I've never worked with replication before, but I'm doing all my research. Not really having a bunch of in-depth knowledge about MySQL makes a lot of the documentation hard to understand. ...
1
vote
0answers
529 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 ...