Questions tagged [amazon-rds]

Amazon RDS (Relational Database Service)

Filter by
Sorted by
Tagged with
1 vote
1 answer
492 views

Can't connect Postfix to AWS MySQL RDS over SSL SSL_CTX_set_default_verify_paths

I'm trying to set up a mail server with Postfix (3.3.0) with virtual domains, queried against an Amazon RDS MySQL (8.0.11) instance, with SSL between the mail server and the RDS instance. I'm just at ...
30 votes
6 answers
28k views

How to associate an existing RDS instance to an Elastic Beanstalk environment?

I have created my RDS instance before creating my Elastic Beanstalk environment. The two are working together with no problem, but I'd like them to be linked together, and have the RDS parameters ...
2 votes
3 answers
4k views

Does anyone have a fast way to "warm up" an RDS instance created from snapshot

My understanding is that a new RDS instance will "page in" blocks from the snapshot on an as-needed basis, as is described for EC2 volumes here. This is currently causing me pain: I'm running a large ...
1 vote
2 answers
278 views

Is it possible to determine the type of instance for an AWS RDS MySQL instance from within MySQL?

I would like to know if it is possible for me to determine the instance type and storage available from the MySQL command line while connected to the RDS server. I have a project where the database ...
0 votes
2 answers
3k views

Cannot connect to AWS RDS MySQL from local computer with macOS

I'm new to database administration and trying to connect to an AWS RDS MariaDB 10.3.20 instance from my Macbook (10.14.6) on a home network -- having no luck. My understanding per other questions and ...
1 vote
2 answers
2k views

pgpool2 parallel mode: Non-superusers must provide a password in the connection string

I have two AWS RDS postgres nodes backing a parallel mode pgpool setup on EC2. After using pgbench to populate test tables, I get odd behavior from test queries. Any query that uses a function ...
5 votes
2 answers
2k views

If you can't change the RDS endpoint of an AWS Beanstalk instance, how do you do a blue/green deployment?

From what I can tell, one can't change the Amazon RDS (RDS) endpoint of an existing Elastic Beanstalk (EB) instance? If that is the case, than you can't have your code deployed to a stage server, ...
0 votes
1 answer
2k views

How to access an AWS RDS host in a VPC

I have setup my first AWS VPC. It has a public subnet, and two private subnets. One of the privates has an RDS instance, and the other is vacant (in a different AZ). I followed the tutorials on AWS ...
1 vote
2 answers
2k views

AWS RDS Postgres cross-account replication

Is it possible to set up cross-account replication with the AWS RDS Postgres database? The goal is to have a read-only replica in a separate AWS account. I know it's somewhat possible to accomplish ...
1 vote
2 answers
2k views

AWS MSSQL RDS Instance periodically timing out

Every 5 or so days (including just now) I get a barrage of timeout errors from my webapp. If I look at what my SQL instance is doing in CloudWatch, it reports this: Freeable space: http://cl.ly/NBRM ...
0 votes
1 answer
3k views

AWS RDS Cannot modify database instance due to IAM DB Authentication

I have a MySQL 8.0.13 instance running on AWS RDS. AWS documentation says that MySQL 8.0.* does not support IAM DB Authentication. This seems to be true, however my DB somehow has IAM DB ...
0 votes
0 answers
113 views

How to make start/stop time of an AWD RDS MSSQL instance quicker?

When I start/stop a simple AWS MSSQL RDS instance, it takes 5 minutes, even tho its nearly empty. How come ? Is there a way to make it faster ? Our on-premise MSSQL cluster apparently takes 10 seconds ...
0 votes
1 answer
2k views

Amazon RDS suddenly not working and unable to connect

I'm using an Amazon RDS with MySQL, and I connect to it via another EC2 machine. I correctly set the Security Groups; and it has been working good for two days. Today, for a test I scaled the RDS ...
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
718 views

AWS: Unable to drop MSSQL RDS database

