The JusDB Database Engineering Blog

StarRocks is an open-source MPP analytics database. This 2026 guide covers FE/BE/CN architecture, the four table models, vectorized execution, and when to choose StarRocks over ClickHouse.

MySQL architecture from query parser to disk: optimizer pipeline, InnoDB buffer pool, redo log, and storage internals every production DBA needs in 2026.

Production MariaDB Galera Cluster: mariabackup-based SST, MaxScale Galera-aware routing, schema-change strategy with TOI vs RSU, and a troubleshooting playbook for the failures that actually take down production.

Complete guide to StarRocks monitoring with Prometheus and Grafana. Covers resource saturation, cluster health, and application availability alerts with PromQL expressions and runbooks.

Eliminate stale cache reads and thundering-herd stampedes by streaming MySQL binlog changes to Valkey via Debezium CDC. Full Java setup with embedded engine and XFetch.

Use PostgreSQL range types (daterange, tstzrange) and exclusion constraints to prevent overlapping bookings and schedules. Includes room booking, multirange types, and GiST index examples.

Configure auto_explain to automatically log EXPLAIN output for slow PostgreSQL queries. Covers log_analyze, log_buffers, sample_rate, JSON format, and RDS setup.

Use hypopg to test how a new PostgreSQL index would affect query plans before building it. Includes install, hypothetical index creation, EXPLAIN workflow, and index sizing.

Master PostgreSQL window functions: ROW_NUMBER, RANK, SUM OVER, LAG/LEAD, moving averages, and frame clauses. Real SQL examples for analytics and reporting queries.

Configure pgAudit for PostgreSQL SOC2, PCI-DSS, and HIPAA compliance. Covers session vs object auditing, log format, log volume management, and SIEM integration.