Questions tagged [amazon-rds]

Amazon Relational Database Service is a web service that makes it easy to set up, operate, and scale a relational database in the cloud.

Filter by
Sorted by
Tagged with
0
votes
1answer
11 views

What are some likely causes of high Client:ClientRead AAS in AWS RDS?

I have a particular query, its a simple select with an inner join. Seems to be pretty well indexed. But it's registering as a worst offender in performance insights. With a 0.13 on CPU and a 4.5 on ...
-1
votes
0answers
8 views

Can we check server specification using postgres query in aws RDS?

I deployed an app from dev to production server. The dev and prod has same RAM, but we use RDS as database server on production server. But I feel slower performance in production database. I don't ...
0
votes
0answers
17 views

Unable to replicate Postgres tables using logical replication in RDS

Tables in the destination database are empty even after subscription is successful. I am extremely new to logical replication within Postgres. I am trying to replicate three tables from the source ...
0
votes
0answers
7 views

Flushing hosts without being able to connect to the host

I'm seeing this dreaded error: Host '10.0.12.34' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' The server is an RDS instance running in AWS. There are VPC rules ...
0
votes
0answers
56 views

Weird slow queries after update RDS from 5.7.26 to 8.0.21

We have ~500dbs having ~110 tables each. DB was running on t2.medium instance for multiple years. I noticed that IO was growing gradually and reached not really nice avg values of 220-250 iops. So we ...
1
vote
1answer
17 views

MsSql express export from local pc to RDS, how to transfer NDF/LDF files?

First time mssql admin here. Never worked with mssql before I might asked question improperly. Couldn't find any posts mentioning ndf/ldf files import to AWS RDS mssql database. Is data from these ...
0
votes
0answers
10 views

AWS RDS Database not in a VPC, no SSL

If an AWS EC2 Server is connecting to an AWS RDS Database, but the database + server are not part of a VPC, and there is no SSL setup on the database... Does that mean the data is being sent over HTTP ...
0
votes
1answer
26 views

Do MySQL limitations apply to MariaDB as well on AWS RDS

I am thinking of migrating MariaDB 10.3.13 to RDS, I want to do an analysis of what limitation can be caused by migrating to RDS, I could find no documentation by AWS for MariaDB for issues and ...
0
votes
1answer
17 views

AWS Postgres RDS “storage-full” and not responding. How to bring back online?

I cannot reboot nor stop the DB in AWS console. I cannot connect it with PG Admin. My Java app also print error like this. org.postgresql.util.PSQLException: Connection to xxxx.us-east-1.rds....
0
votes
1answer
17 views

What is the name of the process for creating a new DB from an exported snapshot? [closed]

I need to set up an automated process that: creates a snapshot of an AWS RDS (MySQL) DB uses that snapshot to create a new RDS instance that will be used as an "analytics playground" I'm ...
0
votes
0answers
35 views

Ideal CDC Latency for SQL Server Replication

I am seeking to understand what the ideal latency for an implementation of CDC in SQL Server Standard (2017) is. The latency I am referring to can be found from the sys.dm_cdc_log_scan_sessions DMV ...
1
vote
1answer
31 views

Same postgres query in two different instances with the same data but with different times

I have the same postgres query running in two different instances restored with the same dump file: one instance in aws rds => https://explain.depesz.com/s/USMO ('PostgreSQL 11.10 on x86_64-pc-...
1
vote
0answers
29 views

Ltree query performance optimization of Postgres RDS DB

I have a AWS RDS m5.large Postgres 10.13 database that performs a lot of the following queries SELECT "bundles".* FROM "bundles" WHERE "bundles"."version_id" = $...
0
votes
0answers
21 views

Performance Insights MySQL RDS cannot change Counter Metrics or download full SQL

This is probably some permissions issue but I am trying to use Performance Insights on the AWS console for several MySQL RDS instances that are supposedly configured for it. I am following the ...
0
votes
1answer
19 views

MySQL import silently failing

I'm trying to import a large (30GB) SQL file (generated using mysqldump) into an RDS instance MySQL 5.7 database, from an EC2 instance on the same VPC. It's importing most without a problem, but ...
1
vote
0answers
27 views

AWS RDS MariaDB dropping connection after CREATE TABLE with CHECK followed by CREATE INDEX

I've spun up a fresh MariaDB T2 micro instance with all of the default settings (have observed same behavior on t3-micro and t3-small). Running this script: CREATE TABLE test ( id INTEGER NOT NULL ...
0
votes
1answer
47 views

Cannot use GRANT ALL anymore on RDS MariaDB 10.5 but can on 10.2

