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
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 ...
Swaroop Kundeti's user avatar
7 votes
1 answer
3k 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 ...
David's user avatar
  • 71
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 ...
Opalium's user avatar
  • 63
5 votes
2 answers
5k views

MySQL : 30GB of binlogs in 6 Hours

I have a mysql master/master setup with tungsten replicator. My server is reaching out of space, occupied around 30G in 6 hours. I'm not sure how to handle this. Would be great if some one can help me ...
Swaroop Kundeti's user avatar
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 ...
TheDataGuy's user avatar
  • 1,950
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, ...
911's user avatar
  • 51
4 votes
1 answer
13k 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 ...
Som3guy's user avatar
  • 75
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 ...
tdaget's user avatar
  • 813
4 votes
1 answer
12k views

what could cause a mysql process to close (clean)

We are using mysql master-master (version 5.5.32) for an API manager called Layer7. The 2 hosts holding the instances are in the same ESX From time to time we have mysql doing a clean shutdown for ...
Philippe Courtois's user avatar
4 votes
2 answers
1k 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. ...
threewordphrase's user avatar
3 votes
1 answer
767 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 ...
P.P.'s user avatar
  • 133
3 votes
2 answers
6k views

Load Balancer for MySQL MASTER MASTER Replication

We are having typical requirement. We are having MySQL MASTER-MASTER Replication setup in place. We require to setup Load Balancer between these 2 MySQL servers. I am aware of setting up WEB based ...
Phanindra's user avatar
  • 1,007
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 ...
DFresh's user avatar
  • 51
2 votes
2 answers
714 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,...
pineconesundae's user avatar
2 votes
1 answer
1k 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 ...
Chris Telinde's user avatar
2 votes
1 answer
839 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....
M.Mass's user avatar
  • 121
2 votes
1 answer
720 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 ...
syntagma's user avatar
  • 153
2 votes
1 answer
1k 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 ...
tesla747's user avatar
  • 1,896
2 votes
1 answer
508 views

postgresql bdr 0.8.x - adding another downstream server only partially works

I have the following postgresql 9.4 bdr setup: upstream server with db called "bdrdemo" running on 10.1.1.1 downstream server(1) with db called bdrdemo running on 10.2.2.2 (replicates with 10.1.1.1) ...
Happydevdays's user avatar
2 votes
1 answer
1k views

How to keep the sync active with Bucardo

I have a master-master sync setup between 3 nodes or 3 different host machines using bucardo. All works good. However when one of the database or a host is not reachable or goes down for some reason, ...
Sijo's user avatar
  • 21
2 votes
1 answer
1k views

MySQL (or MariaDB) multi-master without MMM

I've been reading blogs on MySQL multi-master setup. The way I've used MySQL replication in the past was master-slave where if the master died (or was being taken down for maintenance) we would shut ...
afffadsf333a's user avatar
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'...
KajMagnus's user avatar
  • 1,229
2 votes
1 answer
7k views

Synchronize MySQL databases between local and hosted servers

I'm developing a software in Microsoft Blend and I need it to be synchronized with my online server MySQL database. I have local MySQL database which I use for the app. The app also have an online ...
user avatar
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
1 answer
765 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 ...
nixon1333's user avatar
  • 145
2 votes
2 answers
947 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
946 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
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 ...
Yogesh Sadula's user avatar
2 votes
1 answer
1k views

Can bdr only replicate one database per server?

I have installed the new BDR-Solution with PostgreSQL 9.4 and it works like a charm. My Problem: I want to add more databases to the replication but every time if I added the other database and ...
thisisole's user avatar
1 vote
1 answer
2k 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, ...
vsespb's user avatar
  • 13
1 vote
2 answers
2k views

I have been tasked with Mysql Master-Master replication?

I have done some study and i came to know that Mysql master-master replication violates the ACID properties and there has been problem with primary key collision.Please Let me Know,Apart from these ...
user38867's user avatar
1 vote
2 answers
297 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 ...
phil-lavin's user avatar
1 vote
1 answer
4k 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 ...
Prakash K's user avatar
  • 185
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 ...
Thomas Lobker's user avatar
1 vote
1 answer
734 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 ...
homedom's user avatar
  • 111
1 vote
1 answer
1k 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 ...
nwrobel's user avatar
  • 11
1 vote
1 answer
129 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 ...
dotcom's user avatar
  • 11
1 vote
1 answer
540 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
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 ...
Demigod's user avatar
  • 13
1 vote
1 answer
575 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 ...
Alex Protopopescu's user avatar
1 vote
1 answer
708 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 ...
vicky's user avatar
  • 15
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
1 answer
1k views

pt-table-sync for 3 master servers

We had a mysql multi master with 3 nodes and unfortunately the replication broke. We have some set of tables which has to be in sync with other database servers, so i was looking into Percona-Toolkit ...
Swaroop Kundeti's user avatar
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
1 vote
1 answer
663 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 ...
chadianscot's user avatar
0 votes
1 answer
313 views

Mysql: How does circular replication avoid infinite looping of a transaction

In case of circular replication A -> B -> C -> A. How come a transaction started on A will be ignored from being replicated from C to A at the end of one complete cycle ? I believe parent server-id ...
Uday's user avatar
  • 814