Cloud SQL
SmartSRE provides performance optimization and high availability for Google Cloud SQL.
What SmartSRE Scans
| Category | Checks |
|---|---|
| Performance | Connection count, CPU/memory utilization |
| Availability | HA configuration, maintenance windows |
| Security | SSL enforcement, authorized networks |
| Storage | Disk utilization, auto-increase settings |
Findings
| Issue Type | Severity | Description |
|---|---|---|
high_connection_count | High | Connections approaching limit |
no_ha | Medium | Single-zone instance |
disk_usage_high | High | Storage > 85% utilized |
no_ssl | Critical | Unencrypted connections allowed |
no_auto_storage_increase | Medium | Auto-increase disabled |
Available Fixes
| Operation | Description | Impact |
|---|---|---|
enable_ha | Enable high availability | Medium |
enable_ssl | Require SSL connections | Medium |
resize_storage | Increase disk size | Low |
enable_auto_storage_increase | Enable auto-increase | Low |
Required Permissions
For Scanning
roles/cloudsql.client
roles/monitoring.viewer
For Remediation
roles/cloudsql.admin
Best Practices
- Enable SSL — Encrypt all database connections
- Configure HA — Automatic failover for production
- Enable auto-storage — Prevent disk full scenarios
- Monitor connections — Set up alerting before limits are hit