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
1 answer
52 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
17 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
46 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
22 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
40 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
  • 113
0 votes
0 answers
13 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
0 votes
1 answer
21 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
  • 113
0 votes
0 answers
15 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
20 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
64 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
  • 113
0 votes
0 answers
17 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
25 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
33 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
0 votes
0 answers
7 views

Quicker & automated way to replicate mysql from master to slave

I want to replicate around 60 databases from master to slave server. I've read this guide https://dev.mysql.com/blog-archive/get-mysql-replication-up-and-running-in-5-minutes/ and few other. It's ...
Raymond's user avatar
  • 101
1 vote
1 answer
39 views

MySQL/MariaDB/Percona replication for tables without a primary key

While creating tables without primary keys is definitely a bad practice, there are third-party applications with their own schemas, and altering third party's schema by adding a primary key might turn ...
kamazee's user avatar
  • 113
0 votes
1 answer
8 views

MySQL replication status not reporting mysqld.cnf parameters

I am running a multi master replication from 3 master servers to 1 slave. Each of the masters has 2 DBs but I am replicating just 1 of the DBs. Server version: 8.0.35-0ubuntu0.20.04.1 (Ubuntu) ...
Andrei Hristov's user avatar
0 votes
0 answers
35 views

SQL 2022 replication does not work on non-standard port

Consider the following: 3 identical Windows Server 2019 VMs running WSFC (no shared storage) 3 SQL 2022 PROD instances across those 3 VMs (using WSFC/AG for easy hostname, three instance AG) 1 SQL ...
JulioQc's user avatar
  • 133
0 votes
0 answers
24 views

A table insert fails during replication with "Incorrect datetime value" but same statement will insert fine manually

I have a two server master-master arrangement running under High Availability on RHEL7. One server is the active server and the other is passive. Only the active server is doing any writing, the ...
AlwaysInTrouble's user avatar
0 votes
1 answer
46 views

Problem in Oracle 19c Replication

Replication is working fine on the other servers, however on DB_B there's some problem; It is unable to receive archives. Can someone help me out? If I have missed any parameters, please do let me ...
datascinalyst's user avatar
2 votes
1 answer
126 views

Column used in the publication WHERE expression is not part of the replica identity

I'm trying to create a logical replication setup where I have a single large database with smaller read replicas branching of filtered on a sub id. For example, if I wanted a subset of items pushed to ...
goldfishalpha's user avatar
0 votes
0 answers
14 views

Can you run SQL distribution agent as service account and connect to distributor with windows account or does it have to be a SQL account?

Setup: 2 SQL Server 2022 instances, PubServer and SubServer. Configured PubServer as publisher, SubServer as subscriber. PubServer has transactional publication created and working. Share and file ...
user avatar
0 votes
0 answers
20 views

mysql replication on same server instances not working

I use sqlyog tool to work in MySQL. MySQL master-slave replication on same server replicates fine by using queries and restoring from the sqldump. But it doesn't replicate by using sqlyog tool. In ...
Sameerul Anwar's user avatar
0 votes
0 answers
31 views

mariaDB master/slave do not replicate

I'm having problems creating an infrastructure for mariaDB, master/slave. I followed this guide: https://hevodata.com/learn/mariadb-replication-easy-steps/ everything seems to have gone well until the ...
Pasquale Meo's user avatar
0 votes
0 answers
13 views

Getting this exception in MongoDB Failed to completely discover replica set appdbRS

