Stack Overflow
Stack Overflow

Questions tagged [aws-aurora-serverless]

For questions specific to the usage and features of Amazon Aurora Serverless. When using this tag also include the more generic [aws-aurora] tag.

Amazon Aurora Serverless is an on-demand, auto-scaling configuration for Amazon Aurora (MySQL-compatible and PostgreSQL-compatible editions), where the database will automatically start up, shut down, and scale capacity up or down based on your application's needs. It enables you to run your database in the cloud without managing any database instances. It's a simple, cost-effective option for infrequent, intermittent, or unpredictable workloads.

AWS Aurora Serverless

245 questions
29
votes
3 answers

When will Aurora Serverless V2 have a Data API?

I've seen that V2 is out now but there is no option to have the data api and the docs say it is only available on V1. The Data API can be enabled for Aurora Serverless v1 DB clusters using specific Aurora MySQL and Aurora PostgreSQL versions only.…
Angelo Mermiklis
  • 317
  • 1
  • 3
  • 4
23
votes
5 answers

Creating an Aurora Serverless Cluster from cloudformation?

From Aurora Serverless's document, there are 3 ways to create an Aurora serverless DB cluster: AWS management console, CLI, and RDS API. (https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/aurora-serverless.create.html) Form my understanding,…
howard.h
  • 808
  • 1
  • 8
  • 14
16
votes
4 answers

Amazon aurora postgres serverless: Database returned more than the allowed response size limit

We are exploring aurora serverless as a database storage for one of our project. While doing the POC to fetch events from aurora serverless cluster we are receiving "Database returned more than the allowed response size limit" exception. Is there…
Shiv Choudhary
  • 161
  • 1
  • 3
10
votes
2 answers

Upgrading from AWS Aurora Serverless v1 to v2 fails

So with Aurora Serverless v2 available we wanted to upgrade from our Postgres Serverless v1. The steps described are basically to take a snapshot, create a new Provisioned Aurora cluster (not Serverless) and then upgrade the Provisioned Cluster to…
Anders
  • 3,198
  • 1
  • 20
  • 43
9
votes
3 answers

Are there Node.js examples for how to connect to AWS Aurora Serverless PostgreSQL via Lambda

I've set up an AWS Aurora Serverless PostgreSQL DB. I've also got API Gateway running endpoints to Lambda functions. Right now the Lambda functions are connecting to DynamoDB, but RDS is going to work better for my use case. I've scoured the…
Aaron Austin
  • 225
  • 1
  • 2
  • 9
8
votes
2 answers

Python Connect to AWS Aurora Serverless MySQL Using SQLAlchemy

Is there a way to specify my connection with SQLAlchemy to an AWS RDS Aurora Serverless MySQL database instance without a Secrets Manager ARN? I have the database username, password, endpoint, ARN, etc., and ideally I would initialize an engine,…
OJT
  • 887
  • 1
  • 10
  • 26
7
votes
3 answers

Aws Aurora serverless v2 will not scale down to .5 ACU even though 0 connections

I'm running a v2 instance and from the documentation aws states you should only be paying for resources that you are actually using. I have an instance than is most of the time at 0 connections but it never scales down under 2 ACUs. See images below…
Ben Walton
  • 399
  • 3
  • 11
7
votes
1 answer

How to manage typeORM connection of Aurora Serverless data api inside Lambda using Serverless Framework

I'm using: Aurora Serverless Data API (Postgres) TypeORM with typeorm-aurora-data-api-driver AWS Lambda with Serverless framework (TypeScript, WebPack) I'm connecting to the db like it's described in github, const connection = await…
Ivan
  • 852
  • 1
  • 12
  • 29
7
votes
1 answer

RDS Serverless - Slow warm up?

I'm not sure if this is intended or I configured it incorrectly. I set up my Aurora Serverless PostgreSQL Database to pause after 5 min of inactivity. Problem is, everytime I try to access it after it has paused, it takes almost 1 minutes for the…
Mojimi
  • 2,561
  • 9
  • 52
  • 116
7
votes
3 answers

Export from Aurora Serverless into S3

I am currently trying to export a .csv file from AWS Aurora Serverless with a MySQL Engine to AWS S3. This works perfectly fine when using an Instance backed Aurora but not with the serverless. I set up IAM Policies for the S3 as written in the…
psk98
  • 71
  • 1
  • 3
7
votes
4 answers

Unable to serialise AWSDate from RDS in AppSync response mapping template

I'm building an AppSync project using serverless Aurora as my db, and stumbled across this strange error: "Can't serialize value (/getUsers/created_at) : Unable to serialize `2019-09-28 07:36:13` as a valid DateTime Object." This happens when I get…
Jesper Bylund
  • 883
  • 9
  • 23
7
votes
2 answers

Is there any mock(or local) service of aurora serverless Data Api?

I have replaced the way to connect Database from lambda function. Previously, the function established a connection to RDS using MySQL module and query via 3306 port. Currently, I tried to use Data API and I have finished to replace all codes…
anizo
  • 237
  • 4
  • 14
6
votes
2 answers

How to connect an on-premises application to AWS Aurora Serverless

We have a bunch of on-premises applications each running their own local MySQL servers. Our workload is light, with occasional bursts of activity (a B2B business model with some specific times of the month in which it is more profitable to use our…
Chris Browne
  • 1,582
  • 3
  • 15
  • 33
6
votes
0 answers

"Task timed out after 30 seconds" connecting to Aurora Serverless from Django Lambda Function

I want to connect to my Aurora Serverless mysql database inside of my django Lambda function. Currently, I have: a Lambda function inside of the default VPC Uses the default security group Uses two public subnets I created Allows inbound requests…
Connor Fogarty
  • 316
  • 1
  • 10
6
votes
2 answers

Not able to connect Amazon Aurora Serverless from SQL client

Today I've created Amazon Aurora Serverless cluster for PostGreSql in us-west-2, ensured the VPC and security groups in a way that, it should be publicly accessibly. But I'm not able to connect that cluster using the aurora endpoint from my…
A l w a y s S u n n y
  • 36,497
  • 8
  • 60
  • 103
1
2 3
…
16 17