30 lines
843 B
HCL
30 lines
843 B
HCL
// db module
|
|
|
|
resource "google_sql_database" "main" {
|
|
name = "main"
|
|
instance = google_sql_database_instance.main_primary.name
|
|
}
|
|
|
|
resource "google_sql_database_instance" "main_primary" {
|
|
name = "main-primary"
|
|
database_version = "POSTGRES_14"
|
|
depends_on = var.db_depends_on
|
|
|
|
settings {
|
|
tier = var.instance_type
|
|
availability_type = "ZONAL" # use "REGIONAL" for prod to distribute data storage across zones
|
|
disk_size = var.disk_size
|
|
|
|
ip_configuration {
|
|
ipv4_enabled = false # don't give the db a public IPv4
|
|
private_network = var.vpc_link # the VPC where the db will be assigned a private IP
|
|
}
|
|
}
|
|
}
|
|
|
|
resource "google_sql_user" "db_user" {
|
|
name = var.user
|
|
instance = google_sql_database_instance.main_primary.name
|
|
password = var.password
|
|
}
|