-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmain.tf
124 lines (117 loc) · 4.11 KB
/
main.tf
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
locals {
mysql_port = 3306
}
resource "aws_db_subnet_group" "comet-ml-rds-subnet" {
name = "cometml-rds-sgn-${var.environment}"
subnet_ids = var.rds_private_subnets
tags = merge(
var.common_tags,
{
Name = "cometml-rds-sng-${var.environment}"
}
)
}
resource "aws_rds_cluster_instance" "comet-ml-rds-mysql" {
count = var.rds_instance_count
identifier = "cometml-rds-${var.environment}-${count.index}"
cluster_identifier = aws_rds_cluster.cometml-db-cluster.id
instance_class = var.rds_instance_type
engine = var.rds_engine
engine_version = var.rds_engine_version
}
resource "aws_rds_cluster" "cometml-db-cluster" {
cluster_identifier = "cometml-rds-cluster-${var.environment}"
db_subnet_group_name = aws_db_subnet_group.comet-ml-rds-subnet.name
availability_zones = var.availability_zones
database_name = var.rds_database_name
storage_encrypted = var.rds_storage_encrypted
iam_database_authentication_enabled = var.rds_iam_db_auth
master_username = "root"
master_password = var.rds_root_password
engine = var.rds_engine
engine_version = var.rds_engine_version
backup_retention_period = var.rds_backup_retention_period
final_snapshot_identifier = "cometml-rds-backup-${var.environment}-${formatdate("DD-MMM-YYYY-hh-mm-ss", timestamp())}"
preferred_backup_window = var.rds_preferred_backup_window
vpc_security_group_ids = [aws_security_group.mysql_sg.id]
db_cluster_parameter_group_name = aws_rds_cluster_parameter_group.cometml-cluster-pg.name
db_instance_parameter_group_name = aws_rds_cluster_parameter_group.cometml-cluster-pg.name
allow_major_version_upgrade = true
}
resource "aws_rds_cluster_parameter_group" "cometml-cluster-pg" {
name = "cometml-rds-cluster-pg-${var.environment}"
family = "aurora-mysql${var.rds_engine_version}"
description = "CometML RDS cluster parameter group"
parameter {
apply_method = "pending-reboot"
name = "character_set_server"
value = "utf8mb4"
}
parameter {
apply_method = "pending-reboot"
name = "character_set_connection"
value = "utf8mb4"
}
parameter {
apply_method = "pending-reboot"
name = "character_set_database"
value = "utf8mb4"
}
parameter {
apply_method = "pending-reboot"
name = "character_set_results"
value = "utf8mb4"
}
parameter {
apply_method = "pending-reboot"
name = "collation_connection"
value = "utf8mb4_unicode_ci"
}
parameter {
apply_method = "pending-reboot"
name = "collation_server"
value = "utf8mb4_unicode_ci"
}
parameter {
apply_method = "pending-reboot"
name = "innodb_flush_log_at_trx_commit"
value = "1"
}
parameter {
apply_method = "pending-reboot"
name = "innodb_lock_wait_timeout"
value = "120"
}
parameter {
apply_method = "pending-reboot"
name = "max_allowed_packet"
value = "157286400"
}
parameter {
apply_method = "pending-reboot"
name = "thread_stack"
value = "6291456"
}
parameter {
apply_method = "pending-reboot"
name = "group_concat_max_len"
value = "1000000"
}
parameter {
apply_method = "pending-reboot"
name = "log_bin_trust_function_creators"
value = "1"
}
}
resource "aws_security_group" "mysql_sg" {
name = "${var.environment}_mysql_sg"
description = "CometML RDS cluster security group"
vpc_id = var.vpc_id
}
resource "aws_vpc_security_group_ingress_rule" "mysql_port_inbound_ec2" {
security_group_id = aws_security_group.mysql_sg.id
from_port = local.mysql_port
to_port = local.mysql_port
ip_protocol = "tcp"
referenced_security_group_id = var.rds_allow_from_sg
}