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,520
questions
0
votes
0
answers
50
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 ...
- 97
0
votes
1
answer
44
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 ...
- 101
1
vote
2
answers
170
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 ...
- 339
0
votes
0
answers
32
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....
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 ...
- 83
0
votes
1
answer
25
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 ...
- 339
1
vote
1
answer
54
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 ...
- 339
0
votes
1
answer
25
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 ...
- 339
0
votes
1
answer
84
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 ...
- 307
1
vote
1
answer
58
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 ...
- 764
0
votes
1
answer
163
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 ...
- 3
0
votes
0
answers
13
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 ...
- 149
0
votes
1
answer
161
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 ...
0
votes
1
answer
68
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 ...
0
votes
1
answer
20
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)
...
- 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 ...
- 13
0
votes
0
answers
43
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 ...
0
votes
2
answers
55
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 ...
0
votes
2
answers
110
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....
- 339
2
votes
2
answers
401
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 ...
- 339
0
votes
1
answer
54
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 ...
- 16.4k
1
vote
1
answer
116
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 ...
- 339
0
votes
1
answer
26
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 ...
- 10k
0
votes
1
answer
41
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 ...
- 1
0
votes
0
answers
39
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 ...
- 1
0
votes
1
answer
67
views
MariaDB 10.6 Slow replication - Relay log replay possibly?
I have one master and two slaves (will become one slave when this is resolved)
The master is on a dedicated server that is very fast.
The Old slave server that is in sync is on a busy shared server
...
1
vote
1
answer
32
views
Logical replication security risk with run_as_owner = false
The docs say
If the subscription has been configured with run_as_owner = true, then no user switching will occur. Instead, all operations will be performed with the permissions of the subscription ...
- 305
1
vote
0
answers
129
views
AWS RDS MySQL "manual" read replica in "Waiting for dependent transaction to commit" state but lag is zero
I have an SOP I use to upgrade AWS RDS instances running MySQL with no downtime that I have been following since 2021. I'll outline my method below, but it involves manually hooking up a new master ...
- 111
0
votes
2
answers
54
views
MySQL replica connection not working
I tried to skip an error on the replica:
STOP SLAVE;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
START SLAVE;
but still getting the error below:
*************************** 1. row *************************...
0
votes
0
answers
27
views
Changing a server name for SQL Server replication
We have two servers set up for transactional replication and we need to migrate all of the content from one of the sides (the distributor) to another SQL Server instance.
Is there a way to change to ...
0
votes
1
answer
42
views
Sharded Cluster - Why does my data not splitted among nodes?
I created a cluster with two shards. Or so I thought. In my design, first server has mongos_router shard1 (3 nodes) and config servers. Second server only has shard 2 nodes. After I configured shards ...
0
votes
1
answer
41
views
In MySQL master-slave could it happen that the oldest log bin data gets deleted before the slave has read it?
I have a MySQL database with a large number of individual tables having the same definitions. The number of tables is about 2000-3000 and their total size is about 50 GB. Of course they have different ...
- 145
0
votes
3
answers
359
views
How to drop a table that was replicated in the past?
An database being used at my job has several tables that appear to be remnants of an previous replication setup. These tables are no longer needed not having been used for at least 10 years so I am ...
0
votes
0
answers
22
views
Subsequent WALs only work if I include a base backup
I'm trying to replicate a primary PostgreSQL database to a replica through the use of base backups and WALs. The basic idea is something like:
Day 1: base backup + WALs
Day 2: new WALs
Day 3: new WALs
...
- 123
0
votes
0
answers
9
views
How to restore a backup and incremental backup of scyllaDB
I am working on incremental backup and restore. When I am trying to restore the incremental backup, after restoration, I am getting an error on cqlsh shell.
ReadFailure: Error from server: code=1300 [...
0
votes
0
answers
40
views
SQL Server Replication - Transactional
I am trying to do SQL Server transactional replication. Created publisher, distributor & subscriber.
Publisher & distributes in SQL server A and subscriber on SQL server B.
From server A I ...
abhi
-1
votes
2
answers
53
views
RDBMS vs NoSQL decision making
I am pretty novice when it comes to data store, and want to learn few tricks.
I want to know how to decide between RDBMS and a NoSQL store.
Lets take example of a system where data size is pretty big, ...
- 123
0
votes
0
answers
23
views
Why would Postgres replication skip field data for an update?
The understanding is replication via the postgres WAL would send the:
operation-type eg' update, insert and delete
schema-name
table-name
data - all the fields of the table currently
The postgres ...
- 199
0
votes
0
answers
24
views
Master to Slave Replication pausing
I would like to get insights from everyone here in this community. After we apply indexes on our Tables on Database. If some users generate big reports. Replication suddenly stopped and what we are ...
Angelo Medalla
0
votes
1
answer
85
views
Alternative to multi-master replication between local and cloud db when writes are infrequent and only 1 db at a time
Background:
I have a closed-source app on my laptop that saves its data in a local SQLite database. I'm working on creating a mobile app for myself that would replicate the functionality of the ...
0
votes
0
answers
66
views
SQL Transactional Replication Limits
I am seeing strange behavior in a Transactional Replication configuration.
Details:
Publication Server SQL 2017 Standard
Distribution Server SQL 2017 Standard
Subscriber Server SQL 2017 Standard
55 ...
- 571
0
votes
0
answers
131
views
How to sync tables between ClickHouse replicas?
Configuration was 1 shard with 2 replicas (node01 and node02).
I have added new server into cluster configuration: node03
<clickhouse>
<remote_servers>
<supercluster>
...
- 430
0
votes
0
answers
19
views
Problem with SQL Server Merge Replication 2017
I have multiple replications: merge replications that sync the data on both Headoffice and Stores but from past two days I am getting these error messages and replication doesn't complete successfully ...
0
votes
1
answer
160
views
Synchronizing two databases on different servers
I have two databases on different servers. Each one of them contains 350+ tables and users have read and write access on both databases.
I want to synchronize them, but in special cases, like if a ...
- 101
0
votes
0
answers
145
views
SQL Server Merge Replication - No subscription is on this publication or article
I have setup a merge replication publication and added a subscriber but when I view the synchronization status I just get the error message: "No subscription is on this publication or article&...
- 1
0
votes
1
answer
74
views
Before update trigger not triggered when change comes via logical replication
I have a test scenario of two postgresql databases connected via logical replication. DB "A" is publishing inserts and updates for table "a1" and DB "B" is subscribed and ...
0
votes
0
answers
41
views
mysql replication skip some batch delete query
I set up a master slave mysql replication. I have an Event that run stored procedure and delete some rows (about 3500 rows). recently it skip some delete query in slave. for example it does not delete ...
user2525363
0
votes
1
answer
25
views
How can I minimize data loss & data transfer when I failback with the requirement that I promote the old primary back to its primary status?
The definition of failback according to IBM docs is "the process of returning production to its original location after a disaster or a scheduled maintenance period".
From my reading of ...
- 125
0
votes
0
answers
10
views
Options for automated refresh of 300GB from on-premise to cloud?
We have a requirement to move about 300GB/day of telemetry data from an on-premise collector to a Palantir Foundry Cloud system. Updates should be incremental and occur every 10 minutes. Additional ...
- 409
0
votes
0
answers
60
views
log_reuse_time_desc is ACTIVE_BACKUP_OR_RESTORE
After dropping database replication and subscriber, the database's option
log_resue_wait_desc
turned from replication to ACTIVE_BACKUP_OR_RESTORE.
I should I do to return it into NOTHING value
