Skip to main content

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

Filter by
Sorted by
Tagged with
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, ...
Ben Adams's user avatar
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 ...
Baptiste Mille-Mathias's user avatar
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 ...
Baby's user avatar
  • 1
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 ...
Santiago Aguirregaray Pintos's user avatar
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 ...
Siddharth Prakash Singh's user avatar
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 ...
Dev Dev's user avatar
  • 101
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 ...
tomputer's user avatar
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 ...
user25935915's user avatar
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 ...
user avatar
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 ...
mj_'s user avatar
  • 307
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. ...
Ross Bush's user avatar
  • 567
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 ...
Dmitriy Ryabin's user avatar
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 ...
F S's user avatar
  • 11
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,...
Danish Ahamed's user avatar
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 ...
Ganesh's user avatar
  • 121
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 ...
user10's user avatar
  • 111
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 ...
Dave.Gugg's user avatar
  • 331
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 ...
user avatar
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/...
schmidax's user avatar
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, ...
campos's user avatar
  • 111
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 ...
Ark's user avatar
  • 1
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 ...
user3006778's user avatar
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 ...
Nikolay D's user avatar
  • 101
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 ...
Roman Milman's user avatar
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....
V N's user avatar
  • 11
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 ...
nickchomey's user avatar
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 ...
goodfella's user avatar
  • 341
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 ...
Raymond's user avatar
  • 101
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.
Meera K's user avatar
  • 51
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 ...
Chad M's user avatar
  • 143
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 ...
fumblinggravy's user avatar
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 ...
user avatar
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. ...
Christos Arapidis's user avatar
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 ...
Marcus's user avatar
  • 101
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 ...
Nguyen Nguyen's user avatar
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 ...
Rob Howe's user avatar
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&...
Babylon Big Data's user avatar
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 ...
PDIS's user avatar
  • 1
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 ...
Jarrett Prosser's user avatar
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 ...
Sotiris Liras's user avatar
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 ...
Anthony Schwab's user avatar
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"
WP JLK's user avatar
  • 1
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 ...
user avatar
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 ...
folow's user avatar
  • 357
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.
marcosh's user avatar
  • 245
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 ...
Preety's user avatar
  • 37
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 ...
nover XIE's user avatar
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 ...
Just a learner's user avatar
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 ...
Applez00800's user avatar
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 ...
Applez00800's user avatar

1
2 3 4 5
71