Official ITPUB account sharing technical insights, community news, and exciting events.
This guide introduces a collection of PostgreSQL SKILL scripts for automated health checks and operational analysis, explains the repository layout, shows how to run individual or full daily checks, lists all available skills, and provides a sample report with actionable recommendations.
This article chronicles a decade of MySQL Online DDL improvements—from the painful COPY operations of 5.5 to the near‑zero‑impact INSTANT algorithm in 8.0—while exposing hidden costs, MDL lock pitfalls, and practical best‑practice checklists for safe schema changes.
This guide walks through why a high‑traffic flash‑sale system needs a message queue, explains the three core benefits of async processing, decoupling and traffic‑shaping, and then details RabbitMQ installation, common work patterns, durability, idempotency, ordering, dead‑letter handling, high‑availability clustering and advanced features such as delayed and priority queues.
This article explains how to extend a Flink CDC job that already syncs an entire MySQL database to Doris so that newly created tables are automatically created in Doris in real time, using the CdcTools utility, side‑output streams, and asynchronous I/O.
This guide explains why guaranteeing 100% message reliability in MQ is a critical system‑design interview topic and presents a three‑layer architecture—production, storage, and consumption—detailing ACK settings, local message tables, broker replication, leader election safeguards, manual offset commits, and idempotent processing to prevent any message loss.
Using a 600k‑record IP range dataset, we built identical tables in ClickHouse and Doris, and a Redis skip‑list store, then ran three Flink‑Kafka streaming jobs to compare query latency across the three databases under varying traffic rates, revealing Redis as fastest, ClickHouse second, Doris slowest.
An MP4 video with a misplaced moov box and poor interleaving caused Chrome to issue an initial three 206 requests followed by thousands of range‑jumping requests, inflating CDN traffic, while re‑encoding the file with FFmpeg faststart eliminated the excess requests and restored normal bandwidth usage.
The article examines why MySQL’s transaction layer remains robust while its analytical capabilities lag, outlines enterprise demands for simultaneous OLTP and OLAP workloads, introduces DuckDB’s lightweight yet powerful engine, describes AliSQL’s integration of DuckDB for full MySQL compatibility, and presents TPCH benchmark results showing a dramatic performance boost for analytical queries.
GitHub is transforming from a code‑hosting platform into an AI‑driven development hub by integrating Claude, Codex and Copilot into its Agent HQ, enabling developers to issue commands to multiple AI agents, streamline workflows, and boost productivity across the entire software creation process.
This article translates and consolidates Oracle Real Application Clusters 19c Technical Architecture, using 41 detailed diagrams to explain RAC concepts, configurations, cluster components, storage options, tools, and management commands for building and operating high‑availability Oracle databases.
