QuestionQ81

VerifiedDesign scalable and highly available cloud database solutions

Your company uses Cloud SQL for MySQL with an internal (private) IP address and needs to replicate some tables to BigQuery in near real time for analytics and machine learning. You must ensure that replication is fast, reliable, and uses Google-managed services. What should you do?

Explanation

Datastream provides managed, low-latency change data capture for MySQL and supports private connectivity to a source database using its internal IP address. Integrating Datastream with a Dataflow pipeline captures ongoing changes and loads them into BigQuery for near-real-time analytics workloads.

Learn more

Community Discussion

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