> ## Documentation Index
> Fetch the complete documentation index at: https://docs.zwiron.com/llms.txt
> Use this file to discover all available pages before exploring further.

# MySQL CDC to BigQuery

> Stream MySQL binlog CDC into Google BigQuery with Zwiron — real-time warehouse updates without custom ETL jobs.

Land MySQL changes in BigQuery without babysitting export jobs. Zwiron uses **binlog CDC** (or incremental / full refresh) to keep analytics tables fresh, then catalogs and quality-checks after each run.

## What you need

* A Zwiron account — [start free trial](https://zwiron.com/login?mode=signup)
* MySQL with binlog CDC prerequisites (see [MySQL connector](/connectors/databases/mysql))
* A Google BigQuery project and destination credentials (see [BigQuery connector](/connectors/warehouses/bigquery))
* [Hosted](/concepts/execution-modes) or [Agent](/getting-started/install-agent) execution mode

## Steps

### 1. Pick execution mode

Use **Hosted** when MySQL and BigQuery are reachable from the internet (allowlist [egress IPs](/concepts/network-access) if required). Use an **agent** when MySQL sits in a private network — [when to use the agent](/guides/when-to-use-agent).

### 2. Connect MySQL and BigQuery

1. [Create a Connection](/getting-started/create-connection) for **MySQL**.
2. Create a Connection for **BigQuery**.
3. Test both connections.

### 3. Build the pipeline

1. Create a job: **MySQL → BigQuery** ([first pipeline guide](/getting-started/first-pipeline)).
2. Select tables.
3. Prefer **CDC** for continuous updates; otherwise Incremental or Full Refresh ([sync modes](/concepts/sync-modes), [CDC](/concepts/cdc)).

### 4. Schedule, monitor, verify

Set a [schedule](/concepts/scheduling), monitor the run, then use [catalog](/platform/catalog) and [data quality](/platform/data-quality) so dashboards stay trustworthy.

## Related

* Marketing page: [MySQL → BigQuery on zwiron.com](https://zwiron.com/integrations/mysql-bigquery)
* [MySQL connector](/connectors/databases/mysql)
* [BigQuery connector](/connectors/warehouses/bigquery)
* [Catalog & quality after sync](/guides/catalog-and-quality-after-sync)