System Design Codex714 phútAI
Monolith to Service Architecture
Di chuyển từ kiến trúc monolith sang microservices cần áp dụng các pattern cụ thể thay vì …
Đang tải bảng tin…
Chủ đề
#change-data-capture
Tin lập trình mới nhất về change-data-capture, tóm tắt tiếng Việt bằng AI.
DBconvert018 phút
Migrate MySQL to PostgreSQL: Data Types & SQL Rewrites
A practical walkthrough for migrating from MySQL to PostgreSQL, covering the full process: schema assessment, data type mapping (AUTO_INCREMENT, ENUM, unsigned integers, zero dates), SQL dialect rewrites (backticks, LIMIT syntax, IFNULL, GROUP_CONCAT, ON DUPLICATE KEY), stored procedure porting to PL/pgSQL, validation strategies, and low-downtime cutover using CDC. Includes copy-paste before/after SQL examples for common MySQL-isms and a comparison of migration tools (DBConvert, pgloader, AWS DMS).
Debezium010 phút
Debezium 3.6.0.CR1 Released
Debezium 3.6.0.CR1, the first candidate release for the 3.6 milestone, introduces several enhancements: off-heap memory management for table history and schemas using RocksDB, a 75% reduction in memory allocation and 31–42% CPU overhead reduction in the MySQL connector's poll path, Spanner Omni compatibility, a monitoring REST API and multi-panel dashboard in Debezium Platform, and JDBC sink support in Platform. Oracle connector improvements include better diagnostics for missing archive logs, a unified JDBC driver version, exponential back-off for XStream attach retries, deferred transaction creation until first DML, and filtering of PRIVATE redo thread logs in RAC environments. Bug fixes address a KafkaSchemaHistory recovery race condition, PostgreSQL varbit column handling, Vitess timestamp processing, NanoTimestamp overflow for extreme dates, and CockroachDB temporal type alignment. A total of 44 issues were resolved.