GEGeorge Ezejioforingeorgeezejiofor.com·1d ago · 21 min readRKE2 Homelab Storage: Rook-Ceph & CloudNativePG (The Garage & Cabinets )Episode 5 of the homelab build series. Terraform poured the foundation, Ansible and RKE2 framed the walls, Kyverno and friends wired the alarms, and Tekton and Harbor built the workshop out back. This00
UAUptime Architectinuptimearchitect.hashnode.dev·18h ago · 14 min readThe Migration Completed Successfully. Half the Names Are Now Question Marks.The cutover ran clean. impdp reported completed successfully, the row counts matched to the row, the application came up, and everyone went home. Three weeks later a support ticket lands: a customer n00
LSLokesh Sanapalliinblog.lokesh1729.com·23h ago · 11 min readSystem Design Interview : Multi-version Concurrency Control in Databases — The icebreaker for deciding which relational database to chooseThe goal of MVCC in a DBMS is to allow multiple transactions to read and write to the database simultaneously without interfering with each other when possible. The basic idea of MVCC is that the DBM00
RDRONI DASinsystemdesignacademy.hashnode.dev·1d ago · 7 min readMySQL vs PostgreSQL: I ran the same SQL on both, and a ROLLBACK kept my row"MySQL vs PostgreSQL" gets about 22,000 Google searches a month, and most of the answers are feature lists. I wanted to see the differences with my own eyes. So I installed a fresh MySQL 9.7.1 and a f00
TTwinhullintwinhull.hashnode.dev·1d ago · 5 min readPatroni and HAProxy: which health check to use (/primary, /replica, /leader and the rest)Originally published at https://twinhullhq.com/articles/patroni-haproxy-health-check-endpoints.html HAProxy cannot see which PostgreSQL node is the primary. It asks Patroni, over HTTP, and Patroni ans01P
PSParimal Savajinsavaj-parimal.hashnode.dev·1d ago · 6 min readRelational Database FoundationsRelational databases have been the backbone of software engineering for decades. Whether you are building a simple web application or a massive enterprise system, understanding how data is structured,00
UKUsman Khaninctousman.hashnode.dev·1d ago · 5 min readZero-Downtime Database Migrations: Shadow Tables, Dual-Writing, and Schema ExpansionTaking a mission-critical B2B SaaS database offline for a multi-hour ALTER TABLE migration is no longer acceptable for high-growth engineering teams. Long-running DDL statements acquire exclusive tabl00
PIPrism Infowaysinprisminfoways.hashnode.dev·1d ago · 7 min readWhy Your Database Queries Are Slow: 8 Indexing Mistakes and How to Fix ThemMost slow applications are not slow because of the programming language, the framework, or the server size. They are slow because the database is doing far more work than it needs to. And in most case00
V-VisuaLeaf - MongoDB Data Workspaceinvisualeaf.hashnode.dev·2d ago · 7 min readClickHouse Database Management - Tables, SQL, and SchemasClickHouse is fast when the question involves scanning, grouping, and summarizing large amounts of data. The harder part is usually understanding the tables, data types, sorting keys, and logical rela00
TDTiger Dataintigerdata.hashnode.dev·2d ago · 7 min readTiger Cloud on Azure: Why Fully-Managed TimescaleDB Beats Self-Hosting And Other Managed OptionsOriginally published on September 3, 2026. Written by Nicole Ghalwash. Running TimescaleDB on Azure means choosing between three paths: self-hosting the Apache 2 licensed edition, using the TimescaleD00