We have an RDS MSSQL instance, configured as Multi-AZ. I created a test DB, "Moose" on RDS. After 5-10 minutes, it shows "(Principal, Synchronized)" in SSMS <= So far, so good. ...
0 votes
1 answer
890 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
3k views

AWS Freeable memory decreases from 16GB to 1GB

I have a MYSQL database hosted on RDS with 16GB RAM. I'm using an r4.large with 20GB General purpose SSD storage. We are using a microservice architecture and has 6 backend containers. So the request ...
1 vote
1 answer
2k views

AWS VPC Public Private Subnets - EC2 Instance cannot reach RDS instance

Following rposcibed pattern here: Scenario 3: VPC with Public and Private Subnets and Hardware VPN Access Summary Description: I have configured a VPC with 1 public Subnet and 2 private Subnets Each ...
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
3k views

Unable to connect with public postgresql rds instance : Connection Timed out

I created a basic test PostgreSQL RDS instance in a VPC. It is public and VPC security group. The security group whose configuration is as follows: Inbound Rule: Type: PostgreSQL Protocol: TCP Port:...
34 votes
3 answers
77k views

Why can't I create a superuser in AWS Postgresql instance?

I have an AWS EC2 instance connecting to an RDS instance (Postgresql). When I created the RDS instance, I told it the DB root's username was: my_user1 and the password was password1. Now I'm ...
1 vote
2 answers
140 views

How to set the vpc of a db instance when I create one via boto3's 'rds.create_db_instance'?

When I create a mysql db via AWS console, I can control to which VPC the db instance lands. However when i tried to use boto3 rds.create_db_instance to create a mysql db, the option is not available. ...
0 votes
1 answer
257 views

Hardware maintenance scheduled for AWS RDS - What could be the down time for the RDS instance which is in single availability zone?

One of my production RDS instance is scheduled for hardware maintenance. This instance is hosted in the single availability zone and storing the huge data. Now I'm worried that I cannot postpone the ...
3 votes
1 answer
3k views

Update Amazon RDS Certificate SSL Issue with MySQL Lambda

Like many people I have updated my Amazon RDS Certificate to CA_2019 from CA_2015. At first everything seemed fine but later on checking I noticed the mysql lambda function which i wrote to query the ...
31 votes
2 answers
48k views

Downtime for increasing AWS RDS storage?

I am looking to increase storage of two RDS instances (just the storage space allocated, not the instance type or other parameters). The documentation at https://docs.aws.amazon.com/AmazonRDS/latest/...
9 votes
4 answers
15k views

AWS RDS connection count

I am using AWS RDS with MySQL for a project and have a "large" instance. The documentation is clear on what this means as far as compute resources and RAM goes, but I can't find anything that ...
3 votes
2 answers
2k views

AWS restore_db_cluster_from_snapshot yet no instances

I'm writing an AWS lambda function to take my most recent snapshot of our production database and restore it as a new DB. This worked fine as a RDS instance but we recently switched our main DB to ...
5 votes
1 answer
7k views

Can't upgrade RDS instance from MySQL 5.7.x to 8.0.x

