MySQL

Install

cargo install faucet-cli --features source-mysql
faucet init --source mysql

# Cargo.toml — use it as a library
cargo add faucet-source-mysql

Starter config

source:
  type: mysql
  config:
    connection_url: ""    # REQUIRED — MySQL connection URL (e.g.
    query: ""    # REQUIRED — SQL query to execute.
    # max_connections: 10    # Maximum number of connections in the pool.
    # batch_size: 1000    # Records per emitted `StreamPage`.
    # shard: null    # Optional primary-key range sharding for clustered (Mode B) execution.
    # read_timeout_secs: 3600    # Longest the source waits on the server for the next row (or for a whole result in `fetch_all`), in seconds, before the read fails.
    # json_big_numbers: null    # What to do with a number inside a JSON / JSONB column that a 64-bit float cannot hold exactly.
    # net_write_timeout_secs: 3600    # The session's `net_write_timeout`, in seconds: how long the server waits for the source to read more of a result before it aborts the query.
    # replication: { type: full }    # one of: full, incremental
      # --- Alternative variants — replace the block above with one of these ---
      # type: incremental
      # column: ""    # REQUIRED
      # initial_value: null    # REQUIRED
    # state_key: ""    # Explicit state-store key for the incremental bookmark.

Capabilities

Config fields