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
278
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 ...
- 307
0
votes
2
answers
86
views
Database tenancy model
I'm redoing a legacy system, and currently, I have a database with the same structure for each client. I'm really unsure whether I should maintain it this way for the new system or if I should create ...
- 11
1
vote
1
answer
43
views
Modeling a data processing system for consigned employees
I'm currently in the process of developing a payroll system using SQL Server and PHP. However, the system involves a multitude of processing rules.
During this processing, I may receive files ranging ...
- 11
0
votes
0
answers
29
views
Best Strategy to copy database using Secondary Database (not touch primary) to dedicated database server
i have application team that have dedicated database server for datawarehouse. I want to know what is the best way to copy database from secondary.
Current Environment
Always On
1 Primary
1 Secondary ...
0
votes
0
answers
54
views
Cascading DR - Switchover issue in Oracle
I have 3 databases:A, B, C.
A is the primary database, and the log_arhive_dest_2 parameter is set accordingly:
log_arhive_dest_2=service='A' ASYNC valid_for=online_logfile,PRIMARY_ROLE
B is the ...
0
votes
0
answers
38
views
How to migrate from a MySQL master-master setup to a master-master setup with as little as possible downtime
I have to conduct a migration of a few databases from two MySQL VMs with master-master replication to another 2 VMS that would be also master-master replication. How would you do it with minimal ...
- 1
0
votes
0
answers
98
views
Rename the slave Postgresql database name
I have Master-Slave streaming replication working well with postgresql 13. I created the slave from the master successfully and data is synching nicely to the slave. Can I just change the name of the ...
- 101
0
votes
1
answer
210
views
SQL Server Replication Licensing
Production database is hosted on a SQL Server Standard instance and is replicated using merge replication with web synchronization to 10 subscriber databases hosted on 10 separate SQL Express server ...
- 13
0
votes
1
answer
64
views
Numerous "truncate table dbo.MSreplication_monitordata" commands logged by distribution database
In doing a SQL Server audit, it was discovered that after hours last week, the distribution database started logging numerous "truncate table dbo.MSreplication_monitordata" commands. I can't ...
zdawg72
1
vote
0
answers
27
views
How to securely limit columns in postgres logical replication?
The docs currently have this to say about publications with specified column lists:
The choice of columns can be based on behavioral or performance reasons. However, do not rely on this feature for ...
- 305
0
votes
1
answer
243
views
SQL Server 2019, utf-8, replication problem
I know this is late to the game, but we're just upgrading to Sql Server 2019 after years and years on 2008.
I started using the Latin1_General_100_CI_AI_SC_UTF8 collation as an experiment and at least ...
- 235
0
votes
0
answers
7
views
How to consult the number of connections from specifics clients or ips in my secondary nodes
I need to know how to consult the number of connections from specifics clients or ips in my secondary nodes, I have a replica set composed of 3 nodes (one primary node and two secondary nodes), the ...
- 149
0
votes
1
answer
159
views
pg_archivecleanup
I need to use the pg_archivecleanup command to delete log generated in a primary node from a cluster postgresql but I see that running the next line does not delete anything.
pg_archievecleanup -d /...
- 37
0
votes
0
answers
63
views
Switch slave to new master
I have one master and 2 slaves in a mysql replication mode. All slaves are synchronised to the actual master.
Because of space disk problem, I have to shutdown master_old to switch the first slave to ...
0
votes
0
answers
38
views
SQL Server subscription that can work without the publisher
My requirement is to have a SQL Server replicated on another server and even if the publisher server is shut down unexpectedly the subscriber should have all the information and can be used without ...
0
votes
0
answers
61
views
sql server transactional replication high latency
I am new to system and we have database of size around 2TB and its has been set up for replication. there are 4 subscriber to it. Tables (articles) of database has been divided into 14 publishers. ...
0
votes
0
answers
35
views
How to restore PostgreSQL WAL from one Primary database to another Primary database nodes?
Suppose I have two separate primary database PrimaryDB1 and another is PrimaryDB2. I want all the transaction of PrimaryDB1 replicate into PrimaryDB2 by WAL replay. How can I do it?
I don't want other ...
0
votes
0
answers
37
views
mysql group replication, how to relocate replication channel from one master to another
Here is the scenario:
Site A → Replication → Site B
On Site A, there is a source database running, denoted as SDB.
On Site B, there is a Group Replication cluster (GRC) consisting of three servers: M1 ...
- 1
0
votes
0
answers
63
views
SQL Server 2017 peer-to-peer Replication problem after adding new column
Originally I have a DB config p2p replication data between 2 SQL Server 2017
Sp_MSupd_XXX has a parameter
@bitmap binary(21)
System table Conflict_XXX column
__$update_bitmap varbinary(21)
...
- 1
1
vote
0
answers
131
views
Altering the column without sysadmin or db_owner roles in published tables
I am using replication between two MS SQL Servers (2017 14.0.3421.10).
Unfortunately, when replication publishing is switched on, my user for database schema changes is not able to ALTER any columns. (...
- 111
2
votes
1
answer
37
views
Is it possible that binlog thread fails?
I was reading about how to create a primary-replica system and I want to do it in production.
But based on this link, I realized that binlog thread could fail and data would be lost.
I didn't find ...
- 23
1
vote
1
answer
79
views
MySQL to MariaDB migration - user view breaks compatibility with backup-restores and replication
I am trying to migrate an Ubuntu 18.04-Server with Oracle's MySQL to a Ubuntu 22.04-Server with MariaDB 10.6.12. I've established a replication between the databases, which worked. Alone, the User ...
- 11
1
vote
1
answer
347
views
Column list used by the publication does not cover the replica identity. Cannot Update Table - Logical Replication - Postgres 15
We're doing a Postgres native logical replication between two databases.
Now, we're getting an error trying to update from the publisher one of thousand tables that we have.
When we try to update the ...
0
votes
0
answers
134
views
Mongodb setup replica set in parallel on same server
I would like to know how to proceed to deploy a mongodb replica set environment on my servers where, in turn, other mongodb instances are already running, the following happens:
I have a mongodb ...
- 149
2
votes
0
answers
271
views
Why does the same query require more "Heap Fetches" when run on my postgresql replica?
I have a Postgres 13.10 database running on AWS RDS, with a primary instance and a replica. The replication is managed by AWS - it's not logical replication I manage myself.
The replica is configured ...
- 311
1
vote
1
answer
90
views
Redirecting and converting MySQL queries to Postgres on the server side
The first thing I would like to say is that I'm not going to build a production on such an architecture. I am interested purely for the sake of experiments in home experiments and performance in the ...
- 11
0
votes
1
answer
1k
views
Configuration of max_worker_processes in PostgreSQL
We are going to run Hot-Standby Replication for our environment.
In this YouTube link at 24:54, it was mentioned that, to run READ-ONLY queries in Hot-Standby we must increase max_worker_processes ...
- 25
1
vote
1
answer
55
views
Is it possible to replicate a SQL database to a database with a different structure?
There is a mariaDB instance that is already running and has data in many tables. Let me call this old database. Say, the structure (tables and their fields) were not well thought out and hence lead to ...
- 13
1
vote
0
answers
140
views
Disabling Replication and Replicated Tables
I have transactional replication set up between Database1 and Database2 using SQL Server 2017. About 20 tables are being replicated to Database2, a few of them are pretty large. I would like to ...
- 11
0
votes
1
answer
138
views
Algorithm of MySQL Master-Slave Replication
I've configured a master-slave structure for my database by following this tutorial. It works well and all is fine. I mean, any new change that happens in the master, will be applied to the slave in a ...
- 177
0
votes
1
answer
239
views
Timeouts from logical replication with no obvious root cause
Logical replication from PG 15.3 to 15.3 has been running without problems until a few days ago.
Now the subscriber shows repeated messages like:
2023-07-29 08:25:04.523 UTC [26] LOG: checkpoint ...
- 101
0
votes
1
answer
38
views
What is the correct value (GB) to shrink a DB?
My database has an MDF file of 56 GB and an LDF file of 263 GB, recovery model is setting to Full.
So, I would like to shrink the LDF file because we are out of space. What specific size should I ...
0
votes
2
answers
145
views
SQL Server standard circular replication
As far as i know, SQL Server standard edition supports only 1 mater and other becomes its replica, like Master---> Slave mirroring or replication,
Does it also supports Circular replication? like ...
- 121
0
votes
1
answer
30
views
SQL Server database migration to Azure SQL Database
We are currently in the process of setting this up, but my boss has asked whether a restore of any of the 13 databases will affect the local publications/ Subscriptions which have been set on the ...
- 11
1
vote
0
answers
421
views
Connection timeout from host MongoDB compass to docker mongo replication
docker-compose file:
version: '3.8'
services:
mongodb-primary:
image: mongo:latest
hostname: mongodb-primary
container_name: mongodb-primary
ports:
- "27018:27017"
...
- 3,656
0
votes
0
answers
37
views
Replicate a Crunchy operator OCP cluster to VMs
I am trying to implement a scenario in which there is a PostgreSQL cluster on OCP using the Crunchy operator and for reasons it should be replicated to a VM running a full PostgreSQL installation.
I ...
- 1
0
votes
1
answer
83
views
Replication Slave to Master
I am currently trying to figure out the replication feature for Databases. I am new to this ,as until now I only used databases for simple inserts and selects for webpages.
Now I am trying to build a ...
- 1
0
votes
1
answer
468
views
Postgres hot_standby_feedback supersedes or uses vacuum_defer_cleanup_age?
According to this web article, the hot_standby_feedback parameter makes use of the vacuum_defer_cleanup_age parameter to calculate when it will send updates? According to the postgres documentation, ...
0
votes
1
answer
93
views
Maintain changes in database via generic approach triggers into history table
Our main system database has temporal tables
These have helped us hugely in working out issues
However. A drawback of this is that an issue with doing a lot of updates at once can lead to a an error ...
0
votes
0
answers
124
views
Primary mongo node still trying to reach arbiter after removing it
we faced issue regard replication of MONGO replicSet on production so I rebuild the replica set by deleting the local DB and initate it again with just primary node so production application can be up ...
0
votes
1
answer
217
views
Regarding Hot_standby_feedback parameter
I have seen in source code (https://github.com/postgres/postgres/blob/914e72e6e8d3e94346f3495dac36d46aa9912bb5/src/backend/replication/walreceiver.c#L1191) regarding XLogWalRcvSendHSFeedback function ...
- 117
0
votes
0
answers
43
views
Trigger with EXEC and Only Debug Statements After First Exception Saved [duplicate]
I apologize for the verbosity of this post.
To catch DDL changes after a snapshot or full load (using aws/dms here) has been performed, there is sourceDB.tblAWSObjects which replicates to targetDB....
- 567
0
votes
0
answers
26
views
How to create zones in mongodb
i have deployed a shard cluster with 2 shard replica sets and i want shardA replica set primary in one zone and secondaries in another zone same way shardB replica set primary in one zone and ...
- 11
1
vote
0
answers
83
views
Slave database is ok but get corrupted when promoted as master
I have had a problem with a PostgreSQL database that is replicated on several machines.
On the master server, I had requests that failed with
missing chunk number 121 for toast value 146485 in ...
- 213
1
vote
1
answer
826
views
When are wal released or removed in postgresql?
I am relatively new to postgresql administration and I still have doubts about the operation or management of the wal files, specifically how these files are released or deleted, have the conception ...
- 149
0
votes
0
answers
367
views
Is uniqueidentifier column in table in MS SQL can be used in Transactional replication?
This is a ReportServer from SRSS, it has custom default value that we can't change, and some of our teams need it to be replicated to other server.
I really curious, because I can't find this in any ...
- 101
0
votes
0
answers
184
views
Server is Distributor, but Can't set database for replication
I Have a server that is already a Distributor. This happened in the past. Nobody nowadays knows why it is configured as a distributor, there's not even the "distributor" database.
We don't ...
- 7,436
0
votes
0
answers
153
views
Stored Procedure Validated Using EXEC sp_refreshsqlmodule but Fails to Execute at Subscribers
Testing a transactional replication pub/sub with over 2.5K articles against a database that has been around for over 20 years and was recently updated to SQLSERVER 2019. There are some modules that do ...
- 567
1
vote
0
answers
181
views
MySQL -> MariaDB Replication throws Collation Error
We are moving from MySQL on AWS RDS to MariaDB on-premise. To do so without downtime, we planned to create a replication first between the MySQL master and the MariaDB slave and then promote the ...
0
votes
0
answers
439
views
Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND in Standby MySQL DB server 8.0.31 (mysql-community-server-8.0.31-1.el7.x86_64)
I am running MySQL DB server 8.0.31 (mysql-community-server-8.0.31-1.el7.x86_64) on Red Hat Enterprise Linux Server release 7.9 (Maipo) operating system and have enabled replication between Master and ...
- 1