Risk Level: Low
Cloud Entity: GCP CloudSql
CloudGuard Rule ID: D9.GCP.AS.10
Covered by Spectral: No
Category: Database

GSL LOGIC

CloudSql should have settings.storageAutoResizeLimit>0

REMEDIATION

From TF
Set 'disk_autoresize_limit' to an integer value:

resource 'google_sql_database_instance' 'EXAMPLE_CLOUDSQL_INSTANCE' {
	...
	settings{
		disk_autoresize_limit = INTEGER_VALUE_OF_GB
	}
	...
}

From Command Line
Set a storage auto increase limit for your CloudSQL instance:

gcloud beta sql instances patch EXAMPLE_CLOUDSQL_INSTANCE --storage-auto-increase-limit=INTEGER_VALUE_OF_GB

References

GCP CloudSql

Cloud SQL is a fully managed database service that makes it easy to set up, maintain, manage, and administer your relational PostgreSQL, MySQL, and SQL Server databases in the cloud.

Compliance Frameworks

CloudGuard GCP All Rules Ruleset