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
-1 votes
0 answers
17 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 ...
Obada Bakfalonui's user avatar
0 votes
0 answers
20 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
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. ...
Christos Arapidis's user avatar
0 votes
1 answer
22 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
0 votes
0 answers
15 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
1 answer
38 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
25 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
29 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
17 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
27 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
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 ...
Anthony Schwab's user avatar
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"
WP JLK's user avatar
  • 1
0 votes
0 answers
23 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
29 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
20 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
191 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
  • 27
0 votes
0 answers
29 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
19 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
13 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
25 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 vote
1 answer
50 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 ...
adnan kamili's user avatar
0 votes
1 answer
30 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 ...
Richard's user avatar
  • 257
0 votes
1 answer
18 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", ...
miguel ramires's user avatar
0 votes
0 answers
33 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 '...
lego con tsijiari's user avatar
0 votes
1 answer
39 views

Records in the dev environment were deleted due to filter in SQL Server replication

I want to create replication in SQL Server and move the records that have changed in the last year to the test environment. Since I added a filter for last 1 year, when replication runs, only records ...
Merve's user avatar
  • 57
0 votes
0 answers
47 views

MySQL Exec_Master_Log_Pos is slow to update in replica compared to actual data

I'm trying to use Exec_Master_Log_Pos from SHOW REPLICA STATUS to check whether the replica is caught up to the master. However, Exec_Master_Log_Pos appears to take a while to update. When I add a row ...
Victor L's user avatar
  • 101
0 votes
1 answer
28 views

SQL Server Replication - only ran once. How to configure scheduler from beginning

I have configured a transactional replication from server A to Server B some 2 month ago. The source database is a new production server, and the data is being updated there constantly. I have some ...
Dmitriy Ryabin's user avatar
0 votes
2 answers
70 views

How can I monitor query performance on my Azure read-replica database?

I'm looking at Query Performance Insight for my read-replica database. But the information it shows are the performance stats from the primary database. How can I get the performance stats for the ...
Yossi Geretz's user avatar
0 votes
0 answers
25 views

Replication Error (SQL Server Management Studio 2019)

I am getting the following error in the Replication Monitor: "The replication agent had encountered an exception. Source: Replication Exception Type: Microsoft.SqlServer.Replication....
TenSecondTom's user avatar
0 votes
0 answers
34 views

Use bitwise operator to confirm intA "includes" intB? (e.g. @schema_option in sp_addarticle) [duplicate]

I've generated scripts for our replication publications/subscriptions, and I'd like to confirm whether the sp_addarticle @schema_option param of 0x000000000803509F "contains/includes" the ...
Bobogator's user avatar
0 votes
1 answer
20 views

Do the vCores in my Read-Replica process the synchronization activity?

My initial understanding of my read-replica is that it would be less busy than the primary. After all, the primary is processing all the reads, inserts, updates and deletes which are supporting my ...
Yossi Geretz's user avatar
1 vote
1 answer
38 views

Why can't I create more than 1 geo replica for my primary database?

I have a primary database in the Premium service level. I am trying to create a second geo replica to a different region. The primary is in the East Coast, The first replica is in South Central, and ...
Yossi Geretz's user avatar
0 votes
1 answer
19 views

Can I create a Geo Replica of a Named Replica?

For clarity, we have two databases on a server in a given region. One database is the primary for the read/write workload, and one is a replica for the read-only workload. I'm trying to set up a ...
Yossi Geretz's user avatar
0 votes
1 answer
55 views

Postgres Replication Stuck/Reversing?

I'm looking at our replication in Postgres. We have both logical and binary going on. I do a select * from pg_stat_replication order by state; and look at the sent/write/flush/replay lsn values. They ...
mj_'s user avatar
  • 307
1 vote
1 answer
52 views

Scripting Replication

I'd like to know how to automate the creation of transactional replication. in a test environment, I often need to restore Prod data. The test data is replicated to another server for reporting (and ...
Trubs's user avatar
  • 754
0 votes
1 answer
78 views

Postgres logical replication and table rename

We have a table in main DB that is getting logically replicated to another DB called SOR. We need to rename this table, and add a bunch of tables to the publication on the main DB. I tried this ...
hxcb's user avatar
  • 3
