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,525
questions
0
votes
0
answers
11
views
Failover Replication Publisher to new version of SQL
We currently have a SQL 2016 availability group where the primary is built on a windows Failover Cluster instance, and want to migrate off of that FCI and onto newer SQL. To complicate things a bit, ...
0
votes
0
answers
15
views
Resync mysql replica in a GTID setup gives error HA_ERR_FOUND_DUPP_KEY with AUTOPOSITION
I use a procedure based on this page for years to sync a new replica or resync a broken replica for year without issue.
This uses xtrabackup to save and send the mysql data to the slave, apply the ...
0
votes
1
answer
18
views
Bloat on replcia (standby)
To detect bloat we run some heavy queries, but since they may affect the db server we do it before or after primetime.
Could we run these queries (basically, check bloat) on the physical replication ...
0
votes
1
answer
15
views
PostgreSQL logical replication without a static IP
I have a PostgreSQL database that is running on AWS. I also have a database running locally on a Raspberry Pi, that is supposed to replicate the changes from the AWS one. I was thinking of using ...
0
votes
0
answers
17
views
RDS Mysql replica cdc performance
I have a RDS Mysql which has high read/write volume. ~10k IOPS on an average and peaks up to 16k IOPS.
I have another RDS mysql replica of the main. We are using this replica to capture cdc logs and ...
0
votes
0
answers
29
views
MySQL 8 Replication Master-Master fatal error
I have two servers with the same MySQL 8.0.40. I set up a Master to Master replication.
When I run the command SHOW REPLICA STATUS\G; on both servers, I see an error: The replica I/O thread stops ...
0
votes
0
answers
38
views
MySQL log_bin and relay_log base_name.extension
Some of the MySQL clusters I manage have the following my.cnf settings:
log_bin = mysql-bin.log
relay_log = mysql-relay-bin.log
For the log_bin setting the .log extension is not needed because ...
1
vote
1
answer
20
views
SSMS Version of 2008R2 Publisher not compatible with 20012 Subscriber
I am setting up transactional replication on my 2008R2 server to 2012 distribution server to 2012 Subscriber server. All the three servers are on FULL recovery mode. Log backup is taken every 15 ...
0
votes
0
answers
37
views
SQL Server On Linux. Error MSSQL_REPL20024
Background:
I had a temporary SQL Server 2019 (v15) database on windows. I set up an UBUNTU 22.04 server with SQL Server 2022 (v16) and migrated the data to that new instance.
I then set up an ...
0
votes
1
answer
42
views
Postgres Logical Replication - how to see what subscriber is doing with received data?
I've got two Postgres 13 databases on AWS RDS.
One is a master, the other a slave using logical replication.
Replication has fallen behind by about 350Gb.
The slave was maxed out in terms of CPU for ...
0
votes
1
answer
31
views
Added Articles Are Being Ignored
there is a publisher --> distributor --> subscriber setup and all has been well configured in this system and a few simple tests of adding a few tables and re-snapping tables seems to work well.
...
0
votes
0
answers
38
views
Error in 'Distribution Cleanup' job
I neede some help with this problem.
Using MS SQL Server, I have a replication setup and working from Server A to server B.
There is a clean up Job that has to run on the agent -
'Distribution clean ...
1
vote
0
answers
45
views
How to troubleshoot logical replication on Postgresql, when it comes to high replication lag?
I have a use case in which we use AWS DMS to stream data to our data lakes (S3), from time to time the replication lag gets out of control, leading to over 500Gb in replication slot lag.
It was also ...
0
votes
1
answer
11
views
Can wal_level be set to logical for both pitr recovery and logical replication?
My database cluster currently uses logical replication with wal_level set to logical. How can I integrate Point-In-Time Recovery (PITR) into this setup without changing the wal_level? If it's possible,...
1
vote
2
answers
54
views
Postgres Hot standby stuck starting waiting for contrrecord despite wal file being present
We are experimenting with patroni Multi Datacenter HA with postgres16 using replication slots. At high level for building the remote cluster from scratch , we are by running base backup, while active ...
0
votes
1
answer
22
views
MongoDB Replication for Backup
Our's is a small application. Every day we do mongodump and take DB backup to Amazon Glacier. Instead of this I would like to use MongoDB replication that will copy actual database on another ...
0
votes
1
answer
35
views
Can I compress SQL Server Replication Subscriber tables before the snapshot is applied to the Subscriber?
I am setting up a Staging/PreProd environment by taking nightly backups of our Prod environment and applying them to our new PreProd environment. This part is working well.
Unfortunately, we have a ...
0
votes
0
answers
6
views
Clash of Auto increment column in MySQL during replication
I am trying to figure out a way to have 2 Aurora MySQL clusters in a Multi master setup where both clusters can serve traffic, and the data should be in sync between both clusters even if it is ...
0
votes
0
answers
132
views
MySQL slave replication fails with error code 1032
We are running a MySQL DB master server version 8.0.36-0ubuntu0.22.04.1 and MySQL DB slave server version 8.0.39-0ubuntu0.22.04.1, where replication fails after a few hours with this in /var/log/mysql/...
1
vote
1
answer
24
views
Why do I get a unique constraint violation error when updating a logical replica?
I have two docker containers with PostgreSQL. I want to replicate data from existing tables in a database called wiki. I have tried using pglogical and the native logical replication feature. However, ...
0
votes
0
answers
19
views
PostGreSQL 12 : Logical Replication - Specific Schemas
0
I've two database servers : Host 1 & Host 2
On the Host 1, I've several schemas in the database :
SchemaA
SchemaB
SchemaC
etc...
I would like set in place a logical replication from Host 1 to ...
0
votes
1
answer
17
views
PostgreSQL physical and logical replication - key values
PostgreSQL.
When using physical replication, does a given row in a table in the replica database have the same primary key value as its corresponding row in the primary database?
Same question when ...
0
votes
1
answer
30
views
Querying whole PostgreSQL table in replica on CTID
I noticed it is quite fast to query a whole PostgreSQL table in chunks on ctid as explained for example in this Airbyte blog post. I need this for a syncing task that might take from hours to a few ...
0
votes
1
answer
43
views
MongoDB ReplicaSet system configuration and modeling
I want to create a replica set model that look like this:
PC 1 : ip=1.1.1.1 - The only one that writes
PC 2 : ip=2.2.2.2 - Read only
PC 3 : ip=3.3.3.3 - Read only
Use-case: On PC 1 I have a program ...
1
vote
0
answers
42
views
Snapshot replication fails with error 4817
I have set up snapshot replications between two SQL Servers. There are multiple replication jobs, one for each database. One of subscriber jobs is failing with the error message
2024-07-29 06:05:55....
0
votes
1
answer
33
views
In what circumstances would you use a different value for gtid_domain_id and server_id in mariadb GTID replication?
I'm learning about MariaDB GTID replication and one thing I am completely stuck on is why GTIDs have both a domain ID and a server ID, which make up the (domain_id)-(server_id)-(sequence_number) in ...
0
votes
1
answer
44
views
PostgreSQL: Best practises for Deleting huge volume of Data in Replicated Environment
We have a prod database (PostgreSQL13) with a hot-standby(physical replication) as well as logical replication to a different subscriber server. Now we are in requirement of purging few year's record ...
0
votes
1
answer
38
views
Mysql replication - Access denied for user 'repl'@'hostname' (using password: YES)
I had setup mysql replication using percona Xtrabackup. Replication was from my web server to my local machine. It used to work but my ISP changed IP address and replication stopped working. I'm ...
0
votes
1
answer
41
views
xp_cmdshell and SQL Server replication process
Do enabling/disabling xp_cmdshell has effect on replication setup?
We have transactional replication setup with our SQL Sever 2014.
0
votes
1
answer
35
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
1
answer
88
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 ...
0
votes
0
answers
28
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
21
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
37
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 ...
1
vote
0
answers
28
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
120
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
30
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
33
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
63
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
147
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
26
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
41
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
34
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 ...
0
votes
1
answer
31
views
How to enable streaming replication if we clone database disks to new virtual machine?
On PostgreSQL v15 on RedHat 9 we would like to establish asynchronous read-only standby streaming replication.
Primary server has 10 TB of data and pretty much a lot of new transactions, because it is ...
0
votes
1
answer
31
views
Views in Postgresql replica
At work we're thinking about adding a Postgresql replica.
We were wondering whether it's possible to create views and materialised views directly on the replica.
2
votes
2
answers
219
views
Transactional Replication - how to set up alerts/notification to send alerts before transaction log space is full on a Publisher?
I am setting up transactional replication on my 2008R2 server to 2012 distribution server to 2012 Subscriber server. All the three servers are on FULL recovery mode. Log backup is taken every 15 ...
0
votes
0
answers
44
views
Subscriber server name for a replication of SQL Server
When I am preparing to setup a new replication in an new server as an old server. I noticed that the subscriber displayed in the subscription properties is ADPASDB6006
but what I used T-SQL find is ...
0
votes
0
answers
25
views
Understanding @Security_mode in sp_adddistributiondb
I'm currently working on setting up a distribution database using the sp_adddistributiondb stored procedure in SQL Server. I've come across the @Security_mode parameter and I'm trying to understand ...
0
votes
0
answers
17
views
How to use replicate tables with NULLable composite unique identifier fields?
I will preface with saying that I'm no SQL expert.
I have tables that exists in multiple databases in a hub and spoke style architecture where there are Machine DBs which logically publishes their ...
0
votes
0
answers
75
views
Logical replication fails with "publisher did not send replica identity column expected by the logical replication target relation <table>"
I have two postgre databases where one is set to publish a table and the other subscribes to it for logical replication. This is setup in PgAdmin.
This is a simple test case, and the table i'm ...