Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uvbvk-00G8e0-Eh for pgsql-announce@arkaria.postgresql.org; Mon, 08 Sep 2025 13:29:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uvbvj-004j60-L8 for pgsql-announce@arkaria.postgresql.org; Mon, 08 Sep 2025 13:29:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uvbvi-004j5s-P3 for pgsql-announce@lists.postgresql.org; Mon, 08 Sep 2025 13:29:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uvbve-001Cvt-2Q for pgsql-announce@lists.postgresql.org; Mon, 08 Sep 2025 13:29:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=vnKmZijNNfTXHqIm7cWqnnWktdA+u35JXY2N84ulRQs=; b=qEmYA0R+M8MWknu9gSnN9tFs6W F9BDX0mjesonCuSBVn3deOnEWIfR7Efia3E6Pwp+wzFQxiRMZDhmJ9DrlK3OQ0Ss0lTZVmZr0G92s GdrGDN3HlxBDjrjQPeCrjx49flBEdWah36D6DjVNiZdRi+emUbZhQDtV2OuEr37TS8fc6Sxr+v6sI EdSGutU6rAJzxPX0nNqh3hzE57L0E9Uspa1/aX+0sdr7IsZKJJM9Gcd0bnrMDIfCccp8lYhPINkFt jKO07w/EpC983j6f9B3JdtuN8cjkZ/64PXuJJ2RU+9YseM3+Pdy43WglfgT1W75qyb2QIl64FvrH5 4TN+kfIw==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uvbvc-003FET-DJ for pgsql-announce@lists.postgresql.org; Mon, 08 Sep 2025 13:29:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uvbvb-005gSv-1O for pgsql-announce@lists.postgresql.org; Mon, 08 Sep 2025 13:29:03 +0000 Content-Type: multipart/mixed; boundary="===============8666453066195387887==" MIME-Version: 1.0 Subject: SynchDB 1.2 Released - Native Oracle Connector, Enhanced Monitoring & Quick Deployment Tools To: PostgreSQL Announce From: Hornetlabs Technology Inc via PostgreSQL Announce Reply-To: grantzhou@highgo.ca Date: Mon, 08 Sep 2025 13:29:01 +0000 Message-ID: <175733814156.356921.7143028473921324948@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: b54c1fbb1b7b06e71676dc05d76718b317e2893d4c098b08df11574072b638d7 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8666453066195387887== Content-Type: multipart/alternative; boundary="===============5774750432563819894==" MIME-Version: 1.0 --===============5774750432563819894== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable **Release Date: September 4, 2025** We're excited to announce the release of **SynchDB 1.2**! This update intro= duces a native Openlog Replicator connector for Oracle, comprehensive monit= oring capabilities with JMX and Grafana integration, and streamlined deploy= ment tools that make testing and setup significantly easier. SynchDB continues to deliver seamless, native data synchronization from mul= tiple database platforms directly to PostgreSQL without middleware, now wit= h 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 includin= g 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_conn= info` functions * Prometheus and Grafana support via JMX Exporter with dedicated connection= management functions * Pre-built Grafana dashboard templates for MySQL, SQL Server, and Oracle c= onnectors * Comprehensive metrics collection for production monitoring **Simplified Deployment & Testing** * **ezdeploy.sh tool** - One-command deployment script for rapid testing an= d 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 initi= al snapshots in `always` mode * Enhanced event polling performance using direct buffers instead of freque= nt JNI calls * Improved connector isolation - each SynchDB extension now maintains separ= ate 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 sna= pshot control * Connector resume operations now default to `initial` snapshot mode for co= nsistency * `synchdb_state_view` and `synchdb_stats_view` now show only current exten= sion's connectors * Improved memory management and context handling **Fixed Issues** * Resolved crash in `spi_execute_select_one()` related to SPI memory contex= t 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 s= pecified database * Table filtering must be configured in Openlog Replicator rather than Sync= hDB * JMX Exporter is required for Prometheus and Grafana monitoring functional= ity **Resources** * GitHub Repository: [GitHub](https://github.com/Hornetlabs/synchdb) * Documentation: [Document](https://docs.synchdb.com/) * Downloads: **[Release v1.2](https://github.com/Hornetlabs/synchdb/release= s/tag/v1.2)** * Community Discussion: [Join us](https://discord.gg/ce4FGMfwrk) * Issue Reporting: **[GitHub Issues](https://github.com/Hornetlabs/synchdb/= issues)** * Website: **[Hornetlabs Technology](https://hornetlabs.ca/)** **About SynchDB** SynchDB is an open-source PostgreSQL extension developed by Hornetlabs Tech= nology. It enables direct data replication from heterogeneous databases (My= SQL, MS SQL Server, Oracle, etc.) to PostgreSQL with high performance and r= eliability. The extension handles all synchronization needs without requiri= ng middleware or third-party software. We appreciate your continued support and feedback as we work to make SynchD= B 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 --===============5774750432563819894== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable SynchDB 1.2 Released - Native Oracle Connector, Enhanced Monitor= ing & Quick Deployment Tools
 

SynchDB 1.2 Released - Native Oracle Connector, Enhanced Monitoring &= amp; Quick Deployment Tools

Release Date: September 4, 2025

We're excited to announce the release of SynchDB 1.2! This update introduces a native Openlog Replica= tor connector for Oracle, comprehensive monitoring capabilities with JMX an= d Grafana integration, and streamlined deployment tools that make testing a= nd setup significantly easier.

SynchDB continues to deliver seamless, nati= ve data synchronization from multiple database platforms directly to Postgr= eSQL without middleware, now with improved performance and enhanced operati= onal visibility.

Major Enhancements

Native Openlog Replicator Connector= - BETA

  • Native = Oracle streaming - New connector type olr that commun= icates directly with Openlog Replicator services without Debezium dependenc= y
  • Support for ess= ential DMLs (insert, update, delete) and key DDLs including CREATE/DROP TAB= LE, ALTER TABLE operations, and TRUNCATE
  • Built on libpro= tobuf-c for efficient communication and IvorySQL's Oracle parser for DDL pr= ocessing
  • Full snapshot m= ode support (initial, initial_only, no_data, always, never) with batching a= nd offset management

Enhanced Monitoring & Observabi= lity

  • JMX integration= with synchdb_add_jmx_conninfo and synchdb_del_jmx_conni= nfo functions
  • Prometheus and = Grafana support via JMX Exporter with dedicated connection management funct= ions
  • Pre-built Grafa= na dashboard templates for MySQL, SQL Server, and Oracle connectors
  • Comprehensive m= etrics collection for production monitoring

Simplified Deployment & Testing=

  • ezdeplo= y.sh tool - One-command deployment script for rapid testing and de= velopment
  • Supports MySQL,= SQL Server, Oracle (19c and 23ai), and Openlog Replicator 1.3.0 deployment=
  • Automated Prome= theus and Grafana setup with preloaded dashboards
  • Pre-compiled Sy= nchDB v1.2 binaries for immediate testing

Performance & Reliability Impro= vements

  • Selective snaps= hot table functionality - choose specific tables for initial snapshots in <= code>always mode
  • Enhanced event = polling performance using direct buffers instead of frequent JNI calls
  • Improved connec= tor isolation - each SynchDB extension now maintains separate connector dat= a
  • Enhanced pytest= framework with hammerdb-based TPC tests for Oracle

Changes from Previous Version

  • New snaps= hot table parameter in synchdb_add_conninfo for granula= r snapshot control
  • Connector resum= e operations now default to initial snapshot mode for consiste= ncy
  • synchdb_s= tate_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 clea= nup
  • Fixed compilati= on issues when PostgreSQL is built with cassert
  • Corrected share= d 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 extens= ion developed by Hornetlabs Technology. It enables direct data replication = from heterogeneous databases (MySQL, MS SQL Server, Oracle, etc.) to Postgr= eSQL with high performance and reliability. The extension handles all synch= ronization needs without requiring middleware or third-party software.

We appreciate your continued support and fe= edback as we work to make SynchDB the most powerful database synchronizatio= n tool available for PostgreSQL. Your testing, bug reports, and feature req= uests help drive our development priorities.

Sincerely,

The SynchDB Team at Hornetlabs Technology

This email was sent to you from Hornetlabs Technology Inc. It was delivered= on their behalf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to Hornetlabs Technology Inc.

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============5774750432563819894==-- --===============8666453066195387887==--