Database.

Database

Follow Late Writes Through a Meilisearch Index Swap

Meilisearch can exchange two index identities atomically. It cannot decide what your application should do with writes that arrive after the replacement…

Aug 15, 202616 min read

Database

pg_dump Is Already Consistent—When Is --snapshot Needed?

A normal pg_dump already produces an internally consistent view of one PostgreSQL database. Passing --snapshot does not make that single dump “more…

Aug 15, 202614 min read

Database

PostgreSQL Serializable Stops the Write Skew Repeatable Read Commits

Two concurrent PostgreSQL transactions each saw two doctors on call, changed different rows, and committed under REPEATABLE READ. The final count was…

Aug 14, 202613 min read

Database

SQLite’s Online Backup API Captures What cp Misses in WAL Mode

Both SQLite files in the reproduced lab returned quick_check=ok. Only one contained all four committed rows. The raw copy of live.db held…

Aug 13, 202614 min read

Database

Set PostgreSQL lock_timeout Below statement_timeout

The reproduced PostgreSQL migration failed in two different ways against the same blocker. With lock_timeout=1200ms and statement_timeout=4s, the server returned canceling statement…

Aug 12, 202616 min read

Database

Repair a Truncated Redis AOF and Prove What Survived

Redis refusing an append-only file is first a forensic boundary, not permission to run --fix against the only copy. Preserve the complete…

Aug 12, 202615 min read

Database

PostgreSQL HOT Updates: Measure the Fillfactor Tradeoff

Lowering PostgreSQL table fillfactor can create more heap-only tuple (HOT) updates, but a copied value such as 70 or 80 is not…

Aug 11, 202614 min read

Database

Caches and Read Replicas Solve Different MySQL Bottlenecks

A Redis-style cache and a MySQL read replica can both reduce reads on the primary database, but they do different work. A…

Aug 8, 202615 min read

Database

MariaDB ALTER TABLE Waits for the Open Transaction

The deployment looked quiet: an application request finished, its database connection returned to the pool, and a migration started. MariaDB then showed…

Aug 5, 202610 min read

Database

A PostgreSQL INVALID Index Can Add Write Overhead

A PostgreSQL index marked INVALID is unavailable to normal query planning, yet it can still add maintenance work for inserts and index-relevant…

Aug 4, 20269 min read

Database

Read the SQLite WAL Checkpoint Before Forcing TRUNCATE

An SQLite -wal file can stay large even after useful pages have been copied back to the main database. File size alone…

Aug 4, 20268 min read

Database

Choose Meilisearch Snapshots for Recovery and Dumps for Migration

A Meilisearch backup is useful only when its format matches the event you need to recover from. Snapshots restore an already indexed…

Aug 4, 202610 min read

Database

When Redis Forks, Measure the Pause and the Copy-on-Write Tail

A Redis persistence cycle can leave two receipts. The first is a short parent-process pause while Redis calls fork(). The second covers…

Aug 4, 20269 min read

Database

A MySQL Deadlock Is a Lock-Order Cycle, Not a Slow Query

MySQL error 1213 with SQLSTATE 40001 means InnoDB detected a transaction deadlock, chose a victim, and rolled that entire transaction back. Recovery…

Aug 4, 20268 min read

Database

PostgreSQL XID Age Is Rising: Find What Autovacuum Cannot Freeze

PostgreSQL transaction IDs are a countdown, not a disk-usage gauge. Every transaction that needs an XID advances a 32-bit counter. Vacuum protects…

Aug 3, 202611 min read

Database

MySQL Replica Lag: Separate Receive Delay from Apply Delay

Two replicas can both report Seconds_Behind_Source: 0 while only one is current. On the healthy replica, the receiver has fetched the source's…

Aug 3, 20269 min read

Database

A Stale PostgreSQL Replication Slot Can Fill Your Disk

Do not delete files from pg_wal to solve a growing PostgreSQL disk. A persistent physical or logical replication slot tells PostgreSQL that…

Aug 3, 20269 min read

Database

Redis to Valkey: A Single-Writer Migration Plan

The dangerous moment in a Redis-to-Valkey migration is not installing the new binary. It is the interval when two servers could accept…

Aug 2, 202610 min read

Database

PgBouncer on a VPS: Stop PostgreSQL Connection Exhaustion

PgBouncer can protect PostgreSQL from connection bursts by accepting many application clients while keeping a smaller, controlled set of database sessions open.…

Aug 2, 20269 min read

AI AND HOSTING

Host a Vector Database on a VPS for Private RAG and AI Search

Host a vector database on a VPS to build private Claude RAG, semantic search and AI knowledge workflows.

Jul 6, 202612 min read

Guides & Tutorials

How to Prevent SQL Injection in PHP: Developer Guide

Turn technical readers into inbound marketing growth Helpful tutorials attract qualified visitors, but reliable hosting keeps those readers engaged. Voxfor VPS gives…

Apr 8, 20269 min read