Stack Overflow
Stack Overflow

Questions tagged [multi-master-replication]

102 questions
1
vote
1 answer

Master-Master replication auto_increment_offset

I have set up 2 MYSQL servers: my.cnf server1: auto_increment_increment = 2 auto_increment_offset = 1 my.cnf server2: auto_increment_increment = 2 auto_increment_offset = 2 But when I insert records one by one 10 times from different…
IvanTrofimov
  • 167
  • 1
  • 7
1
vote
0 answers

replication normal mysql to cluster

Surprisingly I can't find anything on the internet which speaks to this. We currently have a master slave slave mysql set up. We are considering making a move to mysql cluster, for scalability reasons. It would be really nice if we could make the…
user1631986
  • 11
  • 1
0
votes
1 answer

cockroachdb data not replicating

I am testing multi-master region setup in cockroach db (version v22.1.0 / Ubuntu 20.04): cockroach start --insecure --store=server1 ... cockroach start --insecure --store=server2 ... cockroach init --insecure --host=server1 cockroach sql…
Falcon
  • 47
  • 6
0
votes
0 answers

MySQL replication with 3 nodes (GTID and channels)

I would like to ask a question regarding replication of 3 nodes within MySQL before I do proceed with my idea by purchasing more hardware. That being the case, currently I do have 2 nodes with master-master GTID based replication (lets name those…
xc3s50an
  • 21
  • 3
0
votes
0 answers

Serverless PostgreSQL replication

I'm trying to setup a "Serverless" PostgreSQL data replication architecture. Here's what I'm trying to do: I'm trying to install a PostgreSQL database in every machine and then have that data synchronize between all available servers. I've tried…
RedNet
  • 416
  • 5
  • 12
0
votes
1 answer

Rails' DelayedJob for a multi-master setup

I want to add one or two servers to my setup. I want it to be a multi-master setup with Postgresql-BDR to be available even if one server crashes. Now the problem: I use delayed_job pretty heavily. A job should only be run on one server to avoid…
Railsana
  • 1,813
  • 2
  • 21
  • 30
0
votes
2 answers

PostgreSQL multi-master replication between AWS RDS and GCP Cloud SQL

I found lots of articles on how to migrate data from RDS to Cloud SQL, however all of them do just master-slave replication and then the switch. However I couldn't find anything about master-master replication between two clouds. We need that to…
Sebastian Vaisov
  • 39
  • 8
0
votes
1 answer

ldap_sasl_bind_s failed (-1)

I have configured the openldap multimaster based on this guide: https://kifarunix.com/setup-openldap-master-master-replication-on-centos-8/ but the replication between two servers doesn't work. and I get this error: on server1: slap_client_connect:…
Mohammad
  • 11
  • 4
0
votes
1 answer

Can we create a SQL Server RDS in AWS Active/Active?

I have question about AWS RDS. what we have to do to create a SQL Server RDS Active/Active or Multi-Master Cluster on AWS? Is there any easy way in AWS RDS? Thanks.
Osman Saklı
  • 3
  • 1
0
votes
0 answers

Is there any trustable enterprise grade master to master (bi directional) replication option available in PostgreSQL

We have two independent databases installed in a local network, we have to synchronize these data bases when one database restart after maintenance, Is there any trustable enterprise grade master to master (bi directional) replication option…
Abhilash R
  • 1
0
votes
1 answer

Mysql ID Duplication issue in Replication

I tried implementing MySQL replication with 3 systems. In my setup I have pairs as follows (Master ,Slave ) (System_1,System_2) (System_1,System_3) (System_2,System_1) …
Sam
  • 1
0
votes
1 answer

reading from config file in a sql script

I have a sql script where I create all the sequence used in the application as below. These values will be different for different servers. Instead of giving these hard coded values, I want to specify these in some config file Is there a way that I…
user2101
  • 145
  • 1
  • 11
0
votes
1 answer

MySQL Master-Master replication error 1062

The question is about MySQL-Master-Master replication. I have read a lot on the Internet, but there is a problem. Source data: A. MySQL 5.7. Part of my. cnf about replication: server-id = 1 log_bin = /var/log/mysql/mysql-bin.log log_bin_index =…
scorch
  • 1
  • 1
0
votes
1 answer

PostgreSQL BDR issues with replication slots

If I may, I would like to write a brief summary of the issue before I add more details to make my question cleaner and clearer: I have a BDR group running in production, replication works fine in all nodes, but I'm getting errors regarding a…
jbm-ayesa
  • 31
  • 1
  • 5
0
votes
0 answers

ADD_MASTER_DATABASE procedure changes tns login username

I'm trying to configure multi master with two servers (orclsrc and orcltgt) on Oracle 11G (yes, I know it is old but is what we have here) following this guide. When I'm trying to do: EXEC DBMS_REPCAT.ADD_MASTER_DATABASE (GNAME=> 'REP2',…
downtheroad
  • 409
  • 4
  • 11
1 2 3
4
5 6 7