All Questions
Tagged with aws-cloudformation amazon-rds
161
questions
63
votes
5
answers
27k
views
Is there a way to run initial SQL when creating an RDS database instance using CloudFormation?
I am creating an RDS instance using CloudFormation using this:
"Resources": {
"myDB": {
"Type": "AWS::RDS::DBInstance",
"Properties": {
"...
- 10.3k
25
votes
4
answers
11k
views
RDS with Cloud Formation and AZ issues
I am using cloud formation to create a setup containing an RDS instance.
I am having some difficulties creating the RDS Instance on the account of the following error:
DB Subnet Group doesn't meet ...
- 11k
21
votes
3
answers
45k
views
RDS does not support creating a DB instance with the following combination
I'm trying to figure out how to create a simple DB instance. I have so far only a DBSubnetGroup and DBInstance. At this point, I've figured out a couple things based on the errors I get when I try to ...
- 1,264
16
votes
2
answers
8k
views
AWS CloudFormation - Create Tables After RDS Instance Is Ready?
CloudFormation amateur here. Been looking online and can't find any references as to how I would go about creating my tables after my RDS instance is stood up through CloudFormation. Is it possible to ...
- 12.8k
15
votes
1
answer
13k
views
How do I restore RDS snapshot into a cloudformation?
I want to restore an RDS instance from a snapshot and have it replace an instance in a cloudformation.
Let's say I have one EC2 instance connected to one RDS instance in a cloud formation and I want ...
- 1,095
10
votes
5
answers
6k
views
Cloudformation template for AmazonRDSEnhancedMonitoringRole
I am attempting to spin up an RDS stack via a Cloudformation template. I would like to enable Enhanced Monitoring on my DB instances. In order to do that, the MonitoringRoleArn property must be ...
- 870
10
votes
1
answer
8k
views
CloudFormation : Template RDS Mysql to Create DB, Tables, User, or Load Schema
Using CloudFormation, I'm trying to figure out a few use cases.
The first case is having an existing AWS RDS MySQL server, how to create a database, tables, and a user account though a ...
- 187
9
votes
1
answer
2k
views
Getting an Aurora Serverless Cluster ARN in CloudFormation (Output)
I am having trouble retrieving the ARN for a new RDS Aurora Serverless cluster inside a CloudFormation template.
Can someone please advise on what reference the output value should be below?
Resources:...
- 1,993
8
votes
1
answer
9k
views
Receiving a validation error detected: Value '[AWS:RDS::DBInstance]' at 'typeNameList' failed
I am trying to create an RDS server running MySQL database and receiving the following error:
1 validation error detected: Value '[AWS:RDS::DBInstance]' at 'typeNameList' failed to satisfy constraint: ...
- 91
8
votes
1
answer
2k
views
Creating a publicly accessible RDS instance in AWS Cloudformation
I'm totally throwing my hands up with this one. I've been trying to create a publicly accessible RDS instance using CloudFormation. I want to be able to connect to my instance via a mysql client. ...
- 2,430
7
votes
2
answers
2k
views
On aws-rds on aws-cdk, where is the setting to make database publicly accessible?
With AWS RDS, the console and the CLI/API both have a switch to make the database publicly accessible, but I cannot find a way to do this with the new aws-cdk using the constructs provided. There is ...
- 1,385
7
votes
2
answers
2k
views
DeletionPolicy:Snapshot cannot be specified for a cluster instance, use deletion policy on the cluster instead
I am trying to create RDS cluster and aurora instance using the cloudoformation template below:
{
"AWSTemplateFormatVersion" : "2010-09-09",
"Description" : "example setup",
"Parameters" ...
- 3,171
6
votes
3
answers
7k
views
Which RDS DB instances are supported for DB Proxy?
I'm trying to create a RDS DB Proxy for a Postgres 12.3 RDS instance (not Aurora) via CloudFormation. Stack creation fails with the following message:
Database engine POSTGRES 12.3 for DB Instance db-...
- 3,721
6
votes
2
answers
12k
views
RDS Proxy Target groups Unavailable
I have just created RDS Proxy by Cloud Formation
In Proxies dashboard, it showed RDS proxy is available, but Target groups are unavailable, I can't debug this and got stuck in Cloud Formation update ...
- 117
6
votes
1
answer
953
views
ReadEndpoint.Address was not found for DBCluster
I am adding route 53 to my DBCluster and keep running into the error: Attribute: ReadEndpoint.Address was not found for resource: <DBCluster-name>
The entire stack is created via ...
- 2,060
6
votes
3
answers
5k
views
The engine mode serverless you requested is currently unavailable with 5.7 (2.07.1)
Trying to create an RDS aurora server less with MySQL 2.07.1
and got an error "The engine mode serverless you requested is currently unavailable. (Service: AmazonRDS; Status Code: 400; Error Code:...
- 91
6
votes
2
answers
2k
views
Create CloudFormation Yaml from existing RDS DB instance (Aurora PostgreSQL)
I have an RDS DB instance (Aurora PostgreSQL) setup in my AWS account. This was created manually using AWS Console. I now want to create CloudFormation template Yaml for that DB, which I can use to ...
- 1,523
6
votes
2
answers
6k
views
Is it possible to dump a RDS database to S3 using AWS Data Pipeline?
Basically I want to pg_dump my RDS database to S3 using AWS Data Pipeline,
I am not 100% sure if this is possible I got up to the stage where the SqlDataNode wants a selectQuery at which point i am ...
- 824
6
votes
4
answers
3k
views
Aurora Serverless password rotation setup using CloudFormation (and Lambda rotation templates)
AWS has Fully Configured and Ready-to-Use Rotation Support for some supported RDS engines, including Amazon Aurora (Serverless also?)
I'm trying to setup the password rotation in my CloudFormation ...
- 30.5k
6
votes
3
answers
1k
views
AWS Cloudformation: Enable PostGIS Extension in RDS from Cloudformation
New to cloudformation. I am spawning PostgreSQL RDS instance using a aws cloudformation script. Is there a way to enable PostGIS (and other extensions) from aws cloudFormation script?
- 1,319
5
votes
1
answer
3k
views
RDS does not support creating a DB instance
I am trying to create postgres rds using cloudformation but it give me this error
RDS does not support creating a DB instance with the following combination: DBInstanceClass=db.t2.micro, Engine=...
5
votes
2
answers
4k
views
AWS Cloudformation to enable Performance Insights
Does anyone know if enabling Performance Insights (for AWS Aurora) is available in CloudFormation?
Its available in Terraform as performance_insights_enabled, but I am not able to find equivalent in ...
- 2,319
5
votes
1
answer
5k
views
How to get RDS instance hostname in CDK app?
I'm using the AWS CDK for .NET to create a stack that consists of a VPC, an RDS Database Instance and an Application Load Balanced Fargate Service in ECS. The container I'm deploying to ECS requires ...
- 4,181
5
votes
2
answers
2k
views
How to set the PreferredBackupWindow parameter in RDS CloudFormation template?
I want to launch an RDS instance from CloudFormation.
I am constructing the JSON template based on the AWS documentation .
I want to set the PreferredBackupWindow parameter, but there is no example ...
- 3,543
5
votes
1
answer
3k
views
AWS CloudFormation: CREATE_FAILED DBSecurityGroup is not supported in this region (London)
I am trying to reapply a cloudformer template from another account but in the same region, EU-West-2 (London). When I apply the template I get the following error:
10:05:10 UTC+0100 CREATE_FAILED ...
- 51
5
votes
3
answers
2k
views
Can we promote RDS read replica to primary using cloud formation template?
We can easily promote RDS read replica using console and CLI, but is there a way to give master access means promote to primary using cloud formation?
- 141
4
votes
3
answers
6k
views
Cloud Formation Set RDS Endpoint to Route53 CName Record
Below is an example cloud formation file in YAML format. The idea is to make the Route53 Record depend upon creation of the RDS Database and then once its created get the value from the endpoint of ...
- 8,932
4
votes
1
answer
2k
views
How to bootstrap RDS MySQL to create table every time the stack is up?
I'm trying to bootstrap my RDS from Cloudformation. I've used the template from here https://s3.amazonaws.com/cloudformation-templates-us-east-1/RDS_MySQL_55.template.
I can create the RDS from cfn-...
- 12k
4
votes
1
answer
3k
views
InvalidParameterCombination error deploying RDS database cluster
Have an RDS database cluster. The deployed version in AWS has the following attributes:
Engine: aurora-postgresql
EngineVersion: '10.11'
My cloudformation template specified 'EngineVersion 10.7', but ...
- 509
4
votes
2
answers
2k
views
I can't connect mysql client to RDS through VPN
I've been really struggling to use AWS RDS. All networking configuration things is a really pain in the back since I have no skills in networking and I don't like it either.
My goal is to create my ...
- 2,528
4
votes
1
answer
4k
views
Can you create Schema on RDS created with Cloudformation Using Lambda?
We have a cloudfrormation script that creates our MS SQL Server DB.
We have a lambda function we run to load the schema from S3 and run it against our newly created DB.
We do have to update the ...
4
votes
1
answer
2k
views
Enable AWS RDS Auto Scaling via Cloudformation
I have RDS instances running in my AWS account created via a Cloudformation template. Recently there was a storage-full occurrence and as immediate remediation, I modified storage size from default 20 ...
- 1,303
4
votes
2
answers
2k
views
AWS RDS Proxy configuration
I need to create a VPC + RDS Postgres DB + RDS Proxy with private subnets, I'm setting up everything with CloudFormation using serverless.
I'm able to configure everything except the RDS Proxy, when I ...
- 4,492
4
votes
0
answers
2k
views
How to grant Lambda an access to RDS using CDK?
There is this very nice abstraction when using DynamoDb:
table.grantReadWriteData(lambda);
This development gave me hope to have the same for RDS.
- 9,002
3
votes
1
answer
2k
views
AWS CloudFormation: Unable to find existing SG to assign to RDS instance
Created and exported a SG from one template/stack:
Resources
RDSSecurityGroup:
Type: AWS::EC2::SecurityGroup
Properties:
GroupName: "sg-name"
Outputs:
SGRDS:
...
- 18k
3
votes
1
answer
2k
views
Do I need to create a reader and writer db instance when creating an AWS Aurora Serverless V2 cluster?
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 ...
- 5,946
3
votes
2
answers
3k
views
Cloudformation RDS Aurora : Invalid Storage Type
Following is my CFD script to create an RDS instance.
I am trying to create Amazon Aurora with PostgreSQL compatibility, but I am facing: Invalid Storage Type : gp2 error.
SnapshotRDSDBInstance:
...
- 2,975
3
votes
2
answers
2k
views
how to construct a string of physical subnet ids to create db subnet group on the fly in a cloudformation script?
I'm trying to build a CLoudFormation script that launches an instance and a db into a vpc at the same time. the issue is the db requires two AZ's so i create a second subnet and now i just need to ...
- 194
3
votes
1
answer
9k
views
CloudFormation error: "only 1 subschema matches out of 2"
I want to update the stack, get this error message:
Properties validation failed for resource RDSDBinstance with message:
#: #: only 1 subschema matches out of 2 #/DBSubnetGroupName: failed ...
- 6,427
3
votes
2
answers
4k
views
How do I get the hostname of RDS instance into an Environment variable in EC2?
I have a CloudFormation template that creates both RDS and EC2 under the same stack. My problem is, how do I get the RDS hostname into one of my environment variables inside my EC2, without having to ...
user10492117
3
votes
1
answer
4k
views
Create multiple databases in AWS Postgres RDS using Cloudformation
I have a requirement to create multiple databases in Postgres RDS provided by AWS using Cloudformation. I am able to create single database.
Below is snippet of my template :
"pgDB": {
"...
- 597
3
votes
1
answer
4k
views
Updating RDS Engine Version (Minor) via cloudformation - Immediate or during next window?
Currently using AWS RDS PostgreSQL 10.6 and would like to upgrade to 10.9.
We're using Cloudformation templates, and I would like to schedule the upgrade to the next maintenance window, instead of ...
- 700
3
votes
1
answer
875
views
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 ...
- 260
3
votes
2
answers
2k
views
You currently can't modify MaintenanceWindow with Aurora Serverless - error while updating Cloudformation stack
I Have a parameter PreferredMaintenanceWindow setup within AWS::RDS::DBCluster in my cloudformation template and it was all good.
Recently I had to add the parameter EnableCloudwatchLogsExport to the ...
- 1,831
3
votes
1
answer
1k
views
Aws secrets manager
I tried writing a hostedlambdarotation property in AWS cloudformation to rotate my credentials after every X days, but the deployment fails stating the following error -
"Transform AWS::...
- 145
2
votes
1
answer
4k
views
Invalid DB Instance class: db.t2.micro
Why can I not create a database of size db.t2.micro in CloudFormation?
Here is my template:
Resources:
Database:
Type: AWS::RDS::DBInstance
Properties:
AllocatedStorage: 20
...
- 676
2
votes
1
answer
9k
views
AWS: DB Instance quota exceeded
During CloudFormation stack-creation I get a CREATE_FAILED error for Aurora with reason DB Instance quota exceeded.
I assume it means there are too many DB instances running (I'm on a company account ...
- 77.3k
2
votes
2
answers
2k
views
AWS Cloudformation Value of property SubnetIds must be of type List of String
I am tying this cloudformation stack but when creation reaches DBSubnetGroup it fails with the message: Value of property SubnetIds must be of type List of String. I appreciate your help.
All seems ...
2
votes
1
answer
6k
views
How can we create cross region RDS read replica using AWS cloud formation template?
I have easily found a way to create RDS read replica in same region using AWS cloud formation, but:
1. Can we create the same in different region using CF template?
2. Also can we promote it to ...
- 141