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
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
0
votes
1
answer
84
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 ...
- 21
0
votes
0
answers
43
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 ...
0
votes
1
answer
137
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 ...
- 53
0
votes
1
answer
66
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) ...
- 11
0
votes
2
answers
187
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 ...
- 123
0
votes
0
answers
192
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 ...
1
vote
1
answer
162
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 ...
- 123
0
votes
0
answers
31
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 ...
0
votes
1
answer
98
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 ...
- 101
1
vote
1
answer
281
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 ...
- 123
0
votes
0
answers
47
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 ...
- 33
0
votes
0
answers
152
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> ...
1
vote
1
answer
203
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, ...
- 21
0
votes
0
answers
14
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 ...
- 101
1
vote
1
answer
58
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 ...
- 113
0
votes
1
answer
15
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)
...
0
votes
0
answers
160
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 ...
- 143
0
votes
0
answers
38
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 ...
0
votes
1
answer
87
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 ...
2
votes
1
answer
392
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 ...
- 123
0
votes
0
answers
50
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 ...
Moleius
0
votes
0
answers
23
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 ...
0
votes
0
answers
56
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 ...
0
votes
0
answers
14
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-...
1
vote
0
answers
53
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 ...
- 11
0
votes
1
answer
58
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 ...
- 101
0
votes
0
answers
480
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 ...
- 1
0
votes
0
answers
46
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...
...
0
votes
1
answer
417
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-...
- 103
1
vote
0
answers
128
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 ...
- 251
1
vote
1
answer
61
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?
- 539
1
vote
0
answers
62
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 ...
0
votes
0
answers
29
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 ...
- 1
0
votes
1
answer
70
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 ...
- 16.4k
0
votes
0
answers
15
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 ...
- 1,199
0
votes
0
answers
15
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
...
- 111
-1
votes
2
answers
39
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, ...
- 101
-1
votes
1
answer
156
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 ...
- 383
0
votes
1
answer
132
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 ...
0
votes
0
answers
47
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 ...
0
votes
1
answer
256
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 ...
Skuld
0
votes
2
answers
159
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 ...
- 23
0
votes
0
answers
55
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 ...
- 1
0
votes
0
answers
33
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=...
- 1
0
votes
0
answers
12
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 ...
esraa salah
0
votes
1
answer
92
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 ...
- 11
0
votes
1
answer
176
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,...
0
votes
0
answers
132
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 ...
- 1
0
votes
1
answer
345
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....
