Questions tagged [amazon-rds]

Amazon RDS (Relational Database Service)

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

EC2 Instance connection to an RDS instance accessible only via VPN

I have a Laravel application (API) that I am trying to move to AWS, however, the DB sits privately in AWS and is only accessible to me through a VPN. The database is an RDS instance. How can I provide ...
chewie's user avatar
  • 105
0 votes
1 answer
3k views

AWS RDS MySQL connection limits

I have a MySQL database server, db.t3.micro, parameter group is 'default.mysql8.0', max_connections is '{DBInstanceClassMemory/12582880}' I figured out that it cannot handle more than ~63 connections ...
John's user avatar
  • 542
0 votes
1 answer
2k views

Intermittent 500 Error caused by psycopg2.OperationalError: could not translate host name

20% of requests to our backend Django application (deployed on AWS using ECS and Postgres RDS) are throwing 500 errors. Looking at the ECS logs, various related errors are shown: psycopg2....
Zev's user avatar
  • 111
0 votes
0 answers
91 views

Can one detect, via the AWS RDS API, any I/O suspension when creating a snapshot for a single-AZ DB instance?

This is very similar to this existing question: amazon web services - RDS snapshot: how long does I/O suspension occur? - Server Fault Unfortunately, the only answer provides more of a background ...
Kenny Evitt's user avatar
0 votes
1 answer
1k views

restoring a DB snapshot to a different zone

I'd like to restore a snapshot from a DB instance in one region to a DB instance in another region. I can copy the DB identifier but in the Connectivity section I only have two options for "...
neubert's user avatar
  • 337
2 votes
1 answer
1k views

Find which RDS is using a certain parameter group?

How can I find which RDS database (if any) is using a certain parameter group? Clicking through each DB to check that is not a solution. There's too many DBs in the organization.
grdl's user avatar
  • 121
8 votes
1 answer
11k views

AWS: What is the difference between Burst Balance and EBS IO Balance metrics?

AWS Docs describe Burst Balance and EEBS IO Balance in the following way: BurstBalance The percent of General Purpose SSD (gp2) burst-bucket I/O credits available. EBSIOBalance% The percentage of I/O ...
Zillo's user avatar
  • 91
0 votes
1 answer
864 views

How to deploy multi master Microsoft SQL database as IaaS or AWS RDS

We have a vendor product, which support only relational databases (Oracle and MS SQL). Due to operational efficiency and cost, we are planning to use MS SQL. However, we have a challenge to deploy the ...
Indranil's user avatar
  • 101
0 votes
1 answer
636 views

Can't access RDS instance externally

I've spun up an RDS postgres database in an existing VPC (which has both public and private subnets - connected to a NAT gateway) which I've set as publicly accessible. I've added the relevant IP ...
Mike's user avatar
  • 23
4 votes
1 answer
4k views

How to get a local mysql dump of a specific AWS RDS Snapshot

Hello I have a linux bastion host in AWS that I am able to SSH into. In the Bastion I am able to run a mysqldump command which makes a copy of an RDS instance. What I want to accomplish is being able ...
CodeConnoisseur's user avatar
0 votes
0 answers
185 views

Migrating from Postgres RDS to Aurora without changing endpoint

I have around 40 micro services that connect to my Postgres RDS database. Now I am considering migrating to Amazon Aurora. Each of the connections connect to the RDS endpoint and modifying that across ...
David's user avatar
  • 447
4 votes
1 answer
807 views

Will critical security updates get applied even with "auto minor version upgrade" disabled?

RDS offers an "auto minor version upgrade" setting, described in the docs, which causes AWS to automatically upgrade your database engine from time to time: If you want Amazon RDS to ...
Mark Amery's user avatar
2 votes
2 answers
2k views

Can't create free-tier AWS RDS DB

I can't seem to create a 12-month free-tier AWS RDS DB running MySQL. According to AWS, the following requirements need to be met for a 12-month free-tier RDS DB: 750 Hours per month of db.t2.micro ...
jlnkls's user avatar
  • 23
