Stack Overflow
Stack Overflow

Questions tagged [multi-master-replication]

102 questions
1
vote
1 answer

(Postgresql) make table trigger function insert ID value of changed row into log table, for custom replication

For Postgresql---and eventually Sybase ADS---I have tables that will replicate using homemade triggers. The triggers have a function which should record info for INSERT UPDATE DELETE changes which include the I/U/D operation and the ID of the row…
user2620054
  • 43
  • 1
  • 6
1
vote
2 answers

Google Cloud MySQL and Master-master replication

I have two servers in different regions (eu, us) connected to the same mysql database, I've started with google cloud sql second generation but it's only available on us region. The idea is to add a second sql nodes in the new region eu but I can't…
O.Hammami
  • 176
  • 1
  • 7
1
vote
0 answers

Multi Master Slave Replication

| Slave | --------- /\ | | | | ---------- --------- |Master A| <------------| User A | ---------- --------- /\ | | | | \/ ------------ ---------- | Mastrer B| <----------| User B | ------------ ---------- When User B Insert…
Manisa
  • 11
  • 2
1
vote
1 answer

Database with Multi Master replication

What are good options for a multi master replication enabled, scalable database. We are talking about 15-16 TB of data. We are thinking DynamoDB. Are there any more databases which we should look up. Any advice on DynamoDB usage as well as new ideas…
Pravs_thedataguy
  • 215
  • 2
  • 10
1
vote
1 answer

OpenLDAP multi master replication

I am currently testing OpenLDAP multimaster replication on four nodes and I have few problems. I follow this tutorial: setup-openldap-multi-master-replication-centos-7 and I succeeded with configuration for four node multimaster replication. If I…
rtmktl
  • 9
  • 3
1
vote
1 answer

Connet two apps to MariaDB Multi Master database

Suppose that we have two application servers(app1 and app2) and also we setup multi master MariaDB clustering with two nodes(node1 and node2) without any HAProxy.Can we connect app1 to node1 and app2 to node2 and also both of app1 and app2 write to…
Khosro
  • 707
  • 1
  • 7
  • 16
1
vote
2 answers

OpenDJ Multi-master replication fails(Hangs at Initializing registration information step):: javax.naming.AuthenticationException

I am using OpenDJ-2.4.6 along with Oracle JDK 7.80 and I want to run Multi-master replication on 2 of my servers, the OS for these servers is Amazon Linux. The OpenDJ setup runs perfectly fine; I can start the server too without any errors. It is…
apapap
  • 91
  • 1
  • 8
1
vote
1 answer

MarkLogic multi-master replication

We are working with a Global Editorial Team Geographically distributed and MarkLogic has been chosen as underlying data store. To support 0 down time and quick response time, we want to setup distributed data store with multi-master replication. We…
Manish Mandal
  • 11
  • 1
1
vote
1 answer

Master Master Replication with keepalived for failover & consistency

I am wanting to setup master-master replication using MySQL for Failover purposes. However, I don't want data being accessed from both masters so I can mitigate the risks of master-master replication. I have a keepalived setup for web server load…
rand0mb1ts
  • 230
  • 3
  • 18
1
vote
1 answer

What is a good solution for cross datacenter master-master replication?

Lets say we have a distributed system where data is sharded by user ids. In most cases each shard is changed by user who owns this shard. There are more then one datacenter and users are balanced between these datacenters using DNS, cookies or…
Aleksander Alekseev
  • 1,854
  • 4
  • 25
  • 57
1
vote
1 answer

Using Redis Replication on different machines (multi master)

I want to use Redis as distributed cache in my application. One of the demands is to have Active Active availability meaning that I have one data center in one place and another one somewhere else. If one data center fails I want my user to feel…
Dennis Nerush
  • 5,473
  • 5
  • 25
  • 33
1
vote
1 answer

pt-table-sync unable to modify binlog_format

I have a production percona master-master cluster. The secondary master has a replication error and using pt-table-sync, I am trying to sync the masters. Looks like binlog_format="STATEMENT" is necessary for any sync operation. Below is the…
Sanky
  • 11
  • 4
1
vote
0 answers

Configuring bucardo for 3-master replication across high latency links?

I am new to bucardo and need to install it for database replication. The idea is to replicate 3 databases with the same content. I have a database which I will call it "db1" installed on a local machine. I have a second database and I will call it…
pmatos
  • 276
  • 4
  • 18
1
vote
1 answer

MariaDB 10 Galera Cluster or Downgrade?

i have some questions about MariaDB. Maybe anyone can help me. I have two servers and want to loadbalance via DNS (Round Robin). Round Robin is configured. Now i want to setup a multi master replication with MariaDB. The Problem that i have is i…
user3237304
  • 21
  • 2
1
vote
1 answer

How does CAP theorem relate to multi-master replication?

How do these two things relate and what kind of properties does an asynchronous multi-master database system have in the context of the CAP theorem?
Muton
  • 761
  • 2
  • 7
  • 16
1 2
3
4 5 6 7