QuestionQ66

VerifiedDeploy scalable and highly available databases in Google Cloud

Your company is migrating one of its monolithic applications to a microservices architecture on Google Cloud. The new architecture includes a user authentication service running on Google Kubernetes Engine (GKE) that must access Cloud SQL for PostgreSQL instances. Your developers also require database access for local development and debugging.

You need to design a centralized, secure, and scalable database connectivity and access-management strategy for both application service interfaces and developers. What should you do?

Explanation

Cloud SQL IAM database authentication centralizes user and service identity management in IAM and uses short-lived access tokens rather than static database passwords. The Cloud SQL Auth Proxy supports automatic IAM database authentication and provides encrypted, IAM-authorized connections. Dedicated least-privilege service accounts accessed through GKE Workload Identity avoid distributing long-lived credentials to workloads, while developers can use their individual IAM identities with the proxy for secure access.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!