Questions tagged [database-replication]
Database replication is used to ensure consistency between redundant databases and to improve reliability and increase fault-tolerance. The replication process commonly involves continuously duplicating a "master" database to one or more additional "slave" databases.
database-replication
1,868
questions
0
votes
0
answers
21
views
Transactional replication is trying to update a row that does not exist yet. Why? [migrated]
I've been tinkering with SQL Server 2019 and transactional replication for a little while now and I've hit a wall. Looking at the replication monitor I'm seeing the error "The row was not found ...
-2
votes
0
answers
16
views
FUNCTION reserved words conflict with mysql8.4 replica frm mysql5.7? [closed]
when mysql 8.4 replica db(zabbix) from mysql 5.7, conflict occur
CHANNEL_NAME:
WORKER_ID: 1
...
-1
votes
0
answers
14
views
Fixing the server restart problem for MySQL database replication using XAMPP
So, I have successfully created a Master-Slave replication between 2 machines using XAMPP. There are a few problems I am facing:
1- Each time I try to see the logs in the Master, the position changes, ...
0
votes
0
answers
17
views
MYSQL Replication But While the backup is being uploaded to the slave, the changes in the master are not received [migrated]
I am trying to do mysql replication. But I want to while the backup is being uploaded to the slave server, the changes in the master are not received.
For example:
I have a user table on my X db. And ...
-1
votes
0
answers
11
views
MySQL 8.4 community version and replication process setup using caching_sha2_password and secure connection [migrated]
Trying to setup a replication process between two MySQL Server 8.4.1 servers using a replication user with 'caching_sha2_password' I received the following error using the command "start replica ...
0
votes
0
answers
24
views
Merkle Tree vs Replication Log / Event Log
I understand that Merkle Trees can be used to replicate data and guarantee
integrity of the data in byzantine environment (where you don't trust all the parties) and that systems like cansandra use it ...
- 41
0
votes
0
answers
16
views
Is Amazon Aurora RDS replication synchronous or asynchronous
We are using Amazon Aurora RDS with Postgres. We have Multi AZ deployment, with two instances, 1 writer and 1 reader replica. Now the question is, if the synchronization is synchronous or asynchronous ...
- 14.1k
-1
votes
0
answers
12
views
SQL Server replication latency issue [migrated]
SQL Server 2019 patched a couple months ago. As of this morning my transactional replication is very far behind in latency. The distributor is on the replication box.
What I've ruled out:
resource ...
0
votes
0
answers
24
views
DMS Source Data and Latency spike nightly
I'm using a SQL Server on-prem source for a DMS to replicate to a SQL Server RDS. Every night, at about midnight, I'm seeing a spike of ~1.6M CDC incoming changes on my DMS task, but nothing is making ...
0
votes
0
answers
11
views
In Quorum-Based Consensus Protocol, how does abort quorum get the updated data?
I am trying to understand "Quorum-Based Consensus Protocol". If there are total 5 nodes and 'Commit quorum' is of 3 nodes And 'Abort quorum' is also of 3 nodes. Now coordinator asks to ...
- 613
0
votes
2
answers
45
views
How to acquire exclusive lock in replicated mysql and clustered servers?
I have this scenario:
My php web application is deployed in a clustered environment, it uses a replicated mariadb database with galera.
It has to acquire an exclusive lock on database row resource and ...
- 9,390
0
votes
0
answers
18
views
Handling Stale Reads and Lost Updates in Galera Cluster During Large Transactions
Sure, here's your question translated into English:
Hello,
I have a question about using Galera Cluster.
I understand that for large transactions (changing many rows), replication between nodes can ...
0
votes
1
answer
42
views
MySQL master-slave replication with SSL: got error certificate verfication failed
Last_IO_Error: Error connecting to source 'repl@mysql-master:3306'. This was attempt 1/86400, with a delay of 60 seconds between attempts. Message: SSL connection error: error:0A000086:SSL routines::...
- 31
0
votes
0
answers
164
views
pg_basebackup error: connection to server, no pg_hba.conf entry for replication connection
There are similar posts and answers to my issue, however they could not help me.
I am using PostgreSQL v16.3 and the latest version of Docker.
I am creating a very basic PostgreSQL cluster using a ...
- 80
0
votes
1
answer
87
views
DMS replication task fails due to a corrupt binlog event
I have a mariadb RDS database deployed as a multi-AZ in my AWS account, engine version 10.6.16. This DB serves as the main backend database serving ~100 connections per second. I also have a DMS ...
- 41