On-prem MySQL OLTP cluster is heavily loaded; you need to run analytics with minimal impact to operations. What approach should you take?

Using an ETL tool to load MySQL data into Google BigQuery for analytics is the most effective approach. BigQuery is a fully managed, serverless data warehouse designed for large-scale analytics, making it ideal for OLAP workloads without impacting the operational MySQL OLTP cluster. ETL tools automate the data extraction, transformation, and loading process, ensuring data is prepared for BigQuery. Adding a node to the MySQL cluster for OLAP would still put analytical load on the transactional database, potentially impacting performance. Connecting an on-premises Hadoop cluster adds complexity and doesn't leverage Google Cloud's managed services. Mounting nightly mysqldump backups to Cloud SQL and processing with Cloud Dataproc introduces latency and complexity compared to a direct ETL to BigQuery.