2 votes
2 answers
11k views

AWS RDS: Invalid max storage size for engine name postgres and storage type gp2: 198

I'm getting this error while modifying DB instance. Invalid max storage size for engine name postgres and storage type gp2: 198 for schedule autoscaling. This only happened yesterday, it's weird. Here ...
JamesBowery's user avatar
0 votes
1 answer
2k views

Why can't my DB back up to my S3 bucket?

I'm trying to test a differential backup and restore on an RDS SQL Server 2019 instance in preparation for migrating some web resources into AWS. Both the EC2 instance (Windows Server 2019) on which I'...
Don R's user avatar
  • 153
1 vote
1 answer
505 views

MySQL RDS Performance Insight got stuck

We are using AWS MySQL RDS. Quite recently, we are saw MySQL RDS Performance Insight got stuck with SET `@slave_uuid` = ? Like the following image The second one that follows the above is Use `...
Set Kyar Wa Lar's user avatar
1 vote
0 answers
173 views

Aurora MySQL - How Much IOPS Am I Using?

I am testing Aurora MySQL as a possible replacement to Aurora Postgres. When bulk loading data into Aurora Postgres, it's very easy to see how mush Postgres is going to cost just by looking at the ...
micah's user avatar
  • 221
0 votes
1 answer
114 views

Can a replica to an RDS MySQL instance be setup outside RDS?

I have a running RDS Mysql 5.7 instance that I would like to replicate to a MySQL 8 instance running on a Linux server (not on RDS). Is this possible? I cannot find an option to do this from the ...
EastsideDev's user avatar
4 votes
1 answer
4k views

Cannot connect to Amazon RDS with TLSv1.2

I set up a new machine with Ubuntu 20, and found I wasn't able to connect to my RDS databases anymore. The spring-boot application that was supposed to connect to the development environment throws ...
UncleBob's user avatar
  • 247
0 votes
1 answer
487 views

AWS budget cannot do stop RDS action

I do not want to create an IAM user: I am logged in as root in AWS console. How can I create a role such that my RDS instance stops on budgeted amount? I do always get the error when I configure a ...
Leder's user avatar
  • 101
0 votes
0 answers
343 views

MariaDB on AWS RDS curiously takes up 60GB of storage occasionally in a very short span of time

I have a small MariaDB RDS Instance running on AWS. Every once in a while, the instance quickly starts to use the available storage (not the tablespace) and becomes 100% full, i.e. 100% storage full. ...
remudada's user avatar
0 votes
0 answers
49 views

What exactly does the AWS Pay For What You Use policy mean?

Well, I was fed up with the absurd host prices here in Brazil when I got to know AWS and the pay-as-you-go policy. I recently started a course for the solution architect certification (SAA2), that's ...
Samuel Ives's user avatar
0 votes
1 answer
2k views

Can't Connect to an RDS from my home computer in AWS

I need to connect to an RDS from my home computer. This is an established database, I'm migrating it to a new system. I can not connect to it from my home computer. I have set the security to Public ...
Some Guy Trying To Do Math's user avatar
0 votes
0 answers
493 views

Major difference in storage measured by Amazon Aurora vs Postgres

When I query postgres for the size of all databases, I'm getting 430 GB. select pg_size_pretty(sum(pg_database_size(d.datname) )) from pg_catalog.pg_database d; > 430 GB However, Amazon Aurora is ...
jaynp's user avatar
  • 235
0 votes
1 answer
2k views

Why is my database restore failing with ConnectFailure exception?

I am trying to restore a SQL Server database to an AWS RDS instance from a full backup file created on a different non-RDS server. I am running the operation from an EC2 Windows Server instance in the ...
Don R's user avatar
  • 153
1 vote
1 answer
870 views

Are managed databases (e.g. Amazon RDS) slower to access than database in the same machine (EC2) as web server

Imagine two cases: I have web server running in an EC2 instance and it is connected to the database in the RDS, the managed database service. I have web server and database running in the same EC2 ...
abcDE's user avatar
  • 11
-1 votes
1 answer
741 views

How to diagnose cross account EC2/RDS connection with vpc flow logs in AWS?

In AWS, made 2 accounts. account 1: A | Deployed EC2 account 2: B | Deployed RDS Want to connect from account 1's EC2 to account 2's RDS, but doesn't work. So enabled VPC flow logs to diagnose where ...
Miantian's user avatar
  • 137
2 votes
1 answer
537 views

Schedule RDS upgrades/downgrades

I have a project that sends notifications to various services. Users manage their subscriptions 24 hours a day, but we need a stronger MySQL RDS instance during the week (t3.xlarge), specifically Tue-...
Ben's user avatar
  • 3,870
2 votes
1 answer
4k views

How to connect RDS from a different account with allowed IP in AWS?

I have an EC2 instance in AWS account A. Its Private IPv4 addresses is 10.111.12.23. I allowed it in a RDS security group rules in account B, to make Type CIDR/IP - Inbound's Rule 10.111.12.23/32. ...
Miantian's user avatar
  • 137
0 votes
1 answer
331 views

>150Million records insert select query canceled after 12 hours AWS RDS

I have a AWS RDS t2.micro storing over 150 million records in a table from which i need to make a select insert query to another table, the purpose of this select query is to make a percentage ...
Christopher Martinez's user avatar
-1 votes
2 answers
611 views

Aurora reader storage cost

that should be simple, but I cannot figure that out Amazon bills the real used storage amount for Aurora databases, not the allocated storage like for non-Aurora. there is a metric VolumeBytesUsed - ...
John's user avatar
  • 542
0 votes
2 answers
184 views

Given an existing unencrypted AWS EFS volume, can somebody give me a path for encrypting it without data loss?

We have discovered that we really ought to have encrypted the MySql database and EFS volume on our application, at the time of creation. We are now attempting to correct the oversight. I've read the ...
hbquikcomjamesl's user avatar
2 votes
2 answers
9k views

How can I find the IP addresses of an AWS RDS instance

I have an RDS instance on AWS running MySQL. "Public availability" is set to "yes", and I can connect using the endpoint dns name. Using the AWS console, how can I find both the ...
DatsunBing's user avatar
1 vote
0 answers
141 views

What AWS S3 class is used by RDS backup?

According to AWS RDS FAQ, "Amazon RDS DB snapshots and automated backups are stored in S3." I wonder what S3 class is used by AWS ? I want to know if RDS backups are stored only on the same ...
Yanal-Yves Fargialla's user avatar
1 vote
1 answer
789 views

Do I need 1 RDS Cluster for each DB or a single RDS Cluster for all my DBs?

Let's suppose I have 5 databases I'm going to use in my application. The application will be used by +100k users. I'm planning to use RDS Cluster with Aurora PostgreSQL. What would be best? Create 1 ...
Castro Roy's user avatar
1 vote
1 answer
4k views

How to create AWS RDS user using Terraform?

I'm trying to create an application users for my Aurora RDS using Terraform. I can only find links for creating a MySQL user or a Postgresql user but not a generic one for Aurora.
uday's user avatar
  • 382
1 vote
1 answer
2k views

How to reduce size of my RDS mySql database of 5000 GB to 2000 GB, with all the triggers and functions intact?

I have a RDS MySql database of provisioned storage 5000 GiB. Out of 5000 GiB I am using only 1400 GiB and want to reduce size of provisioned storgae to 2000 GiB. All the tables are innoDb. I want to ...
shreyanshu agarwal's user avatar
0 votes
0 answers
571 views

Amazon RDS PostgreSQL: Sudden increase in Read IOPS

We are using Amazon RDS to host our PostgreSQL databases. Our production instance (db.t3.xlarge, Single-AZ) was running smoothly until suddenly Read IOPS, Read Latency, Read Throughput and Disk Queue ...
berkerol's user avatar
2 votes
1 answer
13k views

"timeout expired" when trying to connect to RDS PostgreSQL server with pgAdmin

I am trying to connect to a Postgres RDS instance with pgAdmin, and I get the vague error 'timeout expired' every single time. This situation is especially strange, because my colleagues who are all ...
I am a Terrible Programmer's user avatar
1 vote
0 answers
112 views

How to best MySQL configuration in AWS RDS? [duplicate]

We have an e-commerce system which is currently deployed in EC2 instance. currently MySQL is in the same server and now that we are getting high traffic now and then, we're planning to use Autoscaling ...
user14108508's user avatar
2 votes
2 answers
530 views

LOW IOPS after MySQL RDS Upgrade

We were hitting the upper limits of our IOPs the last several days. We provisioned more IOPS a few times. 1250 -> 2500 -> 4500. Each Step we quickly saw we were using all the available IOPS as ...
MichaelWClark's user avatar
0 votes
0 answers
101 views

AWS Aurora/MySQL server crashes with spatial query

We are using AWS Aurora/MySQL, engine version 5.7.mysql_aurora.2.09.0 and we have a spatial index on a table with ~10,000,000 rows: CREATE TABLE `foo` ( ... `lat` decimal(10,6) DEFAULT NULL, `...
Dave L's user avatar
  • 1
