Questions tagged [amazon-rds]
Amazon RDS (Relational Database Service)
559
questions
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 ...
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
...
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....
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 ...
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 "...
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.
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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'...
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 `...
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 ...
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 ...
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 ...
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 ...
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. ...
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 ...
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 ...
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 ...
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 ...
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 ...
-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 ...
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-...
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.
...
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 ...
-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 - ...
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 ...
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 ...
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 ...
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 ...
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.
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 ...
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 ...
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 ...
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 ...
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 ...
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,
`...
-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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...