MySQL schema fan-in across multiple databases
MySQL supports unifyAcrossSchemas, which fans in tables matching a regex across multiple databases into one destination topic for snapshots and CDC.
Multi-tenant MySQL setups often have one schema per customer (e.g. tenant_001.orders, tenant_002.orders). Previously this required a separate pipeline per schema.
MySQL now supports unifyAcrossSchemas, which fans in tables matching a regex pattern across multiple databases into a single unified destination topic. This works for both snapshot and streaming (CDC) paths.
Why this matters
- Consolidate multi-tenant or sharded MySQL setups into a single pipeline
- Eliminate per-schema pipeline sprawl in fan-in architectures
- Works end-to-end — snapshot and streaming