Bucardo vs Debezium

Bucardo is a free, open-source system for asynchronous PostgreSQL replication in multi-source and multi-target arrangements. It supports multi-way synchronization and one-direction master-standby replication. Users define named syncs that copy selected tables between a server and other servers. A Perl daemon listens for NOTIFY requests and connects to remote databases to copy data. Multi-source setups can use a standard conflict handler or a custom handler assigned per table. Configuration and replication databases require PostgreSQL 8.1 or later, while the configuration database also needs PL/pgSQL and PL/PerlU. The daemon needs a Unix-like operating system, is tested mainly on Linux and macOS, and does not run natively on Windows. Installation is available from source, RPM or Debian packages, and FreeBSD Ports. Bucardo does not replicate DDL or schema changes. The listed latest release is 5.6.0.

Debezium captures row-level database changes and delivers them to applications as events, so they can respond to inserts, updates, and deletes. Its connectors use database logs for low-delay capture without requiring changes to the data model, and can take initial or incremental snapshots, filter schemas, tables, and columns, and mask selected values. Listed databases include MongoDB, MariaDB, MySQL, PostgreSQL, SQL Server, Oracle, Db2, and Cassandra. Connectors for Vitess, Spanner, Informix, CockroachDB, YashanDB, Ingres, and Milvus are marked incubating and may change without backward compatibility. A common deployment uses Apache Kafka Connect; Debezium can also run through Debezium Server or as a library in JVM applications. Debezium Server can send serialized events to Amazon Kinesis, Google Cloud Pub/Sub, and Apache Pulsar. Ready-to-use transformations support routing, filtering, and event flattening. Debezium is free under the Apache Software License 2.0. Its quay.io container images are for testing and evaluation, not production.