Database CDC
Planasonix supports CDC for common relational engines. Exact prerequisites (binary logging, supplemental logging, permissions) appear in each connector’s setup wizard.PostgreSQL
PostgreSQL
Use logical decoding (for example,
pgoutput or plugin-based slots) with replication permissions. Monitor replication slot lag on the database to avoid disk growth from idle consumers.MySQL
MySQL
Enable row-based binary logging and grant replication client privileges. Large wide tables benefit from careful primary key design to keep event size predictable.
SQL Server
SQL Server
Use change tracking or CDC features as supported by the connector; ensure agents can read from the capture instance without blocking OLTP workloads.
Oracle
Oracle
Configure LogMiner or vendor-recommended equivalents per connector docs; archive log retention must exceed your worst-case consumer downtime.
MongoDB
MongoDB
Capture change streams on collections you authorize; consider resume tokens and schema evolution when documents are polymorphic.
Event buses and cloud streaming
In addition to database CDC, you can ingest from high-throughput buses and managed streaming services:| Platform | Typical use |
|---|---|
| Apache Kafka | Durable topics from microservices or CDC Debezium connectors |
| Amazon Kinesis | AWS-native streaming with shard-based scaling |
| Apache Pulsar | Multi-tenant messaging with geo replication |
| Google Cloud Pub/Sub | Asynchronous work queues and GCP-native events |
| Azure Event Hubs | Kafka-compatible endpoints on Azure |
| NATS | Lightweight messaging for edge and internal services |
| Vendor webhooks | HTTPS push endpoints normalized into an internal stream |
- Kafka and compatible
- Cloud-managed
- Webhooks
Configure bootstrap servers, SASL/SSL, consumer groups, and topic patterns. Set partition-aware parallelism only when your downstream processing is associative per key.
Operational checklist
Rightsize retention
Ensure broker and database retention cover maintenance windows plus worst-case recovery time.
Schema strategy
Define how additive schema changes propagate; use parsers and data contracts where you enforce compatibility.
Related topics
Stream processing
Windows and transforms on live data.
Observability
Metrics and alerts for streaming health.