Database Administrators Stack Exchange
Database Administrators Stack Exchange

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.

83 questions
7
votes
3 answers

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 configuring it in ring structure, I'm little nervous…
Swaroop Kundeti
  • 137
  • 1
  • 2
  • 6
7
votes
1 answer

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 continents, something like building a SaaS over your…
David
  • 71
  • 1
  • 2
5
votes
2 answers

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, Department_ID, Department_Name. Site_ID is unique for each…
911
  • 51
  • 5
4
votes
2 answers

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 out of this. Thanks, Swaroop.
Swaroop Kundeti
  • 137
  • 1
  • 2
  • 6
4
votes
2 answers

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 now. I have 2 servers. 1. Master1 2.…
TheDataGuy
  • 1,648
  • 4
  • 21
  • 53
4
votes
2 answers

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 starting which version ? Thanks
tdaget
  • 803
  • 1
  • 12
  • 23
4
votes
1 answer

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 status command: Slave_IO_Running:…
Som3guy
  • 75
  • 1
  • 2
  • 10
4
votes
2 answers

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. We have a remote server, and many 'onsite'…
crypticsymbols
  • 53
  • 4
4
votes
1 answer

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 now reason We check the cronjobs and they are…
Philippe Courtois
  • 91
  • 1
  • 1
  • 3
3
votes
2 answers

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 Load Balancer, but we require load balancer for…
Phanindra
  • 977
  • 5
  • 14
  • 28
3
votes
1 answer

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 directions to set it up. Since both of these nodes are…
DFresh
  • 51
  • 3
3
votes
1 answer

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 sufficient to do a SHOW MASTER STATUS on the slave…
P.P.
  • 133
  • 3
2
votes
1 answer

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) downstream server(2) with db called "newname"…
Happydevdays
  • 335
  • 1
  • 2
  • 9
2
votes
1 answer

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 restarted the servers one server is crashing.…
thisisole
  • 23
  • 4
2
votes
1 answer

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, the other 2 nodes go out of sync too. It stalls…
Sijo
  • 21
  • 1
1
2 3 4 5 6