-
Notifications
You must be signed in to change notification settings - Fork 0
/
rds.yml
127 lines (117 loc) · 3.46 KB
/
rds.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
AWSTemplateFormatVersion: 2010-09-09
Description: RDS template
Parameters:
PrivateSubnet1Id:
Type: String
PrivateSubnet2Id:
Type: String
RdsMasterUserSecretArn:
Type: String
RdsDatabaseName:
Type: String
DBClusterSecurityGroupId:
Type: String
RdsProxySecurityGroupId:
Type: String
RdsMasterUsername:
Type: String
Resources:
DBClusterSubnetGroup:
Type: AWS::RDS::DBSubnetGroup
Properties:
DBSubnetGroupDescription: for DB Cluster
SubnetIds:
- !Ref PrivateSubnet1Id
- !Ref PrivateSubnet2Id
DBClusterParameterGroup:
Type: AWS::RDS::DBClusterParameterGroup
Properties:
Family: aurora-mysql5.7
Description: DB Cluster Parameter Group
Parameters:
character_set_client: utf8mb4
character_set_connection: utf8mb4
character_set_database: utf8mb4
character_set_results: utf8mb4
character_set_server: utf8mb4
collation_connection: utf8mb4_general_ci
DBCluster:
Type: AWS::RDS::DBCluster
Properties:
MasterUsername: !Sub '{{resolve:secretsmanager:${RdsMasterUserSecretArn}:SecretString:username}}'
MasterUserPassword: !Sub '{{resolve:secretsmanager:${RdsMasterUserSecretArn}:SecretString:password}}'
Engine: aurora-mysql
EngineVersion: 5.7.mysql_aurora.2.10.1
DatabaseName: !Ref RdsDatabaseName
DBSubnetGroupName: !Ref DBClusterSubnetGroup
VpcSecurityGroupIds:
- !Ref DBClusterSecurityGroupId
DBClusterParameterGroupName: !Ref DBClusterParameterGroup
DBInstance:
Type: AWS::RDS::DBInstance
DependsOn: DBCluster
Properties:
DBClusterIdentifier: !Ref DBCluster
DBSubnetGroupName: !Ref DBClusterSubnetGroup
Engine: aurora-mysql
DBInstanceClass: db.t3.small
DBClusterAttachment:
Type: AWS::SecretsManager::SecretTargetAttachment
DependsOn: DBCluster
Properties:
SecretId: !Ref RdsMasterUserSecretArn
TargetId: !Ref DBCluster
TargetType: AWS::RDS::DBCluster
RdsProxy:
Type: AWS::RDS::DBProxy
Properties:
DBProxyName: todo-rds-proxy-for-db-cluster
EngineFamily: MYSQL
RequireTLS: true
RoleArn: !GetAtt RdsProxyRole.Arn
Auth:
- AuthScheme: SECRETS
SecretArn: !Ref RdsMasterUserSecretArn
IAMAuth: REQUIRED
VpcSecurityGroupIds:
- !Ref RdsProxySecurityGroupId
VpcSubnetIds:
- !Ref PrivateSubnet1Id
- !Ref PrivateSubnet2Id
RdsProxyTargetGroup:
Type: AWS::RDS::DBProxyTargetGroup
DependsOn:
- DBCluster
- DBInstance
Properties:
DBProxyName: !Ref RdsProxy
DBClusterIdentifiers:
- !Ref DBCluster
TargetGroupName: default
RdsProxyRole:
Type: AWS::IAM::Role
Properties:
AssumeRolePolicyDocument:
Version: 2012-10-17
Statement:
- Effect: Allow
Principal:
Service: rds.amazonaws.com
Action: sts:AssumeRole
Policies:
- PolicyName: AllowGetSecretValue
PolicyDocument:
Version: 2012-10-17
Statement:
- Effect: Allow
Action:
- secretsmanager:GetSecretValue
- secretsmanager:DescribeSecret
Resource:
- !Ref DBClusterAttachment
- !Ref RdsMasterUserSecretArn
Outputs:
RdsProxyEndpoint:
Value: !GetAtt RdsProxy.Endpoint
RdsProxyArn:
Value: !GetAtt RdsProxy.DBProxyArn