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,521
questions
0
votes
0
answers
16
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
26
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
37
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
41
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
30
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
37
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
44
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
53
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
126
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
16
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
29
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
30
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
35
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
40
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
20
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
36
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
115
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
138
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
33
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
29
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
217
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
43
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
24
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
74
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 ...
1
vote
1
answer
57
views
Aurora Postgres - Database per Tenant architecture issues
We have a multi-tenant SaaS app. We had been using a shared DB for all our tenants with TenantId as foreign key in all the tables. Everything had been working fine, till our business required DB (or ...
0
votes
1
answer
68
views
AWS Postgres replication: adding indexes to a replica?
Apologies for the beginner question.
I have a couple of AWS Postgres databases that will be receiving a few thousand writes a second on the day of an event.
I also need to make read queries against ...
0
votes
2
answers
34
views
How to rename hostname in a Mongodb replica set
I need to know how I can rename my hosts belonging to my replica environment in mongodb, I currently have the following configuration:
rs.conf()
{
"_id" : "myreplicaset01",
...
0
votes
0
answers
40
views
How to execute the [sp_removedbreplication] using linked server
I tried this way
EXEC [linkedServer].[MASTER].[sys].[sp_removedbreplication] 'databasename'
However I received this message
Msg 18482, Level 14, State 1, Line 76
Could not connect to server '...