Questions tagged with Amazon Relational Database Service

We're trying to set up a cross-account configuration where a glue job in Account A connects and pulls data from a DB in an Aurora MySQL RDS cluster in Account B, using IAM authentication. We've...

I am trying to upgrade AWS RDS MySQL instance from engine v5.7.42 to v8.0.33 and got below error while checking compatibility > ```MySQL 8.0 syntax check for routine-like objects The following...

We're using the [`aws_lambda.invoke` extension](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/PostgreSQL-Lambda-functions.html#aws_lambda.invoke) to invoke a lambda function from a...

Hello, I am trying to use materialized views in Redshift, where I have a Zero-ETL integration configured from Aurora MySQL to Redshift. Since the destination Redshift database is completely read-only...

Why would I be able to connect to mysql rds database locally but not on my ec2 environment?

I have two rds sql databases using the same vpc security groups and same vpc which has a public subnet connected to an internet gateway. Both are set to publicly accessible. However one connects to...

Hi, What are the differences between RDS/Aurora snapshot backup and AWS Backup copy. Any changes in restore procedure? For DR, do we need both or anyone type of backup is enough? Thanks, Satya

On August 22, 2024, old 2019 certificates are reaching EOL and need to be replaced (see below for full AWS notification details). I understand that I can modify the RDS instance and simple change the...

Hello, I am playing around on AWS to build my knowledge. I have an EC2 Instance with Postgres/psql on it and a postgres database. I am trying to migrate this to RDS using DMS, I have set up a the...

We are observing consistently that the v2 serverless doesn't fall back to 0.5 ACUs when there is no activity on the database. It stays at 1.5-2 leading to 3 times the cost. I have attached two charts...

Hi Folks, I have a postgres RDS connection that I wish to connect with my AWS Glue. The version is PostgreSQL 12.14 on x86_64-pc-linux-gnu. I require to use a custom JDBC driver which I have uploaded...

I have created my RDS cluster using CFT. This is the CFT which I used ``` { "AWSTemplateFormatVersion": "2010-09-09", "Description": "The template for aurora rds cluster.", "Parameters":...