The Stack Overflow podcast is back! Listen to an interview with our new CEO.

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
0
votes
2answers
23 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
45 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
1answer
68 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
0answers
19 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
1answer
86 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
1answer
91 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
28 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
1answer
127 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
1answer
185 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
164 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
0answers
139 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
1answer
216 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
294 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/...
1
vote
1answer
176 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
478 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
437 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
46 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
445 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 ...
5
votes
1answer
583 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
109 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'...
2
votes
1answer
270 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
318 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
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
2answers
446 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 ...
-1
votes
1answer
308 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
555 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
32 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
941 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
50 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 ...
2
votes
2answers
377 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
470 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 ...
3
votes
1answer
762 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
435 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
581 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/...
1
vote
2answers
167 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
532 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
1k 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
7k 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
68 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
419 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
512 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
420 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
1k 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
825 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
884 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
64 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
467 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 ...
2
votes
1answer
940 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
3k 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 ...