IaC Bazaar
Browse modules
Menu
Google CloudLive-testedattested

Cloud SQL (PostgreSQL/MySQL) HA Instance

Regional-HA Cloud SQL with private IP (PSA/PSC), automated backups, PITR, read replicas and IAM database auth.

terraformGoogle Cloudgcp

Compare Managed Relational Database across clouds →

Part of: GCP Production Landing Zone, GCP Kubernetes Platform

gcp-cloud-sqlvizier v1.2.0

Verification

Live-tested

Really deployed to a cloud sandbox, verified against its outputs and assertions, then destroyed - with the teardown confirmed.

Conformance

  • Static validation (fmt · validate · tflint)
  • Security scan clean (Checkov)
  • Plan tests (mocked: validation rules · outputs)

Provenance

Functional

  • Live-tested - applied, verified, destroyed

Last verified 2026-06-30 · how we verify

Verify this download

cosign · sha-256

Don't take our word for it. Every release is signed with cosign - check the bytes against our pinned public key before you trust them.

# 1. Our pinned public key - fetch once, trust out-of-band
curl -O https://www.iac-bazaar.com/cosign.pub

# 2. This module's Sigstore bundle
curl -o gcp-cloud-sql-1.0.0.sigstore.json \
  https://www.iac-bazaar.com/api/artifacts/gcp-cloud-sql/signature

# 3. Verify the tarball you downloaded
cosign verify-blob \
  --key cosign.pub \
  --bundle gcp-cloud-sql-1.0.0.sigstore.json \
  gcp-cloud-sql-1.0.0.tar.gz
# → Verified OK

# 4. (optional) confirm the checksum too
echo "717f41b9135caebbb22b0839a0a82bdea2fd0d62586982a41fabc1a5e7b9044a  gcp-cloud-sql-1.0.0.tar.gz" | sha256sum -c
Signature bundlePublic keyMachine-readable receiptHow we verify

Use it from the registry

terraform · opentofu
module "cloud_sql" {
  source  = "www.iac-bazaar.com/iac-bazaar/gcp-cloud-sql/gcp"
  version = "1.0.0"
}

Needs a registry token from /account/tokens. The module itself is free; the account is what identifies you. Full setup: registry docs.

Cite it in your README

badge · attribution

Paste this beside the module in the repository that uses it. The badge is rendered from this artifact's verification record, so it reads live-tested because the record says so, and the link lands on this page.

README.md, GitLab, Gitea
[![IaC Bazaar: live-tested](https://www.iac-bazaar.com/api/artifacts/gcp-cloud-sql/badge)](https://www.iac-bazaar.com/catalog/gcp-cloud-sql?utm_source=syndication&utm_medium=readme&utm_campaign=artifact)

Terraform module 1.0.0, live-tested on IaC Bazaar: [Cloud SQL (PostgreSQL/MySQL) HA Instance](https://www.iac-bazaar.com/catalog/gcp-cloud-sql?utm_source=syndication&utm_medium=readme&utm_campaign=artifact)

```hcl
module "cloud_sql" {
  source  = "www.iac-bazaar.com/iac-bazaar/gcp-cloud-sql/gcp"
  version = "1.0.0"
}
```

Preview:IaC Bazaar: live-tested

Inputs & outputs

Create a free account to read this module's contract

The declared contract - every input name, type, default and description, plus every output - is shown to signed-in accounts, not to anonymous visitors.

A free account sees the contract of every module in the catalogue. There is no subscription and nothing to buy - the modules are free to download, and they run under Vizier.

Create a free account →Sign in

Documentation

gcp-cloud-sql

Regional-HA Cloud SQL (PostgreSQL/MySQL) with private IP via Private Service Access, automated backups, point-in-time recovery, read replicas and IAM database auth — the PSA networking footgun solved for you. Works with Terraform and OpenTofu (>= 1.6), Google provider >= 7.0, < 8.0.

Secure defaults:

  • No public IP (ipv4_enabled = false); private IP through a PSA peering the module can create for you (reserved range + servicenetworking connection)
  • TLS-only client connections (ssl_mode = "ENCRYPTED_ONLY")
  • deletion_protection = true
  • Regional HA (availability_type = "REGIONAL"), daily backups + PITR (engine-aware: WAL on PostgreSQL, binlog on MySQL)
  • IAM database authentication on, with the engine-correct flag spelling
  • On PostgreSQL, the four low-cost CIS-recommended log flags default to on (log_checkpoints, log_connections, log_disconnections, log_lock_waits); your database_flags entries override them

Requirements

  • Terraform or OpenTofu >= 1.6
  • hashicorp/google >= 7.0, < 8.0
  • APIs: sqladmin.googleapis.com, plus servicenetworking.googleapis.com and compute.googleapis.com when using private IP

Upgrade note (1.0.x)

  • create_private_service_access now defaults to false and must be set explicitly for private-IP deployments. The old default (true behind a private_network != null test) made the resource count depend on an apply-time value, which broke any composition that creates the VPC and the instance in one apply (e.g. the GCP landing-zone stack). If you set private_network and relied on the implicit PSA creation, add create_private_service_access = true.
  • PostgreSQL instances now get four low-cost CIS-recommended log flags by default (log_checkpoints, log_connections, log_disconnections, log_lock_waits). Database flag changes restart the instance; override any of them explicitly via database_flags (buyer entries win the merge).

License

Commercial — IaC Bazaar EULA. © IaC Bazaar. Original work (not derived from a third-party module).

Usage code & full reference need an account

The complete copy-paste usage, the full input/output reference, and operational notes are free with an account - shown here and bundled in the download. Sign in and this section fills in.

  • Usage
  • Inputs
  • Outputs
  • Notes
Create a free accountSign in

Related modules

Static validatedLive test pending

gcp-datastream

A stream is created NOT_STARTED and replicates nothing until somebody starts it; the source password is a literal in state unless it is a Secret Manager reference; public connectivity means the database admits Google's published ranges; and backfill_none is change capture with no history. Running from apply, private connection peered into your VPC, secret required, backfill on.

View module
Static validatedLive test pending

gcp-firestore

Type, location and CMEK cannot be changed after creation - getting one wrong means exporting every document into a new database and repointing every client. delete_protection defaults OFF, and Firestore has no snapshots: point-in-time recovery is the only way back and only covers incidents after it was enabled.

View module
Static validatedLive test pending

gcp-looker

A Looker (Google Cloud core) instance reachable over Private Service Connect from the VPCs you allow, no public address, sign-in limited to your email domains, encrypted with your Cloud KMS key, in a maintenance window you chose. The OAuth client secret is sensitive and never output; the edition has no default because the annual editions commit for a year.

View module
Live-tested

gcp-alloydb

AlloyDB cluster with primary + read-pool instances, PSC connectivity, automated backups and columnar/vector engine flags.

View module
Live-tested

gcp-bigquery-dataset

Datasets with partitioned/clustered tables, authorized views, CMEK and dataset-level access controls.

View module
Live-tested

gcp-bigtable

A single-cluster Cloud Bigtable instance (one 1-node SSD cluster, the smallest footprint) plus a table with column families, IAM-only access, optional CMEK, and deletion protection on.

View module