Questions tagged [replication]
Replication is the process of sharing any level of information so as to ensure consistency between redundant hardware/software resources to improve reliability, fault-tolerance, and accessibility
3,504
questions
0
votes
1
answer
24
views
Is it possible to make a No-DELETE replica/follower database?
I would like to allow an application's database to execute DELETE statements. However, for analytics purposes, I would like to keep all data, even deleted data.
I'm trying to figure out if there is a ...
0
votes
0
answers
30
views
Transactional replication is trying to update a row that does not exist yet. Why?
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 ...
-1
votes
0
answers
48
views
Best Practices for Migrating 2TB MSSQL Databases with High Availability to PostgreSQL
I'm planning to migrate a large-scale MSSQL environment to PostgreSQL and would appreciate some advice and best practices. Here are the details of our current setup:
Current Environment:
Two servers ...
0
votes
0
answers
22
views
MYSQL Replication But While the backup is being uploaded to the slave, the changes in the master are not received
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 ...
0
votes
0
answers
14
views
EDB Replication behavior
I'm using EDB Replication with 3 postgres databases in MMR Replication.
Let's call them Node1, Node2 and Node3. I have a table "todo" on each one of them and I'm getting some weird behavior.
...
0
votes
1
answer
24
views
MariaDB 10.7 to 10.5 replication issue with DROP DATABASE
Originally posted on StackOverflow
I am helping a client migrate from a MariaDB 10.7 on Windows setup to a MariaDB 10.5 cluster on Debian 11. The Windows server is called win13, the Debian machines ...
0
votes
0
answers
16
views
Steps to promote a logical replica in PostgreSQL
If I want to promote a logical replica in PostgreSQL, do I have to do any additional setup besides stopping the replication?
I think I can see is sequence values are not replicated so I have do ...
0
votes
2
answers
50
views
Yet another Replicated transactions are waiting for next Log backup or for mirroring partner to catch up
We have a partial transactional replication setup in our environment to make a data subset available to another application.
Application Server 1 -> Tables1.row1/row2/row3 -> Application Server ...
0
votes
0
answers
26
views
Postgresql Logical Replication from citus distributed table to another citus distributed table
I followed this guide (https://docs.citusdata.com/en/stable/develop/integrations.html) to implement logical replication of the "items" table between two postgres db. On DB1 the "items&...
0
votes
0
answers
30
views
Error Trying to Replicate Database
I am getting the following errors in replication monitor when trying to do a Merge Replication between SQL in two locations
The subscription could not be initialized using an initial snapshot because ...
0
votes
1
answer
20
views
PostgreSQL logical replication startup on large tables has bursts of activity and long waits
I am attempting to move a large (4TB) Postgresql database from AWS RDS to Azure Database for Postgresql Flexible Server using logical replication (publication/subscription). I am performing the ...
1
vote
1
answer
35
views
MySQL 8.4 community version and replication process setup using caching_sha2_password and secure connection
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
20
views
SQL server is already part of a cluster error; cannot re-add after removing offline SQL node
I'm new here but I've run out of options for my search on this issue my team is having. To give a relatively short backstory; I know almost nothing about SQL beside what I've learned from a short time ...
0
votes
0
answers
29
views
Error Delete Distributor on sql Server 2019
I can't delete Distributor. The system shoew message error "Could not drop the Distributor 'Dis_name'. This Distributor has associated distribution database"
0
votes
0
answers
26
views
SQL Server replication latency issue
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 ...