SynchDB 1.4 Released - Oracle Container Database Support and TLS-Secured FDW Snapshots
Dear Community Members, We are excited to announce the release of SynchDB 1.4, a PostgreSQL extension for real-time replication from heterogeneous source databases into PostgreSQL/IvorySQL.
This release extends Oracle Container Database support to every Oracle replication path, allows snapshot connections to be encrypted, and improves stability under sustained replication load.
What's New in SynchDB 1.4: Oracle Container Database (CDB/PDB) Support: SynchDB can now replicate from Oracle deployments that use the Container Database architecture, across all three of its Oracle paths: change data capture through the embedded Debezium engine, initial snapshots through oracle_fdw, and log-based replication through Openlog Replicator (OLR). Specify the source database in CDB/PDB format (e.g.
FREE/FREEPDB1) when creating a connector, and SynchDB connects to the corresponding PDB service automatically. This path is tested against Oracle 23ai.
Oracle Container Database (CDB/PDB) Support: SynchDB can now replicate from Oracle deployments that use the Container Database architecture, across all three of its Oracle paths: change data capture through the embedded Debezium engine, initial snapshots through oracle_fdw, and log-based replication through Openlog Replicator (OLR). Specify the source database in CDB/PDB format (e.g.
FREE/FREEPDB1) when creating a connector, and SynchDB connects to the corresponding PDB service automatically. This path is tested against Oracle 23ai.
TLS and Oracle Wallet Secure Connections: Initial snapshots taken through foreign data wrappers can now run over secured connections — TLS for MySQL and PostgreSQL sources, and Oracle Wallet for Oracle and OLR sources — configured through the new synchdb_add_fdw_conninfo() function. Previously these snapshot connections could not be secured.
TLS and Oracle Wallet Secure Connections: Initial snapshots taken through foreign data wrappers can now run over secured connections — TLS for MySQL and PostgreSQL sources, and Oracle Wallet for Oracle and OLR sources — configured through the new synchdb_add_fdw_conninfo() function. Previously these snapshot connections could not be secured.
Runtime-Adjustable Debezium Log Level: The log level of a running connector's Debezium engine can now be changed with synchdb_set_dbz_loglevel(). Diagnosing a misbehaving connector no longer requires restarting it, which previously meant losing the very state you were trying to observe.
Runtime-Adjustable Debezium Log Level: The log level of a running connector's Debezium engine can now be changed with synchdb_set_dbz_loglevel(). Diagnosing a misbehaving connector no longer requires restarting it, which previously meant losing the very state you were trying to observe. Debezium Engine Upgrade: The embedded Debezium engine moves from 2.6.2.
Final to 3.5.2. Final, along with Kafka Connect, Jackson, and Log4j2. This brings SynchDB's source-database connectors in line with current upstream Debezium, including its accumulated connector fixes and dependency security updates. Debezium Engine Upgrade: The embedded Debezium engine moves from 2.6.2.
Final to 3.5.2. Final, along with Kafka Connect, Jackson, and Log4j2. This brings SynchDB's source-database connectors in line with current upstream Debezium, including its accumulated connector fixes and dependency security updates.
Stability Improvements: Fixed crashes that could occur under sustained replication load, a crash in the data format converter, and a startup failure that happened when SynchDB's Oracle log parser was loaded alongside IvorySQL's built-in Oracle parser. Connectors are also now auto-started in every database, rather than only in the default postgres database.
Stability Improvements: Fixed crashes that could occur under sustained replication load, a crash in the data format converter, and a startup failure that happened when SynchDB's Oracle log parser was loaded alongside IvorySQL's built-in Oracle parser. Connectors are also now auto-started in every database, rather than only in the default postgres database.
For a detailed list of all changes, please visit our release notes at https://github.com/Hornetlabs/synchdb/releases/tag/v1.4 Acknowledgments and Contributions: Thank you to all our users who contributed patches, reported bugs, and proposed new features. SynchDB thrives on community contributions. We warmly welcome your ideas, feature requests, or patches.
Please share your contributions on our GitHub page. Source Code: https://github.com/Hornetlabs/synchdb Useful Links: Documentation Documentation Support: Report issues on GitHub Support: Report issues on GitHub We look forward to your feedback on SynchDB 1.4 and your continued support in making SynchDB even better.
Best regards, SynchDB Dev Team About SynchDB SynchDB is a PostgreSQL extension that enables real-time data synchronization from heterogeneous databases including Oracle, MySQL, SQL Server, and PostgreSQL into PostgreSQL/IvorySQL. It provides both initial snapshot and CDC (Change Data Capture) capabilities, making it an efficient solution for database migration and real-time data integration.