Using the default admin user I created on a new RDS instance with MariaDB engine 10.5 I cannot use the GRANT ALL anymore and instead get "access denied". This works fine on the 10.2 instance ...
-1
votes
1answer
44 views

How to checkdb automatically in AWS RDS?

I'm pretty new to Amazon AWS and RDS. I have migrated my SQL Database to RDS and I have it up and running. I'm now looking to automate maintenance tasks. Anyone with experience with RDS can help me ...
0
votes
1answer
11 views

Why is there a writable instance inside a secondary region for MySQL AWS Aurora Replica?

I have created two Aurora MySQL clusters with two nodes in two regions using terraform. The secondary region is set up to replicate from primary region using binlog. This seems to be set up correctly, ...
0
votes
1answer
8 views

Can I create another database on AWS read replica?

I am creating an MariaDB instance using AWS RDS I will also be creating a read replica of the DBinstance, what I also need is to host another DB on the replica, is it possible?
0
votes
0answers
6 views

Is an AWS RDS postgres snapshot read consistent - the same as a consistent export in oracle? What happens to transactions in play?

When a snapshot is requested, do all transactions in play get held open (not committed) during the duration of the snapshot creation - only writing the previously committed data to the snapshot?
1
vote
0answers
17 views

identifying relevant incompatibilities when upgrading from version 5.6 to 5.7 for mysql on AWS RDS Instance

I currently have an AWS RDS instance based on mysql version 5.6 that I need to upgrade to version 5.7. I understand that a comprehensive list of potential incompatibilities is given at https://dev....
0
votes
0answers
10 views

Amazon RDS Mysql with Binary Data Configuration

In Amazon RDS Mysql, when I run "\s", I see this (note the line: Binary data as: Hexadecimal) mysql Ver 8.0.22 for osx10.15 on x86_64 (Homebrew) Connection id: 12230 Current database: ...
0
votes
1answer
26 views

RDS Postgres chicken-and-egg problem altering roles

