Database Archives - Page 3 of 9

MySQL Schema Migrations at Scale: A Deep Dive into gh-ost

May 17, 2026

Schema migrations on large MySQL tables don't have to cause downtime. This guide explores the triggerless approach of gh-ost, comparing it with native DDL and pt-osc while providing a step-by-step migration workflow.

Database

MySQL Sharding at Scale: A Practical Guide to Vitess on Kubernetes

May 16, 2026

Scaling MySQL horizontally doesn't have to be a nightmare. This hands-on guide walks you through sharding your database using Vitess on Kubernetes, from setup to VSchema configuration.

Database

Beyond Lat/Lon: A Pro Guide to Mastering PostGIS on PostgreSQL

May 16, 2026

Learn how to move beyond basic latitude and longitude storage. This guide covers PostGIS installation, GEOGRAPHY vs GEOMETRY types, and how GIST indexing can make your spatial queries 100x faster.

Database

Zero-Downtime Database Upgrades: A Survival Guide to Blue-Green Deployment

May 16, 2026

Forget the 2 AM panic. I walk through how to use Blue-Green deployment and logical replication to upgrade PostgreSQL and MySQL with zero downtime and total control.

Database

Deploying TiDB on Docker: Scaling HTAP with a Distributed NewSQL Database

May 12, 2026

Struggling with MySQL scaling or slow analytical queries? Learn how to deploy TiDB on Docker to leverage distributed NewSQL and HTAP capabilities, allowing you to handle transactions and real-time analytics in a single, MySQL-compatible database.

Database

Beyond the Scaling Wall: Why I Switched to ScyllaDB for High-Velocity Data

May 12, 2026

Ditch the JVM pauses. Learn how ScyllaDB uses a C++ shard-per-core architecture to deliver microsecond latency for 2M+ ops/sec applications. Covers setup, CQL modeling, and performance traps.

Database

Mastering Database Branching with Neon: No More 2 AM Production Disasters

May 10, 2026

Tired of production migrations failing due to 'data gaps'? Discover how Neon's database branching lets you test against real production data in isolated, instant environments.

Database

PostgreSQL Disaster Recovery: Why You Need Barman When Your Database Dies at 2 AM

May 10, 2026

A professional guide to PostgreSQL Disaster Recovery. Learn why pg_dump is insufficient for production and how to implement Barman for sub-minute data recovery.

Database

Ditch SQL ‘LIKE’: Building 50ms Search-as-you-type with Meilisearch

May 9, 2026

Is your web app's search dragging? Replace sluggish SQL LIKE queries with Meilisearch to build ultra-fast, typo-tolerant search-as-you-type experiences in minutes.

Database

Scaling IoT to Billions of Points: A 6-Month InfluxDB Field Report

May 9, 2026

Real-world lessons from migrating 1,200 IoT sensors from PostgreSQL to InfluxDB. Learn why B-Trees fail at scale and how downsampling can reduce your storage costs by 85%.