Questions tagged [multi-master-replication]

102 questions
2
votes
0 answers

Intermitted MySQL Group Replication Error: Plugin instructed the server to rollback the current transaction

I am running two MySQL databases -- one is on an Amazon AWS cloud server, and another is running on a server in my network. These two databases are replicating normally in a multi-master arrangement seemingly without issue, but then every once in a…
ninapavlich
  • 739
  • 2
  • 10
  • 30
2
votes
1 answer

Is there multi master database with customizable replication level?

I need a multi master database to let users talk from different continents. Each user will write his data to his local master database and it will replicate data to other master databases in other counties/continents. The problem is that I can't…
2
votes
1 answer

Solution for a small DB with high availability, no single point of failure

I need to choose a solution for a small, i.e., 2 tables/entities, in total max 100,000 rows (~ 20 MB of data) with HA having data distributed among multiple nodes. HA with no single point of failure is a must. I am considering Cassandra for the…
2
votes
1 answer

Using backticks (``) in MySQL when replication is enabled

The story I've recently setup replication on my MySQL server. I went down the route of Master - Master replication (2 servers, each is Master and Slave to the other, as described here -…
2
votes
0 answers

Key-Value store with master-master replication support

I'm looking for file-based embedded store for Node.js with following features: Support for master-master replication that replicates real time changes so you can easily have a cluster of node.js processes (on several servers) where you can read or…
2
votes
1 answer

SymmetricDS - conflict resolution

I am trying to implement multi-master bidirectional synchronization for one central node and many clients using SymmetricDS. Clients are communicating only with central node (star topology). I have problem with dealing with conflicts in primary…
2
votes
1 answer

China to AWS Multi-Master Replication

I am currently supporting a system that sits inside a data center in China, but has terrible performance outside of China due to the firewall. We are in the process of setting up a data center in AWS, and need to replicate the data. Our…
2
votes
1 answer

How to configure a Multi-Master Replication for MariaDB Galera Cluster in CentOS 6

I've been searching for documentations on how to configure a Multi-Master Replication in MariaDB but I can't find any. I use to try some configurations for MySQL but they didn't work. Wsrep were both ON in my two nodes but when I connect the second…
2
votes
1 answer

Multi-master Cassandra between directly unroutable data centers

We have three facilities, call them Main, Remote1 and Remote2, all of which have local users of an application. Users currently hit a SQL db in Main and we're looking to move to Cassandra. We want writes in all data centers to hit the local…
Blair Zajac
  • 4,555
  • 3
  • 25
  • 36
1
vote
2 answers

Connect to a MySQL master-master setup from code

For a new website we must connect to a MySQL master-master setup. This is a .NET website using NHibernate, but the same would also apply to Java or any other language. We chose this setup because we want the site to continue working if a database…
Razzie
  • 30,834
  • 11
  • 63
  • 78
1
vote
2 answers

Postgres 15 Multi-Master Replication

For the last few days I've been trying to implement a working multi-master replication using postgresql however, unsuccessfull. I came across multiple tools, none of which as worked. I think I'm getting close to a solution but I'm hitting a…
1
vote
0 answers

Node3 is not getting involved in mutli-master-replication of 3nodes using symmetric-ds 3.10.0

I am trying to create multi-master replication for 3 nodes (servers) using symmetric ds 3.10.0. After configuring all the 3 nodes, the bi-directional replication is working perfectly between 1st and 2nd nodes. But the bi-directional replication is…
svkvvenky
  • 1,122
  • 1
  • 15
  • 21
1
vote
0 answers

Debezium for large multi master replication?

I have two apps, one is "main" app which runs on one specific server and another type which runs on some tens/hundreds of other servers and usually communicates with the main app (two way). There is a lot of shared data between the main app the…
1
vote
1 answer

AWS RDS multi master writes in multiple regions

Is it possible to have something similar to DynamoDB global tables in AWS RDS? I know that with Aurora we can have multiple read-replicas in different regions and two active masters in the same region but does AWS offer the possibility for a…
1
vote
1 answer

Multi-master replication - how to fix incorrect credentials problem during connection (ldap_sasl_bind_s failed (49))

I'm trying to start multi-master replication on two LDAP ubuntu 16.4 servers (ldap2 and ldap3). After whole parametrization is done I'm not able to establish the connection between servers: slap_client_connect: URI=ldap://ldap3.rs.local…
c0rtex
  • 21
  • 4