-1 votes
1 answer
38 views

Why a MultiAZ db.t2.small reserved instance costs two normailzed units?

I have a MultiAZ Aurora MySQL cluster with 2 db.t2.small instances, the Master and the Read Replica Now I want to buy MultiAZ Reserved Instances for both db.t2.small instances but when doing the ...
Matias Haeussler's user avatar
0 votes
1 answer
726 views

Managing RDS Aurora MySQL connections per user or database

I have an RDS Aurora MySQL 5.7 and a number of independent applications connected to it. Some of them are real-time websites while others are batch services (connected mostly to the reader). A recent ...
Leo's user avatar
  • 445
1 vote
1 answer
719 views

Codeignitor - under login / session load MySQL CPU spike and Fatal MySQL Deadlock

Originally posted on stackoverflow, and was recommended serverfault may be better place. I have a site using: AWS RDS (MySQL Aurora) - single t3.medium instance 4 x EC2s on a Load Balancer (fixed ...
rjbathgate's user avatar
0 votes
2 answers
507 views

How do we install custom fonts on SSRS in AWS MS SQL hosted on RDS

We are using the new SSRS option on the AWS RDS, we have to install a custom font for a report that we are working on. I have checked the documentation and we notice that there is only option to ...
user129615212's user avatar
3 votes
1 answer
1k views

Create Postgres index on RDS is far slower than a weaker linux host

Background: Postgres 10.9 DB runs as a docker container on the dev hosts. (t3.large, gp2 500GB storage) DB runs in RDS for staging and production. (m5.2xlarge, gp2 1TB storage) Everything works ...
Rino Bino's user avatar
  • 593
0 votes
1 answer
141 views

Recreate encryption Keys in MS-SQL RDS instance on AWS

We are running Microsoft SQL server Standard edition running on AWS RDS, We had recently upgraded from sqlserver-se version 14.00.3223.3.v1 to version 14.00.3281.6.v1 as per the recommendation. We had ...
user129615212's user avatar
1 vote
1 answer
377 views

How to implement this AWS RDS Purchase recommendation?

I have 2 RDS databases size db.t2.medium. I went to AWS recommendations and got this: So far I've done only EC2 reservations. I am not sure how to proceed from here. First I guess I have to make the ...
Oscar Foley's user avatar
2 votes
0 answers
929 views

High CPU since upgrading to MySQL 5.7 from 5.6

We are using an AWS RDS managed MySQL db.m4.2xlarge instance with db engine 5.7.30, we upgraded from 5.6 two days ago and have high CPU since - generally 10-15% higher reaching 100% at peek. Please ...
Edward Spencer's user avatar

1
2
3 4 5
12