This page lists the main features of Cloud SQL and indicates which database engines support these features.
The checkmarks in Table 1 contain links to related topics.
Table 1. Cloud SQL features
MySQL | PostgreSQL | SQL Server | ||
---|---|---|---|---|
Data protection
|
Backups | ✓ | ✓ | ✓ |
|
Point-in-time recovery (PITR) | ✓ | ✓ | ✓ |
|
High availability | ✓ | ✓ | ✓ |
|
Cloning | ✓ | ✓ | ✓ |
|
Disaster recovery | ✓ | ✓ | ✓ |
Data migration
|
Data migration to external servers | ✓ | ||
Logs
|
Instance logging | ✓ | ✓ | ✓ |
Planned maintenance
|
Maintenance windows | ✓ | ✓ | ✓ |
|
Maintenance controls | ✓ | ✓ | ✓ |
|
Self service maintenance | ✓ | ✓ | ✓ |
Replication
|
Read replicas | ✓ | ✓ | ✓ |
|
Cross-region read replicas | ✓ | ✓ | ✓ |
|
External read replicas | ✓ | ✓ | ✓ |
|
Binary logging on read replicas | ✓ | ||
|
Replication from an external server | ✓ | ✓ | |
|
Read replica indexes stored procedures | ✓ | ||
|
Logical replication | ✓ | ||
Security
|
Customer-managed encryption keys (CMEK) | ✓ | ✓ | ✓ |
|
Cloud SQL Auth Proxy support | ✓ | ✓ | ✓ |
|
Audit logging | ✓ | ✓ | ✓ |
|
Connection organization policies | ✓ | ✓ | ✓ |
|
IAM database authentication | ✓ | ✓ | |
|
Access Transparency (AXT) | ✓ | ✓ | ✓ |
|
Key Access Justification | ✓ | ✓ | ✓ |
|
Private Service Connect | ✓ | ✓ | ✓ |
|
Cloud Security Command Center Monitoring | ✓ | ✓ | ✓ |
|
Cloud External Key Manager (EKM) | ✓ | ✓ | ✓ |
|
VPC Service Controls | ✓ | ✓ | ✓ |
Insights
|
Query Insights | ✓ | ✓ |