Skip to main content
262 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
61 views

I have a COUNT(*) query that is really fast in several DB's, but is really slow on MySQL AURORA: I can't seem to figure out why. First I thought it was because it went the MEMORY went over the 4MB, ...
user3634184's user avatar
  • 466
1 vote
0 answers
77 views

Found solution If you are trying to do this too I'll leave this up so you can try to follow my steps and copy my code I am trying to connect a Lambda Function to an Aurora MySQL DB through a proxy ...
JasperS's user avatar
  • 11
2 votes
1 answer
154 views

I have created two partition table PartitionedTableA and PartitionedTableB. PartitionedTableB as FK on PartitionedTableA, when I run maintenance using partman.run_maintenance('PartitionedTableA') it ...
Adarsh H D Dev's user avatar
  • 588
1 vote
1 answer
109 views

I am using PostgresSQL 15 hosted by AWS Aurora serverless v2. I have a table includes 200 millions rows and I need to update a value on a column for all those rows. This table has primary key id which ...
Joey Yi Zhao's user avatar
  • 43.3k
0 votes
1 answer
371 views

FYI. This is a HOW-TO. As of Jan 2025, confirming that ServerlessCluster CDK-construct is NOT what you use for "Aurora-V2-Serverless" (in my case Postgres). You must use DatabaseCluster CDK-...
Sarma's user avatar
  • 470
2 votes
0 answers
69 views

I'm using GO (in a lambda) to connect to a serverless Aurora DB. I have a read and write instance. When creating the client I do the following: region := "eu-west-2" config, err := config....
Mark's user avatar
  • 429
1 vote
2 answers
93 views

