generated from ariga/atlas-template
/
main.tf
102 lines (87 loc) · 2.46 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
terraform {
required_providers {
aws = {
source = "hashicorp/aws"
version = "5.7.0"
}
atlas = {
source = "ariga/atlas"
version = "0.5.4"
}
}
}
provider "atlas" {
dev_url = "docker://mysql/8/myapp"
}
// Fetch the list of availability zones from the current region.
data "aws_availability_zones" "available" {
state = "available"
}
// Provision a VPC and subnets in these AZs.
module "vpc" {
source = "terraform-aws-modules/vpc/aws"
version = "5.0.0"
name = "atlas-rds-demo"
cidr = "10.0.0.0/16"
azs = data.aws_availability_zones.available.names
public_subnets = ["10.0.4.0/24", "10.0.5.0/24", "10.0.6.0/24"]
enable_dns_hostnames = true
enable_dns_support = true
}
// Create a DB subnet to provision the database.
resource "aws_db_subnet_group" "atlas" {
name = "atlas-rds-demo"
subnet_ids = module.vpc.public_subnets
tags = {
Name = "Demo"
}
}
// Generate a random password for our db user.
resource "random_password" "password" {
length = 16
special = true
}
// Security group which allows *public access* to our database.
// DO NOT use this in production.
resource "aws_security_group" "rds" {
name = "atlas-demo"
vpc_id = module.vpc.vpc_id
ingress {
from_port = 3306
to_port = 3306
protocol = "tcp"
cidr_blocks = ["0.0.0.0/0"]
}
egress {
from_port = 3306
to_port = 3306
protocol = "tcp"
cidr_blocks = ["0.0.0.0/0"]
}
tags = {
Name = "atlas"
}
}
// Our RDS-based MySQL 8 instance.
resource "aws_db_instance" "atlas-demo" {
identifier = "atlas-demo"
instance_class = "db.t3.micro"
allocated_storage = 5
engine = "mysql"
engine_version = "8.0.28"
username = "atlas"
password = random_password.password.result
db_subnet_group_name = aws_db_subnet_group.atlas.name
vpc_security_group_ids = [aws_security_group.rds.id]
parameter_group_name = "default.mysql8.0"
publicly_accessible = true
skip_final_snapshot = true
}
data "atlas_schema" "app" {
src = "file://${path.module}/../schema.hcl"
}
// Apply the normalized schema to the RDS-managed database.
resource "atlas_schema" "hello" {
hcl = data.atlas_schema.app.hcl
url = "mysql://${aws_db_instance.atlas-demo.username}:${urlencode(random_password.password.result)}@${aws_db_instance.atlas-demo.endpoint}/"
}