All Questions
Tagged with database-replication multi-master-replication
32 questions
3
votes
1
answer
1k
views
MySQL slave replication not writing binlog file
I have installed 3 MySQL Server (8.0.29-0ubuntu0.22.04.2) to create a master-slave replication like
Master -> Slave -> Secondary Slave
My issue is when i change database in master it is ...
- 107
1
vote
1
answer
356
views
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)
...
- 11
0
votes
1
answer
439
views
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 = /...
- 1
0
votes
1
answer
1k
views
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 ...
- 31
1
vote
1
answer
1k
views
PostgreSQL database replication failure because of duplicate key violation
I've configured two RHEL machines with redundancy configuration (master- master setup) with below software versions.
Database: PostgreSQL 9.5
Bucardo: Bucardo 5.4
Database replication goes smoothly ...
- 41
2
votes
0
answers
3k
views
Postgresql 10.x how to configure Master - Master replication
I need to configure Master - Master Postgresql replication servers. I guess psql 10 or 11 will be used for this.
But I can`t find any information about master-master configuration, only master-slave.
...
- 1,525
3
votes
2
answers
4k
views
PostgreSQL 10 logical replication trigger function not executed
I've implemented the Logical replication in PostgreSQL 10 within 2 db in 2 different server and I'm aware that the sequences are not sync so I created a trigger function like this in both database:
...
- 697
1
vote
1
answer
3k
views
(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 ...
- 43
0
votes
1
answer
45
views
how to set up mongodb replication where you have 3 web servers being used to load balance?
We have plans to set up a web solution in 3 locations... fronted by a load balancer that will distribute based on the location of the client.
So if the request for the web app is coming in from north ...
- 15.7k
0
votes
0
answers
88
views
does galera setup cause db down and slower db read?
recently I realized after I setup master to master replication using galera, my db seems to be loading slower than usual.
Also, sometimes it cannot be connected.
I am currently using django and I ...
- 7,010
0
votes
0
answers
120
views
Questions About Load Balancing ProstgreSQL 9.6
I have a question regarding streaming replication in Postgres.
I have this one DB server that runs Postgres and it's heavy on both reads and writes(runs bulk inserts, large selects, minute to minute ...
user8256294
0
votes
1
answer
2k
views
Stop BDR from replicating DROP TABLE or CREATE TABLE
I have two databases with tables that I want to sync. I don't want to sync any other table. I'm using Postgres-BDR to do that.
Those tables are part of replication set common. There are some ...
- 913
3
votes
1
answer
903
views
Deadlock on MTS replication
Situation:
we have a master-master-replication using GTIDs on Percona MySQL 5.6.32-78.1. On server, there are about 10 databases and we've set slave_parallel_workers=5. One server is used for ...
- 7,742
0
votes
1
answer
818
views
set up multi-source replication with mysql
I'm trying to setup the multi-source replication and I'm reading that tutorial : multi-source replication
I think I've found exactly what we are looking for! But I have a few questions, since this is ...
- 137
0
votes
1
answer
44
views
How can I get the updates and Changes in all masters in a Multi-Master Replication?
I have configured Mysql Ring replication say as Servers A,B,C. I can get the changes and updates in B when I commit the updates in A. I get it in C when I make changes in B. I get updates in A when I ...
- 11