The Query

Your go-to source for insights into the evolving world of data and infrastructure. We use this blog to break down complex database scaling and new tech into clear, actionable lessons for every builder.

Database Branching for Microsoft SQL Server

Database Branching for Microsoft SQL Server

• By Sergey Pronin Sergey Pronin

SQL Server runs the systems AI agents could help with most, and has no way to hand them a safe, writable copy. We added SQL Server to our branching plugin for OpenEverest: a branch of a standalone instance or an Always On Availability Group in under 40 seconds, whatever the size, cleaned up so it can't touch production, plus reset, restore points and rollback.

Redis to Valkey Migration on Kubernetes with RedisShake and OpenEverest

Redis to Valkey Migration on Kubernetes with RedisShake and OpenEverest

• By Sergey Pronin Sergey Pronin

OpenEverest can now move a live Redis or Valkey database into a Valkey instance it manages, with a snapshot, ongoing replication and an exact cutover, built on RedisShake. We migrated a 50 GiB Redis cluster and a 150-million-key one while an application kept writing to them, then compared every key on both sides. None were missing or different, every TTL survived, and the same data took 10-20% less memory on Valkey.

CrashLoopBackOff: Why Databases Crash-Loop on Kubernetes and How to Fix It

CrashLoopBackOff: Why Databases Crash-Loop on Kubernetes and How to Fix It

• By Sergey Pronin Sergey Pronin

We broke PostgreSQL 18 and MySQL 8.4 on Kubernetes 22 different ways - OOM kills, failed probes, bad Secrets, PVC and disk problems, config typos and version changes - and wrote down exactly what CrashLoopBackOff looked like each time, how to diagnose it in a minute, and which fixes actually work. Several 'fixed' pods came back Ready but broken.