I need to recover data from an old 5.6.x snapshot. With a little bit of tinkering, I managed to get the 5.6.x snapshot restored on an m3.xlarge instance (any instance type other than m3.* won't work)....
61 votes
9 answers
136k views

How do you recover you RDS master user username?

Resetting the RDS master user's password is simple enough, but how do you find your master users username?
1 vote
0 answers
3k views

RDS does not support creating a DB instance with the following combination

AWS recently notified me I need to upgrade an RDS instance that's using an instance type that's being removed. So I logged in, and bumped up my instance size from m1.small to m5.large (the smallest ...
0 votes
1 answer
932 views

AWS Policy to Read/write RDS

In my scenario , I want a policy that will allow reading and writing of abc-database-backups/rds/postgresql-backup on S3? We'll want the my servers to have that access added. Is creating a role and ...
0 votes
0 answers
1k views

MySQL on AWS Aurora Workbench Timeout

Running Aurora with mySQL in AWS and accessing from a management machine in the same VPC. If I run the query from the command line (management machine) it finishes in about 2 minutes. If I run the ...
5 votes
2 answers
16k views

Amazon AWS RDS Burst Balance vs CPU Credit Balance

I'm trying to understand if I have spec'd my database appropriately. Below is a chart showing the WriteIOPS, CPUCreditBalance and BurstBalance for a t3.xlarge instance of SQL Server. It looks like I'm ...
1 vote
0 answers
207 views

Can a RDS Multi AZ w/one standby be converted to Multi AZ w/two readable standbys?

I'm looking at the two AWS RDS options for highly available databases : Multi-AZ with one standby Multi-AZ with two readable standbys https://aws.amazon.com/rds/features/multi-az/ My understanding ...
1 vote
1 answer
676 views

AWS RDS database - Incompatible-network

I'm creating a database on AWS RDS, but every time I do, the status is Incompatible-network. I'm wondering if it is because my Subnets have a deny all: But I can't seem to delete the deny all, it is ...
0 votes
1 answer
2k views

What is the data integrity of Amazon RDS? Do I need to make automated backups to S3?

I host my most valuable data on Amazon RDS. What is the failure rate of Amazon RDS, and what provisions do they have in place for high availability and data redundancy?
0 votes
1 answer
5k views

Connecting to Amazon RDS using SSH client

I have created an Amazon RDS instance and I want to connect to it using an SSH client (puTTY). I am following this document: Sign in to the AWS Management Console and open the Amazon RDS console at ...
1 vote
1 answer
431 views

Why does our Tomcat Java application suddenly open hundreds of connections to our database?

We have a Tomcat application running on Elastic Beanstalk and our MySQL database is hosted on AWS RDS (2 or 3 t3.medium instances). Ever since we upgraded from MySQL 5 to MySQL 8 (currently 8.0.23), ...
1 vote
1 answer
870 views

What is causing BadRequestException when calling the ExecuteStatement operation on Aurora Serverless db

I have a lambda function that retrieves records from AWS Aurora Serverless db. Now I thought of adding api gateway to trigger the lambda function but I get this error Connect an AWS Lambda function ...
0 votes
1 answer
642 views

AWS Aurora mySQL vs Aurora postgreSQL [closed]

We decided to go with AWS Aurora (and not with RDS-MSQL or RDS-PostgreSQL directly) Ignoring the SQL syntax differences and the different clients that I will use to connect. What are the main points ...
2 votes
1 answer
36 views

Managing AWS EC2 and RDS autoscalling configuraiton

A client of ours generally can get away with running just the one EC2 and also has an Aurora serverless MySQL 5.7 database running, however there are times when their load spikes up significantly. e.g....
0 votes
1 answer
96 views

AWS RDS Free Tier

I have setup an AWS EC2 instance over 12 months ago on the Free tier and it's now charging me, which is understandable since the 12 months free tier has expired for the EC2. I am now wanting to try ...
5 votes
1 answer
7k views

How to create a Super User Account on AWS's RDS Mysql?

The Master user has limited permissions on RDS. I need SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privileges, and I don't know how to add them to my user. Tried this solution from ...
0 votes
1 answer
168 views

AWS RDS PostgreSQL Upgrade from 9.6.22 to 10.17

I just finished upgrading my AWS RDS database engine from 9.6.22 to 10.17. I used these steps to make the upgrade using the AWS Console: Create snapshot of target database to upgrade Restore snapshot ...
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 ...
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'...
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
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 ...
53 votes
4 answers
69k views

What is "freeable memory"?

Amazon RDS has a metric for 'freeable memory'. It appears to go up & down in a sawtooth pattern. This leads me to believe that it's memory that is being used by MySQL for caching and that when ...
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 ...

1
2
3 4 5
12