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 vote
1 answer
16 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
27 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
-1 votes
0 answers
16 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
75 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
15 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
28 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
16 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
17 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
  • 9,964
0 votes
1 answer
14 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
16 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
0 votes
1 answer
14 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 ...
Kevin Penn's user avatar
1 vote
1 answer
16 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 ...
Felipe's user avatar
  • 305
1 vote
0 answers
36 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 ...
Amer's user avatar
  • 111
0 votes
2 answers
49 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 *************************...
V S devops's user avatar
0 votes
0 answers
21 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 ...
Richard B. Sorensen's user avatar
0 votes
0 answers
24 views

Data Loss and data redeundancy when forced failed over to secondary replica on DR Data Center in SQL Server 2016

We are using SQL Server 2016 Enterprise edition and planning to have 2 datacenters primary and the remote Disaster recovery(DR). We have 2 replicas (primary replica and secondary replica) in the ...
Manoj Jeganathan's user avatar
0 votes
1 answer
29 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 ...
Furkan YIlmaZ's user avatar
0 votes
1 answer
20 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 ...
0xC0DEGURU's user avatar
0 votes
3 answers
50 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 ...
user1644544's user avatar
0 votes
0 answers
15 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 ...
dokgu's user avatar
  • 123
0 votes
0 answers
7 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 [...
MANJESH H S's user avatar
0 votes
0 answers
18 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 ...
user avatar
0 votes
0 answers
17 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, ...
Mandroid's user avatar
  • 123
0 votes
0 answers
21 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 ...
tread's user avatar
  • 199
0 votes
0 answers
20 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 ...
user avatar
0 votes
1 answer
26 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 ...
mikemykhaylov's user avatar
0 votes
0 answers
33 views

SQL Server Replication Snapshot Error - Exception Message: An invalid option was specified for the statement "CREATE/ALTER FUNCTION" [closed]

The replication process was working fine. But when I added Views, UDF and Stored Procedures to replication process it throws this error. The replication agent had encountered an exception. Source: ...
whereisike's user avatar
0 votes
0 answers
36 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 ...
Garry Bargsley's user avatar
0 votes
0 answers
24 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> ...
Mikhail Aksenov's user avatar
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 ...
Haider Mumtaz Khan's user avatar
0 votes
1 answer
60 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 ...
hanie's user avatar
  • 101
0 votes
0 answers
28 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&...
josh's user avatar
  • 1
0 votes
1 answer
28 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 ...
Roberto Iglesias's user avatar
0 votes
0 answers
21 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 ...
user avatar
0 votes
1 answer
17 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 ...
Anthony O's user avatar
  • 113
0 votes
0 answers
8 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 ...
Dr.YSG's user avatar
  • 399
0 votes
0 answers
32 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
Abdelrahman Mamdouh 's user avatar
0 votes
1 answer
75 views

SQL Server - moving databases to an earlier version - options

I have inherited a vendor product. It’s currently very old, having been installed in 2013 and never updated in the 11 years since. The database server it’s using for its 3 database is SQL Server 2008 ...
fiveeuros's user avatar
0 votes
0 answers
23 views

sql_skip_slave not working in mysql 8.0.30

The Error: Worker 1 failed executing transaction '3c852db0-0a3e-11eb-9a41-005056b2f2da:589631974' at master log log_bin_BD6_LDPY.014848, end_log_pos 130823035; Could not execute Delete_rows event on ...
Ruan Oliveira's user avatar
0 votes
1 answer
58 views

How to Identify the Most Up-to-Date Secondary Replica in a SQL Server Always On Availability Group when the primary replica is unavailable?

In a SQL Server Always On Availability Groups setup, I'm seeking guidance on determining the most up-to-date secondary replica when the primary is unavailable, to perform a failover to minimize data ...
Neaj Morshad's user avatar
0 votes
1 answer
41 views

MariaDB to MySQL migration using AWS DMS

I have a master-slave mariadb 10.3.29 running on AWS EC2 and needs to be migrated to AWS Aurora MySQL using DMS. In order to do that i need to change the binlog_format to ROW(both master and slave) ...
JollyRoger's user avatar
0 votes
2 answers
59 views

Unable to restore from WAL files

I copied both the base backup and the WAL files from my primary Postgres database to a standby database and tried to restore from them but I'm getting this error: PostgreSQL Database directory appears ...
dokgu's user avatar
  • 123
0 votes
0 answers
45 views

Querying V$ARCHIVE_DEST_STATUS

-- Oracle 19c when querying v$ARCHIVE_DEST_STATUS, I get the following output: SELECT DESTINATION, STATUS, ARCHIVED_THREAD#, ARCHIVED_SEQ#,APPLIED_SEQ#,APPLIED_THREAD# FROM V$ARCHIVE_DEST_STATUS ...
datascinalyst's user avatar
1 vote
1 answer
42 views

How to create a pg_basebackup for without streaming?

I have a primary and a replica Postgres database that are never connected to each other. We have another layer of technology to store a base backup and the WAL files to and those will get synced to ...
dokgu's user avatar
  • 123
0 votes
0 answers
22 views

in logical replication from standby host, create subscription command hangs

In following setup, create subscription command hangs and there is no error in logs HOST1 --> HOST2 --> HOST3 Master --> phsyical replication --> logical ...
Murat Suluhan's user avatar
0 votes
1 answer
37 views

SQL Server replication: Need to remove articles from the publication

I am replicating the data from the Database1 on Server1 to respectively, Database2 on Server2. Now, the requirement is to remove certain tables form being replicated - so I will remove them from the ...
Dmitriy Ryabin's user avatar
1 vote
1 answer
96 views

How to lock an entire Postgres database

I have a process (for backup and replication using binary logs) that works in MySQL that I want to replicate for Postgres databases (using WAL): Lock database (FLUSH TABLES WITH READ LOCK;) Disable ...
dokgu's user avatar
  • 123
0 votes
0 answers
23 views

How to migrate a web app from a monolithic to a backend-frontend architecture while keeping both running side-by-side? (PHP, MySQL)

I have been maintaining for quite some time a monolithic web app written in vanilla PHP, SQL, CSS, and JS (no frameworks used; no external APIs used; in simple terms, it's just PHP code querying a ...
kataba's user avatar
  • 33
0 votes
0 answers
44 views

postgresql logical replication replica identity on whole user tables

Customer has about 4960 tables in different schemas and will apply a logical replication whole database. Is there any easy way to set 4960 tables' replica identity full. (alter <schema.table> ...
Murat Suluhan's user avatar
0 votes
1 answer
65 views

Live database migration MariaDB 10.5 to MySQL 8.0

I need to move a busy OLTP database from self hosted MariaDB 10.5 to Google Cloud SQL for MySQL 8.0 with minimal downtime. The source is a self managed VM instance in Googles Cloud with replicas, ...
Claus Koch's user avatar

1
2 3 4 5
70