All Questions
4,459 questions
0
votes
0
answers
17
views
Best Practices for SQL Replication Password rotation
We use MSSQL Server replication and have a dedicated AD account to attach to everything and everywhere.
We need to rotate the password, but we have yet to do one cleanly and with no issues.
e.g., ...
- 133
1
vote
0
answers
17
views
Decoupling Production processes from Logical Replication on AWS RDS PostgreSQL: Seeking Non-Blocking Alternatives for Tables Without Primary Keys
We recently encountered an issue in our production environment involving logical replication on our AWS RDS PostgreSQL 16.3 instances.
Our current setup allows developers to add tables to replication ...
- 11
0
votes
0
answers
10
views
How to upgrade a Postgresql logical replica that's also publishing to another database without pausing writes?
I have a setup where my application connects to a PostgreSQL 16 server (server A) and there is a PostgreSQL 12 server (server B) that's a logical replica of server A and is also a source for PeerDB ...
0
votes
1
answer
35
views
Database replication - multi hop
We currently have a SQL 2016 database replicating to a SQL 2012 database and we are upgrading our SQL 2016 instance to SQL 2019. According to the compatibility documentation, replication between the ...
- 103
0
votes
0
answers
24
views
Интеграция Agregate с Cassandra и отладка соединения [closed]
I am working on a project in which it is necessary to integrate the Aggregate system to collect data and store it on two Cassandra database servers that will replicate data on each other to create ...
- 1
0
votes
0
answers
15
views
Migrating Publication database in Transaction Replication to another server
We need to migrate Publication database (SQL 2017) in Transaction Replication from old server (windows 2016) to new server with upgraded hardware (windows 2019). Please let me know if below approach ...
0
votes
1
answer
19
views
How can I replicate transactions one by one in mysql?
I have one source server and one replica server. And I set source_delay 30mins, replication is gtid based, mysql version is 8.0.24
If I accidentally drop table A, Can I apply transactions just right ...
- 1
0
votes
0
answers
49
views
MySQL Replication, Master Slave- Last_SQL_Errno: 1062, Worker 1 failed executing transaction 'ANONYMOUS' at source log mysql-bin
My mysql replication (master - slave) is failing with following error:
Last_SQL_Errno: 1062
Last_SQL_Error: Coordinator stopped because there were error(s) in the worker(s). The most recent failure ...
- 101
0
votes
2
answers
27
views
How to handle asynchronous slave synchronization with Galera?
I have a server with a service that uses mariadb database. This machine is remote and the database is far away in a Galera cluster of two servers.
Currently, this server is connected using an ssh ...
- 201
0
votes
0
answers
26
views
Switch to master auto position from master_log_file and master_log_pos MySQL 5.7.44
MySQL Server - 5.7.44
I have a master and three slaves running on MySQL 5.7.44.
The GTID is enabled and I am using gtid_enforce_consistency.
I took a backup from a slave and built a fourth slave using ...
- 226
0
votes
1
answer
32
views
Where can I find more detailed MySQL deadlock logs?
We have a MySQL database in AWS RDS that was migrated recently from 5.7 to 8. One of our microservices running in ECS executes bootstrapping code at launch to iterate through a large list of table ...
GS-Scooter
0
votes
0
answers
11
views
Can you downgrade provisioned iops on gp3 for postgresql RDS?
Doing an occasional analysis on a postgreSQL RDS instance with gp3 storage.
Running out of provisioned IOPS.
Is it possible to temporarily raise the provisioned IOPS limit? e.g. just for a day or ...
- 347
0
votes
1
answer
22
views
How to get snapshot from pg_create_logical_replication_slot?
When reading the documentation about the streaming replication protocol, I see that I can get the snapshot name. This seems to be handy to perform synchronisation before starting to stream the ...
- 155
0
votes
0
answers
26
views
mariadb-backup consistently produces corrupt backups after 11.4 upgrade
We recently upgraded mariadb 10.3 to 11.4. Upgrade went surprisingly smoothly, but now backups taken using mariabackup are consistently corrupted.
We use mariabackup to create replicas using the ...
- 1
0
votes
0
answers
15
views
Postrgresql Logical replication causing very high buildup of log files even though replication slots are active [ AWS RDS postgresql 16.1]
I have two rds instances and have set up logical replication between them [ publisher subscriber]. for the 3-4 days everything was working fine wal files were getting cleared but suddenly when the ...
- 1
0
votes
1
answer
31
views
Amazon Aurora RDS - invalid undo record
Context
Aurora RDS, MySQL 8.0.mysql_aurora.3.05.2
Problem
The writer instance is constantly cycling. In the AWS RDS console, under Logs & events for the writer, I see
Attempting to restart the ...
- 121
0
votes
1
answer
28
views
Replica Not Starting
I’m trying to setup a primary-secondary replica. This is to do a downtime-free migration from first node to second node in the next few days.
The primary node has been setup, the config was updated, I ...
- 125
0
votes
0
answers
29
views
PostgreSQL 13 logical replication keeps dying
For some time now I keep facing the same issue on PostggreSQL 13.14 cluster - there are 6 replication slots, 5 for one client server (different tables, same target db) one for other client (some ...
0
votes
1
answer
27
views
how can I list all views and functions that are replicated?
I have a script to show me the replication articles of a publication:
declare @publication_name sysname = 'my_pub'
declare @database_name sysname = 'my_db'
use [my_db]
select ServerName = @@...
- 16.6k
0
votes
1
answer
41
views
Setting Synchronous_commit to off in Postgres in AWS RDS
0
We are experiencing significant delays in our PostgreSQL database due to LWLock:WALWrite and LWLock:WALSync waits, which are causing commits to pile up.
To address this, we have undertaken several ...
- 1
1
vote
1
answer
144
views
How to optimize performance for PostgreSQL logical replication with a large number of databases?
We are using PostgreSQL 16.4 on Debian 12.2 (16vcpu/64gb). We have a multi-tenant setup where each tenant has its own database.
We are facing issues with logical replication performance when handling ...
0
votes
1
answer
26
views
sql server merge replication - how to find out where the snapshot folder is what are the permissions for that folder
I am looking for the location of the snapshot folder for my merge replication
I have tried:
select top 5 * FROM sysmergepublications pub
select * FROM dbo.sysmergeSubscriptions
but that does ...
- 16.6k
0
votes
1
answer
60
views
I'm trying to set up merge replication and I get an error 'MSmerge_ctsv_9777E7338F8248498FD', because it does not exist or you do not have permission
My error is MSmerge_ctsv_9777E7338F8248498F9237E1FF3FE39D, because it does not exist or you do not have permission.
I connected to the subscriber database and tried to execute the following query:
...
- 1
0
votes
0
answers
87
views
How to set up Postgresql pglogical replication on the same database instance
I am trying to assess pglogical replication usage instead of the built-in one (particularly due to being able to filter by operation). I am using a single Azure Postgresql flexible server database ...
- 1,171
0
votes
0
answers
31
views
Replication in postgresql-16 keeps on lagging on replica
There is one primary and two replicas in postgresql 16. one replica is completely sync however, the other one keeps on lagging and after some hours its falls way behind and breaks replication.
Primary ...
0
votes
0
answers
19
views
MariaDB Slave not updating from Master
No errors are reported but changes on the master, even after waiting over night are not showing up in the slave.
Suggestions greatly appreciated.
Master Server Version = 10.6.19-MariaDB-log
SHOW ...
0
votes
1
answer
26
views
Analyzing sql query performance issues in mysql
I am new to mysql, I have few questions in regards to query performance tuning. (Note- its version 8.0.32)
I understand we use "explain analyze" to see the execution plan and it shows the ...
- 11
0
votes
2
answers
61
views
All possible ways to Scale a Database
I recently began studying Database Scaling and have a few questions.
Please correct me if I’m mistaken on the following points:
A database (db) is a collection of tables (in relational databases) or ...
0
votes
0
answers
15
views
MariaDB Galera nodes rejoining but missing data after resync
I have 1 MariaDB Galera cluster composed of 5 nodes in 2 different datacenters: 3 in DC1, 2 in DC2, On DC1, one of the nodes has a pc.weight=2. Bootstrap was set on Node 1 from DC1.
Data between the 5 ...
- 1
0
votes
0
answers
14
views
[MSSQL][REPLICATION][AVAILABILITY GROUP] Publisher is pointing to the secondary (not readable)
I have a new client with replication that doesn't sync anything.
The log reader agent status windows shows this error :
The target database, '', is participating in an availability group and is ...
- 1
2
votes
0
answers
56
views
Error WAL segment has already been removed in PostgreSQL
I am using CentOS 7 and PostgreSQL 11. When my disk is full, I delete the archive files from PostgreSQL in the archive directory. In postgresql.conf I set archive_command like this:
archive_command = '...
rurjaf
0
votes
0
answers
22
views
Granting Permissions To as User in Mysql
I created user-a that has the following grant privileges
SHOW GRANTS FOR 'user-a'@'%';
'GRANT INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, ...
0
votes
0
answers
15
views
MySQL 8.0 connecting to AWS RDS MySQL 5.7 with SSL/TLS CA authentication fails weirdly (Error code MY-002026)
When trying to establish TLS encrypted replication between a replication source living in AWS RDS on version 5.7.44, and a replica living in a VM on-premise on version 8.0.39, I keep getting an error:
...
- 1
0
votes
1
answer
67
views
MariaDB Galera and Geo redundancy
I am trying to simulate 2 clusters in different datacenters/different locations, using VMWare VSXi and 6 VMs: 3 are located on DC1 and other 3 on DC2. All nodes are RHEL 9.
Both DCs communicate ...
- 1
0
votes
0
answers
94
views
How does RDS Postgres OldestReplicationSlotLag metric correlate to replication slot Log Sequence Number lag?
We run a Postgres 14.9 database via RDS Aurora Serverless. We have a logical replication slot consumed by a service (Fivetran) every 15 minutes.
We noticed this behavior where the reported ...
- 51
0
votes
0
answers
24
views
Difference between "REPL-Checkup" vs. "REPL-Distribution" (for the "Category" inside Job Activity Monitor)
I am working on creating Replication inside SQL 2022.
I created Replication subscription/subscriber for two different pipelines.
I noticed that, under Category inside Job Activity Monitor, for one ...
- 251
0
votes
2
answers
56
views
Autovacuum unable to vacuum which is causing DB reastart of Aurora Postgres DB
(Moved question from stackoverflow to dba.stackexchange)
I am using AWS Aurora Postgres 13.8. Now we have around 35-40 replication slots in DB and we dropped few replication slots. The reason for ...
- 101
0
votes
0
answers
33
views
PostgreSQL: Is there any way to further optimise ASYNC replication towards less data loss during failover?
We are looking to see if there any further optimisations that can be done in PostgreSQL(13) ASYNC replication to make data loss near to zero as possible when a failover is triggered during disaster. ...
- 395
0
votes
1
answer
26
views
How to reset stats in "pg_stats_subscription_stats"?
I have some errors produced while making changes to some logically replicated tables. Now I want to reset the errors logged in the pg_stat_subscription_stats table in the apply_error_count column, but ...
- 143
1
vote
1
answer
48
views
Collation difference in PostgreSQL on AWS RDS and local machine
I have an issue with collation in PostgreSQL when sorting a result set. We use AWS RDS PostgreSQL, and we want to sort query results in a specific way. Locally, everything works perfectly on my laptop ...
- 119
2
votes
1
answer
24
views
Primary Key data type suggestion for MySQL for an application that depends in a external system. unsigned bigint vs varchar data type in primary keys
I'll give you some context and then ask my question.
I'm building a database model for an ecommerce application. This application needs to communicate to another system (ERP system) to get product, ...
0
votes
0
answers
34
views
Make change in the table structure in a replicated environment for Postgresql
I have a table in production whose structure I want to modify. I can ALTER the table to add column but the column gets added at the end, may be the order may not matter. But at least visually I see it ...
- 101
0
votes
0
answers
41
views
How can I tell if SQL Server is RDS, RDS Custom, or installed manually on a VM (EC2)?
I only have direct access to the SQL Server. How can I check if it's RDS, RDS Custom (which allow to connect to the VM), or installed manually on a VM (EC2)?
- 801
0
votes
0
answers
21
views
Error 1827 on MySQL Replication slaves when MySQL Router creates a user
I'm running MySQL 8.0.37 on three different servers, configured as a master with two slaves. All of the versions are exactly the same. My applications connect to the cluster via MySQL's Community ...
JVal90
0
votes
1
answer
26
views
Filter some queries with mariadb's replication
I want to make a safe master/slave replication, without drop/truncate. Which can help if we made mistake about drop/truncate table, or in case of hack/injection.
I searched for a replication ...
- 181
0
votes
0
answers
22
views
Failover Replication Publisher to new version of SQL
We currently have a SQL 2016 availability group where the primary is built on a windows Failover Cluster instance, and want to migrate off of that FCI and onto newer SQL. To complicate things a bit, ...
0
votes
1
answer
85
views
How can high severity alerts be configured in Amazon RDS SQL Server?
Per the RDS documentation,
SQL Server Agent alerts and operators aren't supported.
But on any sensible SQL Server, you really want these for the high severity alerts.
So, I'm here to ask: How can ...
- 801
0
votes
0
answers
28
views
Resync mysql replica in a GTID setup gives error HA_ERR_FOUND_DUPP_KEY with AUTOPOSITION
I use a procedure based on this page for years to sync a new replica or resync a broken replica for year without issue.
This uses xtrabackup to save and send the mysql data to the slave, apply the ...
0
votes
1
answer
29
views
Bloat on replcia (standby)
To detect bloat we run some heavy queries, but since they may affect the db server we do it before or after primetime.
Could we run these queries (basically, check bloat) on the physical replication ...
- 1
1
vote
0
answers
45
views
How can I improve the performance of a "cold" (first) run of this seemingly simple query?
I'm working on a specific query which has been slowing down an application for some time. The table in question has about 55 million rows.
A "cold" (first) run of this query usually takes ...
- 193