BARRYBARRY
Documentation

MySQL

MySQL as a source, with binlog change capture.

MySQL as a relational source or sink for BARRY.

Capabilities: Source · Sink

What it does

Reads tables and queries from MySQL and can also write into it. As a source it runs client-placed for an on-prem database, or cloud-direct where the database is reachable from the cloud.

Configuration

  • Host and port (3306 by default)
  • Database
  • User / password
  • SSL mode

Load strategies

  • Full load — reads the whole table or query each run.
  • Incremental (watermark) — reads only rows past a high-water mark you nominate, such as an id or a modified-timestamp column.
  • Binlog change data capture (experimental) — reads the binary log using GTIDs or file positions, so inserts, updates and deletes stream as small batches without rescanning the table. Requires the binary log enabled in row format.

Notes

Point the connection at a least-privilege account; extraction is read-only and never writes back to the source.

See also Connections, Transports.