SynchDB 1.2 Released - Native Oracle Connector, Enhanced Monitoring & Quick Deployment Tools
Posted on 2025-09-08 by Hornetlabs Technology Inc
Related Open Source
Release Date: September 4, 2025
We're excited to announce the release of SynchDB 1.2! This update introduces a native Openlog Replicator connector for Oracle, comprehensive monitoring capabilities with JMX and Grafana integration, and streamlined deployment tools that make testing and setup significantly easier.
SynchDB continues to deliver seamless, native data synchronization from multiple database platforms directly to PostgreSQL without middleware, now with improved performance and enhanced operational visibility.
Major Enhancements
Native Openlog Replicator Connector - BETA
- Native Oracle streaming - New connector type
olr that communicates directly with Openlog Replicator services without Debezium dependency
- Support for essential DMLs (insert, update, delete) and key DDLs including CREATE/DROP TABLE, ALTER TABLE operations, and TRUNCATE
- Built on libprotobuf-c for efficient communication and IvorySQL's Oracle parser for DDL processing
- Full snapshot mode support (initial, initial_only, no_data, always, never) with batching and offset management
Enhanced Monitoring & Observability
- JMX integration with
synchdb_add_jmx_conninfo and synchdb_del_jmx_conninfo functions
- Prometheus and Grafana support via JMX Exporter with dedicated connection management functions
- Pre-built Grafana dashboard templates for MySQL, SQL Server, and Oracle connectors
- Comprehensive metrics collection for production monitoring
Simplified Deployment & Testing
- ezdeploy.sh tool - One-command deployment script for rapid testing and development
- Supports MySQL, SQL Server, Oracle (19c and 23ai), and Openlog Replicator 1.3.0 deployment
- Automated Prometheus and Grafana setup with preloaded dashboards
- Pre-compiled SynchDB v1.2 binaries for immediate testing
Performance & Reliability Improvements
- Selective snapshot table functionality - choose specific tables for initial snapshots in
always mode
- Enhanced event polling performance using direct buffers instead of frequent JNI calls
- Improved connector isolation - each SynchDB extension now maintains separate connector data
- Enhanced pytest framework with hammerdb-based TPC tests for Oracle
Changes from Previous Version
- New
snapshot table parameter in synchdb_add_conninfo for granular snapshot control
- Connector resume operations now default to
initial snapshot mode for consistency
synchdb_state_view and synchdb_stats_view now show only current extension's connectors- Improved memory management and context handling
Fixed Issues
- Resolved crash in
spi_execute_select_one() related to SPI memory context cleanup
- Fixed compilation issues when PostgreSQL is built with cassert
- Corrected shared memory conflicts between connectors with identical names across databases
Known Issues and Notes
- Native Openlog Replicator Connector currently streams all tables in the specified database
- Table filtering must be configured in Openlog Replicator rather than SynchDB
- JMX Exporter is required for Prometheus and Grafana monitoring functionality
Resources
About SynchDB
SynchDB is an open-source PostgreSQL extension developed by Hornetlabs Technology. It enables direct data replication from heterogeneous databases (MySQL, MS SQL Server, Oracle, etc.) to PostgreSQL with high performance and reliability. The extension handles all synchronization needs without requiring middleware or third-party software.
We appreciate your continued support and feedback as we work to make SynchDB the most powerful database synchronization tool available for PostgreSQL. Your testing, bug reports, and feature requests help drive our development priorities.
Sincerely,
The SynchDB Team at Hornetlabs Technology