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

131 questions
3
votes
1 answer

Updating an Aurora serverless from MySQL 5.6 to 5.7 with CloudFormation without loss

Context I need to upgrade a production Aurora serverless database from MySQL 5.6 to 5.7. All my resources are deployed as Infrastructure as a Code, with CloudFormation. Problem Updating the engine version in the CloudFormation template would result…
Rémy V.D
  • 180
  • 1
  • 10
3
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
  • 722
  • 8
  • 25
3
votes
0 answers

Connecting to Aurora Serverless from Lambda Django?

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
  • 76
  • 6
3
votes
1 answer

Is there a way to export data from S3 to Amazon Aurora serverless with lambda?

So I was searching for a solution that could let me export S3 data into Aurora Serverless. I know that the LOAD DATA request is only available for the Aurora cluster not the serverless one. I've found some documentation about the data injection…
Linda Naoui
  • 117
  • 10
3
votes
1 answer

Load CSV from S3 into AWS RDS Aurora MySQL Serverless

After looking around, I've found some documentation on reading a CSV from S3 into an AWS Aurora MySQL database table, but this does not seem to apply to SERVERLESS instances. Does anyone know how to do this? This is roughly how one would proceed…
OJT
  • 541
  • 4
  • 16
3
votes
2 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
  • 651
  • 5
  • 18
3
votes
1 answer

How to enable binlog on aurora serverless

I am setting up a new database using AWS Aurora serverless and have a requirement to enable binlog. I think I have followed the documentation as-is but can't get it to work. How do I set it up? Following the documentation, below is what I have tried…
anand apte
  • 33
  • 2
3
votes
2 answers

Syntax error when using Delimiters with Aurora Serverless MySQL 5.6

I'm using Aurora Serverless MySQL 5.6 to create the following trigger which will update one table when data is inserted into another table but am receiving syntax errors, specifically around the Delimiter keyword. DELIMITER $$ CREATE TRIGGER…
Josh Montgomery
  • 51
  • 3
2
votes
1 answer

Aurora Serverless with API Gateway and Lambda is timing out

I'm building a new project with totally serverless environment in AWS I picked up API Gateway + Lambda + Aurora Serverless inside a VPC but Aurora cold start plus Lambda cold start is greater than API Gateway timeout of 29 secods Is it possible to…
Thauany Moedano
  • 171
  • 1
  • 11
2
votes
0 answers

How to change default_authentication_plugin variable in Amazon Aurora Serverless MySQL 5.7.12

I'm using Amazon Aurora Serverless MySQL cluster(MySQL 5.7) and I want to change the value of global variable default_authentication_plugin which is currently set to default ie. mysql_native_password These are the commands I'm using to update the…
Vishal
  • 747
  • 5
  • 25
2
votes
1 answer

Why do hostnames of connections to Aurora Serverless come from outside the VPC?

I have a php website running in Beanstalk behind a load balancer. The website is connecting to a MySQL compatible database running as Aurora Serverless. Both the elastic beanstalk instance and Aurora is set up in the same VPC. The VPC CIDR is…
morras
  • 791
  • 4
  • 15
2
votes
1 answer

Aurora Serverless (Postgresql) - execute statement timeout 502

I am building a lambda api connecting to AWS Aurora Serverless Postgres. Follow AWS instruction to setup an Aurora Serverless with Postgres compatible (for MySql but still useful for Postgres):…
franco phong
  • 1,955
  • 2
  • 17
  • 32
2
votes
1 answer

Aurora Serverless 'deadtime'

I am running a SQL RDS with AWS Serverless, and run into errors when I test APIs. At the beginning of the day I will get a 502 error, however this resolves after I retry 1-4 times. I believe this error is due to some 'deadtime' that occurs when…
Nina
  • 99
  • 8
2
votes
1 answer

Send push notifications/emails when a query/mutation happends in AppSync/Aurora

I am using AppSync with Aurora/RDS. I would like that in some cases, when a query/mutation is sent to the db, then, after that, I want to send an email and push notification, but this should be detached from the query/mutation, that is, it does not…
Ricardo
  • 2,438
  • 4
  • 26
  • 39
2
votes
2 answers

Aurora serverless compatible version

I am trying to provision a Aurora Serverless database via Terraform. I have following setup. resource "aws_rds_cluster" "auth-db-cluster" { cluster_identifier = "auth-db-cluster" engine = "aurora-postgresql" …
Asur
  • 1,433
  • 2
  • 19
  • 32
1
2
3
…
8 9