There is a problem with the address: address=om-3- proud-toad.mdbtraining.net: there is no space after '3-' CAN ANYONE TELL WHERE CAN I CHANGE THE ADDRESS? 2024-01-05T13:13:58.938+0000 [DiagnosticsSvc-...
datascinalyst's user avatar
1 vote
0 answers
21 views

Primary MongoD hit 1M active sessions in cache

Overview We're running a sharded MongoDB cluster, using community edition v4.4. The primary mongod in one of the data shards ('shardX' for short) has hit active sessions in cache limit of 1M and new ...
user3752071's user avatar
0 votes
1 answer
26 views

The process could not bulk copy ... and Invalid object name errors

I have set up a transactional replication from Server A to Server B in the SQL server Database did not exists on Server B and was created as part of the setup process - created as an empty one. All ...
Dmitriy Ryabin's user avatar
0 votes
0 answers
94 views

SQL 2019: Getting a Error: 14151, Severity: 18, State: 1

I created new replication servers for a Cisco Publisher/Subscriber Attendant Console. However, the replication is not working correctly. When I look at the logs on the Publisher side, I get error ...
cowr's user avatar
  • 1
0 votes
0 answers
38 views

MongoDB huge amount of temp files

I have a MongoDB replica set. The primary one creates a huge amount of temp files with the name extsort-sort-executor in every seconds, which generates more than 80Gb of temp files under 10 minutes... ...
SnackK0515's user avatar
0 votes
1 answer
71 views

postgresql replication failed with "No such file or directory" for wal file

I'm studying postgresql recently. Now I'm learning how to configure PG replication with slot. -- So I'm following this sample -- https://girders.org/postgresql/2021/11/05/setup-postgresql14-...
EisenWang's user avatar
  • 103
1 vote
0 answers
57 views

"MSSQL\repldata\unc" Is it safe to manually delete old files that belonged to old SQL Replication?

I am trying to see if it is safe to manually delete old files located under "C\Program Files\Microsoft SQL Server\MSSQL13.XXX\MSSQL\repldata\unc". I realized that data in this folder is ...
Java's user avatar
  • 223
1 vote
1 answer
32 views

Understand AWS RDS Multi-AZ Sync Replication

Multi-AZ AWS RDS docs state: What is “synchronous block level replication?” Given that this replication is at the disk level, not DB proper, is this form as reliable as DB replication?
Kevin Meredith's user avatar
1 vote
0 answers
28 views

Unable to Generate Create or Enable Script

MS SQL Server 2019 I am running into an issue trying to generate create or enable scripts for two of our replication publications. There is a 3rd publication on this server that the script generation ...
Justin Haines's user avatar
0 votes
0 answers
27 views

Can somebody help me set up simple DB replication in MariaDB?

I need DB replication between one master and one slave, but I've stumbled into problems literally every step of the way. ChatGPT has been a big help, but now I'm stumped and cannot get out of this one ...
13fcali's user avatar
0 votes
0 answers
30 views

How to find the records that are waiting to be replicated?

I had a look using the replication monitor and it is showing me commands that are awaiting to be replicated: My question is - how do I find out what these commands are? I Have tried this query by Ben ...
Marcello Miorelli's user avatar
0 votes
0 answers
14 views

Understanding the snapshot_jobid in syspublications and its job association

I have successfully set up a SQL Server transactional replication topology and it's functioning as intended. While exploring the publication properties, I noticed the snapshot_jobid column in the ...
Fajela Tajkiya's user avatar
0 votes
0 answers
9 views

Incremental CDC from Postgresql for select rows

I have a postgresql DB which has tables containing multi-tenant data. Example: Table Customer CustId Cust Name First CustA Second CustB Table CustomerShoppingDet Item Name CustId. Buying Date ...
deGee's user avatar
  • 111
-1 votes
2 answers
33 views

Mysql adding slave to a master->master

I have an existing MySQL database as master1 <-> master2 -> slave and I want to add another slave off master2. If I issue the FLUSH TABLES WITH READ LOCK; on master2 necessary to dump the db, ...
rwfitzy's user avatar
  • 99
-1 votes
1 answer
52 views

Which PostgreSQL replication solution(s) would work for me?

I have a python/django website with a PostgreSQL database. I need to set up replication so that: standby server will be on a different Linux box if the main server fails, the standby server can take ...
Granny Aching's user avatar
0 votes
1 answer
52 views

High Availability postgres db cluster with Patroni and Etcd

I am building a HA Postgres db cluster with one master and multiple slaves. Please look at the below points and correct me if I am wrong: For each slave node, I need to use pg_basebackup to sync and ...
Abizer Susnerwala's user avatar
0 votes
0 answers
43 views

LSRestore job is taking more than 1 hr to complete. Threshold time is 45min

LSCopy and LSRestore job has been scheduled for every 10 mins. I got a trn file on my secondary server after every 6 min from Primary server. LSCopy is synced with LSBackup. The problem is that ...
Ajit23jss9's user avatar
0 votes
1 answer
62 views

Myloader error during Restorin MariadDB Slave: Duplicate entry 'ТОБАР' for key 'UX_B_SEARCH_STEM'

I have lost my slave. To restore it I have locked tables on the master host and then have created a dump using mydumper tool. After that I have tried to restore my slave using myloader tool but during ...
user avatar
0 votes
2 answers
56 views

MySql binlog file getting truncated/shrinked during replication

There is a master-slave setup of a mysql db. The replication was going on fine until pos y when an error was thrown Client requested master to start replication from position > file size. I tried ...
toros's user avatar
  • 23
0 votes
0 answers
37 views

MySQL time field type conversion issue with AWS DMS

I have a DB MySQL v5.6 community edition as a source DB and AWS RDS MySQL v5.7 as target in AWS DMS and have an issue with time field type. DMS task is full load and replication. During full load all ...
blagi's user avatar
  • 1
0 votes
0 answers
31 views

When is INDEX included in Row-Based Binary Log using "full-image"

MariaDB Config version: > mysql -V mysql Ver 15.1 Distrib 10.4.27-MariaDB, for Win64 (AMD64), source revision 0946c99e7d6f7ac9dfcf3e60dae6ae85161d5ef2 my.ini: [mysqld] log-bin=bin.log log-bin-index=...
Jiří Žák's user avatar
0 votes
0 answers
4 views

how to solve problem of that IO thread in slave cannot read the correct position in master in mariadb 10.3 ? I tried to use GTID_based replication

I have a problem when using new style GTID_based replication on mariadb 10.3 in case of multi master and slaves replication ..I cannot use auto positioning in case of the IO thread in slave cannot ...
user avatar
0 votes
1 answer
52 views

Looking for best option(s) to have near real-time data synced from SQL Managed Instance to another SQL Managed Instance

I have two SQL Managed Instances 1 - Primary Production 2 - Reporting / Analytic workloads Besides traditional SQL replication (transactional) what is the best way to get data in near real-time from ...
Cody's user avatar
  • 11
0 votes
1 answer
76 views

How to make sure that all required wal files are availables before starting a standby server?

Im writing a script to restore a postgres standby server that was out of sync with the master node for a while. I would like the following behavior Check if i can go with pg_rewind If pg_rewind fails,...
meilleureVie's user avatar
0 votes
0 answers
78 views

Master-Slave replication in mysql error connecting to master 'replicator@xxx:3306' Can't connect to server on 'xxx' (111 "Connection refused")

Hi i am trying to make a connection between my Primary Server and backup server to have Master-slave mysql connection this is my Primary server ip = xxx and this is my Backup server ip = yyy both of ...
Matthew's user avatar
0 votes
1 answer
97 views

Postgresql 12 logical replication catchup state (terminating walsender process due to replication timeout)

I have an issue with our logical replication which is still on catchup state. It would read several lsn then got stuck on a particular lsn (EA/738D4DA8 both on sent_lsn and write_lsn) then reset again....
starting dba jr's user avatar
0 votes
0 answers
100 views

Postgres slow replication debug strategy

I'm using logical replication to move data from server X to Y. We had a hiccup on server X that caused the replication to fall severely behind. We don't know what it was, and right now I'm trying to ...
mj_'s user avatar
  • 307

1
2 3 4 5
69