0 votes
0 answers
12 views

Is it possible to add a node which does not have private network connectivity with other nodes?

I have a 3 node replicaset setup Both have private connectivity with each other and resides on same DC (DataCenter1) 10.1.0.1 - Primary 10.1.0.2 - Secondary We are planning to have another ...
JRA's user avatar
  • 149
0 votes
1 answer
85 views

key violation errors in logical replication subscriber

Initial phase of the situation, I have following architecture PG 16.x Master --> streaming replication --> PG 16.x Replica --> streaming replication --> PG 16.x second replica and then I ...
Murat Suluhan's user avatar
0 votes
1 answer
41 views

More replication slots created/requested than max_sync_workers_per_subscription

We are setting up logical replication between a Postgres 14 instance to a Postgres 15 instance. When we upgraded from 12 to 14, we never had this issue of over provisioning replication slots. We have ...
Neil Seward's user avatar
0 votes
1 answer
18 views

Why is my 4-node replicaset setup is not working?

I have a 4 Node setup which is being hosted On-Prem by 2 Host Servers (DC1, DC2) 192.168.0.1 - Primary (Located in DC1) 192.168.0.2 - Secondary (Located in DC2) 192.168.0.3 - Arbiter (Located in DC2) ...
JRA's user avatar
  • 149
1 vote
1 answer
24 views

Will a replicated event cause issues?

I've got the replication configuration shown in the image. Everything replicates to everywhere. One of the tables maintains session data which has rows that must be deleted due to expiration. I ...
user22044385's user avatar
0 votes
0 answers
41 views

MSSQL logs are not being rotated in AG setup

I have an MSSQL setup primary-secondary configured through availability group. I see the logs do not get rotated even after the full backup is executed daily and logs backup is taken after each hour ...
Makhshif Tanvir's user avatar
0 votes
2 answers
40 views

replicating one master to multiple slaves and from multiple slaves to one master

"I have successfully set up regular master-slave replication, but now I need to configure a more complex setup. Currently, I have one master database and 15 slave databases. My goal is to ...
Sameerul Anwar's user avatar
0 votes
2 answers
93 views

How does this user log in to the database server, when its login is deactivated on the database server?

I've specifically disabled a login on the database server. This is an Azure hosted SQL-as-a-Service database. alter login [********@hotmail.com] disable Here's what the login looks like on the server....
Yossi Geretz's user avatar
1 vote
1 answer
21 views

I'm having trouble copying database users from one Azure SQL Server to another. The EXECUTE permission was denied

I'm trying to use the instructions here - https://learn.microsoft.com/en-US/troubleshoot/sql/database-engine/security/transfer-logins-passwords-between-instances to copy logins between the server ...
Yossi Geretz's user avatar
0 votes
1 answer
47 views

snapshot to apply just the schema changes - not the data

I am restoring databases to each side of my transactional and merge replications. Basically the publication and the subscriber are the same database initially. I still need to run the snapshot agent ...
Marcello Miorelli's user avatar
1 vote
1 answer
50 views

Can I create a read replica of my primary Azure SQL Server database on a different server with a different name?

I have a database named myAppDB on an Azure hosted SQL Server in the Eastern US Datacenter. I created a new SQL Server in the South Central US datacenter. I then Created a Geo Replica of myAppDB on ...
Yossi Geretz's user avatar
0 votes
1 answer
22 views

Pseudo-replication from read-only cloud SQL database to local SQL copy

A vendor has provided us with read-only access to a cloud SQL (2014) database for reporting purposes. We originally built some local reports off this database directly, but that proved too slow and ...
BradC's user avatar
  • 10k
0 votes
1 answer
23 views

Postgres server migration and version upgrade

We are migrating a 2TB server with a very large amount of BLOBs from an on-premises server to a cloud server. During the migration, we'd also like to update the Postgres version from 14 to 16. Now due ...
Frange0's user avatar
0 votes
0 answers
33 views

How do I convert master-slave to multimaster database replication in MySQL?

Currently, I have one master and two slaves in my setup. How can I convert it so that I have three masters instead? I need all three nodes to be writable and to update each other accordingly. Most of ...
flyerz's user avatar
  • 1

1
2 3 4 5
71