I just created an RDS Postgres instance, the user postgres (and it's master password), and connected via psql as user postgres. Then I ran the script generated from the current system using pg_dumpall ...
5
votes
3answers
367 views

Which factors impact the time for SQL Server Recovery to complete

In a recent planning AWS RDS failover we experienced long recovery times of around 20 minutes. AWS provides some hints around why. large transactions or a lengthy recovery process can increase ...
1
vote
0answers
60 views

What is the fastest way to copy large postgres(>1TB) database?

Original Problem Statement: Create a test DB with the latest production database(RDS Postgres)greater than 1.5 TB quickly. We have 1 production database running in a single instance and we have 8 dev/...
0
votes
1answer
43 views

Amazon RDS Slow Query Log Does Not Show SQL Statement

I enabled the slow query log on Amazon RDS and I executed a "select sleep(5)". But when I look at this table, how is it that sql_text does not show the actual SQL statement? mysql> select ...
1
vote
1answer
16 views

What are the risks of upgrading DB major version in replica and then promoting it as master?

Recently AWS decided to force update all MariaDB RDS under 10.3, my RDS is in MariaDB 10.1. We are trying to minimize the downtime and any risk of data out of sync. Our plan is to create a replica and ...
0
votes
1answer
32 views

Improving remake of primary key performance

I'm using a MySQL 5.7 hosted on AWS that has a table with about 500,000,000 rows and 124GB in size. I want to drop the existing primary key (id) and create a new composite primary key of 2 columns: ...
0
votes
2answers
74 views

How does AWS DMS on-going replication works internally?

From the documentation it's mentioned that "DMS collects changes to the database logs using the database engine's native API" and replicates to target. But, I didn't see anywhere that, at ...
1
vote
2answers
937 views

AWS DMS Task getting failed after completion with error as AlwaysOn BACKUP-ed data is not available

I have created DMS task for migrating data from one RDS MS SQL Server instance to another RDS MS SQL Server instance with "Full load + ongoing replication", and data copied to target ...
0
votes
0answers
10 views

How to validate source and target tables are sync or not in AWS DMS task ongoing replication?

I would like to know how to validate source and target database tables are in sync at some point of time with AWS DMS task type as "Full load, ongoing replication"? Source database Tables ...
-1
votes
1answer
35 views

what's the best way to execute fast aggregation queries based on YEAR and MONTH filters in addition to dynamic filters

My SQL table is going to have millions of rows. Currently, with only 2M rows, my aggregation queries take anywhere between 20 seconds to a minute. The filters in WHERE clause for aggregation queries ...
1
vote
1answer
56 views

Why do my RDS read IOPS drop after a certain period of time?

I am trying to add non-null constraints on several columns in a table with about 70,000,000 rows. Each statement is just ALTER TABLE table_name ALTER COLUMN column_name SET NOT NULL;, and each ...
0
votes
0answers
20 views

AWS RDS. CPU Usage 100%. Was it due to low max_connections?

What do you think is the reason of 100% CPU usage at around 10:45 (which is the same time as 19:45 (local time) in the last 4 graphs)? Is it because of low max_connections? The RDS instance is m4....
1
vote
1answer
47 views

Handle multiple simultaneous requests Mysql

sorry for this noob question. I do have an application which expects about 5000 users accessing it simultaneously, my current database is running on RDS and for each request, a query is called, it ...
0
votes
0answers
23 views

MySQL Database unresponsive with high network connections but low CPU usage, read and write operations

Had a spike in traffic that led up to 1.3k open connections for about an 8 minute window during which the database was mostly unresponsive. The CPU usage didn't go up over 10% and nothing extra ...
-1
votes
1answer
39 views

Schedule SQL Agent Job on RDS SQL Instance to restore latest backup weekly from S3

Scenario: I want to schedule an SQL Agent job weekly on RDS SQL instance to restore database which should access the latest backup file from S3. I'm using sp msdb.dbo.rds_restore_database to restore ...
0
votes
0answers
69 views

RDS PostgreSQL Transaction Logs grow with nightly backups

We have a production RDS for PostgreSQL instance that has a strange pattern of disk usage recurring in a manner consistent with the nightly backup schedule. Nightly, the backup is automatically ...
1
vote
0answers
46 views

Horrible MySQL database performance after upgrading from 5.5 to 5.6

I have run into a performance problem that I don't know how to solve with MySQL after Amazon forced us to upgrade our 5.5 MySQL instance to 5.6. We have a stored procedure which executed in about 10 ...
0
votes
1answer
99 views

innodb_autoinc_lock_mode = 2, real danger if not using AUTO_INCREMENT columns

I've got a MySQL RDS database that uses pure generated GUIDs for key columns. The current value of the innodb_autoinc_lock_mode is 1, and due to some performance bottlenecks we want to change it 2. ...
1
vote
2answers
307 views

Which AWS RDS; current t3.medium over CPU baseline, but not sure what's the next best option

I currently have one RDS instance, db.t3.medium running Aurora MySQL. Due to increase workload (expected), the CPU is, on average running just over its baseline and therefore in about 10 days will run ...
0
votes
0answers
77 views

AWS Postgres setting pg_trgm.word_similarity_threshold

Trying to set pg_trgm.word_similarity_threshold on an RDS postgres instance (postgres 12 if it matters): ALTER SYSTEM SET pg_trgm.word_similarity_threshold = 0.3; I get the error: must be superuser ...
0
votes
0answers
171 views

Error that role of the previous master user does not exist when restoring a database to a different server with different master username

I have to move a postgres database to another server. Both servers are Postgres 11.8 on Amazon RDS. I'm dumping the original jira database like this: pg_dump \ --dbname=postgresql://postgres:***@...
0
votes
0answers
54 views

Create a read-write role for a specific schema with read-only for all other schemas" on Postgres 9.6 on RDS

I am planning to implement 3 types of roles on PostgreSQL 9.6. We do not need users in our case. Below are the 3 roles I am trying to implement: Full Admin access role READ-WRITE to ignore schema ...
1
vote
1answer
122 views

PostgreSQL extremely slow counts

I'm experiencing extremely slow count(*) speeds, inside a table with 5845897rows, counting the number of rows takes around 2 minutes (113832.950 ms). EXPLAIN ANALYZE SELECT COUNT(*) FROM campaigns; ...
0
votes
0answers
31 views

Upload CSV data on AWS RDS PostgreSQL

I've built a basic webpage to push data to the PostgreSQL database on AWS RDS from a CSV file. The issue is the docs they have provided use CLI to do that. If I use direct SQL queries using \copy ...
0
votes
1answer
56 views

MariaDB (RDS) going temporarily offline (with memory drop)

We have an issue with a database of ours on RDS running MariaDB 10.4.8 on a t3-large instance type. For the past week or so, it's been sporadically inaccessible with no errors I can find. During the ...
3
votes
1answer
78 views

Testing MySQL adaptive_hash_index option

We recently migrated our application to an entirely new infrastructure, going from a single server managing everything to a kubernetes cluster and dedicated database server running on AWS RDS. On ...
0
votes
0answers
9 views

What happens when independent writes are made to a MySQL DB and its writeable read-replica

The problem: I have a production RDS MySQL DB (PROD-DB). Data from it is read and written to by my production API. I would like to deploy migrations to a replica of PROD-DB and have the UAT instance ...

1
2 3 4 5
16