I am trying to define a serverless Aurora database in clousdformation. I want to make use of the latest EngineVersion which allows you to set the MinCapacity to 0. (Screenshot attached of console ...
Mark's user avatar
  • 429
2 votes
0 answers
26 views

We have a table in our application in which users are allowed to delete a row from "staff_entries" table and the deleted row is also copied to another table (deleted_staff_entries) as it is (...
Ganapat's user avatar
  • 7,508
0 votes
0 answers
153 views

AWS DMS Source endpoint: Aurora Postgres Target Endpoint: Kinesis Data stream Task with these settings MigrationType: cdc TableMappings: | {"rules":[{"rule-type":"selection&...
Starlord5107's user avatar
  • 143
1 vote
1 answer
289 views

I have a single Aurora Postgresql serverless v2 cluster in AWS in one region. I am planning to deploy it to multiple regions by using global database. After some reading, I found in multiple regions ...
Joey Yi Zhao's user avatar
  • 43.3k
0 votes
1 answer
126 views

I am having a AWS Aurora Postgresql Cluster with an Severless instance as Primary instance and a Provisioned Instance as Replica instance. Primary instance will serve query from Application only and ...
TNH's user avatar
  • 1
0 votes
0 answers
109 views

Currently I'm using Aurora Serverless v1 which don't supports FDW(foreign data wrappers). I need to setup FDW for some requirement. I just want some ways to tackle this situation. 1.First approach may ...
Alok Kumar's user avatar
  • 1
0 votes
0 answers
33 views

We have a custom API developed to work with our AWS-hosted database. The API and database are currently running in the field, however, the only way to perform operations is by connecting via the '...
Tjanko04's user avatar
  • 1
1 vote
1 answer
620 views

I am trying to create a read replica for existing aurora postgres cluster using terraform. This is the script I use. resource "aws_rds_cluster" "test_db_cluster" { ...
Kstackr's user avatar
  • 57
0 votes
1 answer
298 views

My client claims that Aurora Serverless V2 guarantees an RPO of less than five minutes in the event of a disaster. Is it correct? I cannot find a clear reference except for Global Aurora (which does ...
BntMrx's user avatar
  • 2,377
3 votes
2 answers
619 views

I currently reate my Serverless V2 Aurora cluster with DatabaseCluster cluster = DatabaseCluster.Builder.create(...) and I'm trying to enable the new Data API for V2 but I don't see any way to do it ...
Nicklas Karlsson's user avatar
  • 449
0 votes
0 answers
25 views

I've created a VPC. By default the VPC created one public and one private subnet. I've created an additional private subnet in a different availability zone. I then (in the ElasticCache console) ...
Sushant Sharma's user avatar
  • 1
1 vote
1 answer
228 views

Getting this error on passing Dictionary<string,string> to hstore type column in postgresql Error: : 'Bytes written (44) and expected byte count (46) don't match.' If I try to convert it to ...
Akshay Mali's user avatar
  • 13
2 votes
0 answers
187 views

Hello Stack Overflow community, I've developed an application using AWS Amplify, and currently, it utilizes DynamoDB as the default database. However, I'm planning to migrate the data to Postgresql ...
Furkan Yılmaz's user avatar
  • 33
1 vote
0 answers
826 views

I am trying to connect AWS Glue Job with Aurora Serverless v2 PostgreSQL database, placed in isolated subnet. If someone did the same, I would really appreciate the correct steps and if someone can ...
aleksandralj's user avatar
  • 31
0 votes
2 answers
3k views

I have existing Aurora serverless v1 cluster running with engine version 5.7.mysql_aurora.2.11.3. I want to convert this cluster to serverless v2 using Snapshot and restore. But while restoring from ...
Suraj Pandey's user avatar
  • 117
1 vote
0 answers
238 views

I need to migrate from Aurora RDS back to on-premises (MySQL 8). As it is Serveless, is there a way to I determine how much CPU I will need in the virtual machine in the on-premises environment? My ...
Astora's user avatar
  • 767
0 votes
1 answer
1k views

We have a Aurora Mysql provisioned serverless v2 cluster running with 8.0.mysql_aurora.3.04.0. We want it to convert to Serverless v1. I got to know that Serverless v1 requires engine mode as "...
Suraj Pandey's user avatar
  • 117
0 votes
2 answers
443 views

I am evaluating Aurora Postgres serverless option. I created cluster and setup minimum ACU to 0.5 and max to 2. Even after few days without any load, it does not scale down to 0. What do I need to do ?...
Mike G.'s user avatar
  • 3
2 votes
1 answer
384 views

I'm using a Lambda via the Script and Function constructs to run database migrations against an RDS instance. However, the Lambda function can't connect to the RDS cluster despite being in the same ...
Steve's user avatar
  • 8,928
0 votes
0 answers
498 views

I am running DefectDojo on AWS using a serverless Aurora (Postgres 13.8) DB I see a large number of connect/disconnect events in the logs. They look like this: 2023-10-04 19:44:04 UTC:10.237.120.220(...
Simon Tower's user avatar
  • 704
2 votes
1 answer
2k views

We configured an Aurora Serverless v2 PostgreSQL in our cluster but unfortunately it doesn't scale down to 0.5 ACU. Our database size is around 700-800 gb. Info about our setup: In our app there is a ...
ak93's user avatar
  • 21
3 votes
0 answers
401 views

I am deploying an AWS Aurora serverless PostgreSQL database using AWS CDK. I've encountered an issue where I'm receiving the following error: Aurora postgres Serverless currently doesn't support ...
Jaynil Savani's user avatar
  • 380
0 votes
1 answer
173 views

How to implement a solution that will be resistant to Aurora cluster topology changes? We are using Hibernate with a Hikari connection pool. I've tried advanced jdbc adapter, but it does not work, it ...
user22628815's user avatar
  • 1
0 votes
0 answers
184 views

I have a few projects on AWS using the following setup: • Cognito - (user pools) • S3 - (frontend) • Cloudfront - (CDN proxies) • API Gateway - (REST APIs) • Lambda NodeJS 14 - (backend ...
Taha Erden's user avatar
  • 351
0 votes
1 answer
572 views

Currently I have an existing Aurora PostgreSQL cluster running in Serverless v2 mode created by terraform. # AWS Aurora Cluster resource "aws_rds_cluster" "aurora_cluster" { ...
MiGo's user avatar
  • 783
6 votes
1 answer
7k views

I'm creating an AWS Aurora Serverless V2 Postgres database cluster (AWS::RDS::DBCluster) using Cloudformation and Serverless Framework (see below). It's unclear if I should also create two database ...
Garbit's user avatar
  • 6,094
2 votes
0 answers
909 views

I'm having a difficult time finding an issue with my AWS Aurora V2 cluster. I have my ACU range set to 4 - 16. My ACUs in use usually hangs out at around 4 or 5 and my ACU Utilization average is ...
omatase's user avatar
  • 1,781
0 votes
2 answers
483 views

I'm trying to use and RDS with AppSync using this tutorial https://docs.amplify.aws/cli-legacy/graphql-transformer/relational/ but it appears to need Data API, only available on Serverless v1. I'm not ...
David-Julian BUCH's user avatar
  • 1
1 vote
1 answer
57 views

I'm having Aurora MySQL V2 RDS server. Following is my issue having table. `CREATE TABLE `my_tbl` ( `id` int(11) NOT NULL AUTO_INCREMENT, `col1` datetime DEFAULT NULL, `col2` varchar(20) NOT ...
Nuwan Madushanka's user avatar
  • 11
0 votes
1 answer
523 views

I have paid about fourty dollars for aurora database serverless, without using it. Though to pay for aws services, i wonder how this is possible, when i do not use the database myself at all? Does ...
David's user avatar
  • 3,153
0 votes
2 answers
800 views

I have an aws aurora severless rds. Once in awhile, i have queries run which involve a large number of records being joined and/or updated. When a resource intensive query kicks off, and the ...
da Bich's user avatar
  • 566
0 votes
1 answer
612 views

I have an AWS Aurora RDS cluster which I am upgrading from serverless v1 to serverless v2. The AWS documentation[1] suggests that the first step in this process via the AWS CLI is to use the --engine-...
GarlicBread's user avatar
  • 2,119
0 votes
1 answer
342 views

As per the AWS documentation of Aurora pgsql cluster, You can specify a backup retention period, from 1 to 35 days, when creating or modifying a DB cluster. Is there any way to keep this backup for ...
beginnertopython's user avatar
  • 131
3 votes
1 answer
878 views

I have an ecs task which is meant to run a database schema migration on an aurora serverless v1 in aws. According to most of the examples I've seen, the connection is enabled by saving the database ...
Boris's user avatar
  • 906
2 votes
1 answer
672 views

I'm trying to convert an AWS Aurora database cluster (Postgres version) from Serverless v1 to provisioned. The cluster has been recently successfully upgraded from version 11.16 to 13.9. I'm following ...
GarlicBread's user avatar
  • 2,119
0 votes
2 answers
2k views

I've been tasked with upgrading our AWS Aurora engine version from 11.16 to 15.2. We're running a Postgres-compatible engine. As part of this upgrade, it's also been suggested that we upgrade from ...
GarlicBread's user avatar
  • 2,119
0 votes
0 answers
31 views

I have deployed an s3 bucket via terraform using the following code: resource "aws_s3_bucket" "storage-dev" { bucket = "storage-dev" } resource "...
Boris's user avatar
  • 906
0 votes
0 answers
157 views

I'm creating a dev environment for my team and I need to move some data from an s3 bucket to an aurora serverless v1 postgres database. So far I have not found a straightforward example. There is the ...
Boris's user avatar
  • 906
0 votes
1 answer
3k views

I am creating Aurora-Postgresql using terraform module "terraform-aws-modules/rds-aurora/aws". When manage_master_user_password is set to true, it creates a secrets in Secrets Manager. ...
Kashiiif3's user avatar
  • 1
1 vote
0 answers
548 views

I recently moved from a VPS to AWS; set up EC2 and the other services and thought to move my MySQL database to Aurora Serverless. My application runs at least 2x slower than before! Batch PHP scripts ...
TechMafioso's user avatar
  • 135
1 vote
0 answers
154 views

It seems that Hebrew is not one of the built-in supported languages and it doesn't seem like there is a way to add custom dictionaries in Aurora Serverless Postgresql. Is there a way to get full text ...
Yosef G's user avatar
  • 11
0 votes
2 answers
669 views

I have an Aurora Postgres DB cluster running in Serverless V2 mode. When I try to clone it I can't select Serverless capacity type because it show the Serverless (incompatible minor version) message: ...
Maxim's user avatar
  • 10k
0 votes
1 answer
79 views

For what engines and versions is AWS Aurora Serverless v1 still available? I've been trying to find some combination in e.g. eu-west-1 and eu-north-1 that would allow for v1 in the serverless dropdown ...
Nicklas Karlsson's user avatar
  • 449
0 votes
1 answer
2k views

Recently we migrated to AWS aurora serverless(postgres) from a mongodb. We have some complex /heavy sort operations , so found that the performance can be improved by adjusting the work_mem.I tried to ...
Yashwanth Kata's user avatar
  • 887

1
2 3 4 5 6