QuestionQ136

VerifiedPlanning and implementing a cloud solution

You are planning to migrate the following on-premises data management solutions to Google Cloud:

• One MySQL cluster for your main database

• Apache Kafka for your event streaming platform

• One PostgreSQL database for your analytical and reporting needs

You want to implement Google-recommended solutions for the migration. You need to ensure that the new solutions provide global scalability and require minimal operational and infrastructure management. What should you do?

Explanation

For global scalability and minimal management, Spanner is the only viable option for the MySQL workload—Cloud SQL is single-region and lacks horizontal scale, while Spanner multi-region configurations replicate databases across multiple regions with strong consistency. Pub/Sub replaces Kafka for event streaming, combining the horizontal scalability of Apache Kafka with messaging features such as dead-letter queues and filtering. BigQuery serves analytics and reporting as a fully managed, serverless data platform with no resources to provision or scale manually. This architecture meets both scalability and operational simplicity requirements.

Learn more

Community Discussion

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