Databases & Caching
MySQL/MariaDB tuning, backups, replication and Redis.
Databases & Caching articles
Finding Slow Queries in MySQL and MariaDB
A repeatable process for slow-query triage: turn on the log, aggregate it, EXPLAIN the worst offender, add the right index.
October 24, 2026Redis Cluster vs Sentinel
Sentinel gives you automatic failover for one Redis dataset. Cluster shards data across nodes AND fails over. Here's how each works and which you actually need.
September 24, 2026Redis Streams as a Work Queue
Redis Streams give you a persistent, consumer-group log — enough for many work-queue needs without adding Kafka or RabbitMQ. Here's the commands and the reliability model.
September 15, 2026MySQL User Management and Grants
MySQL identity is user + host, and grants apply at several scopes. Here's creating least-privilege app accounts, roles, and reading SHOW GRANTS.
September 1, 2026ProxySQL Basics
ProxySQL sits between apps and MySQL doing connection pooling, read/write splitting, and failover routing. Here's the config model and a working read/write split.
August 30, 2026