Database Archives - ITFROMZERO - Share tobe shared!

Optimizing Redis RAM with HyperLogLog and Bloom Filter: Counting and Deduplicating at Scale

By IT From Zero October 26, 2026

Learn how to use Redis HyperLogLog and Bloom Filter to count unique visitors and deduplicate large-scale data, slashing RAM usage by over 95% compared to traditional Sets.

Database

Diagnosing and Resolving Deadlocks in PostgreSQL: Inspecting Lock Trees and Configuring Proper Timeouts

By IT From Zero October 26, 2026

An in-depth look at the root causes of PostgreSQL deadlocks, step-by-step reproduction, Lock Tree query techniques to locate root blockers, and timeout tuning to safeguard your system.

Database

MySQL Group Replication Tutorial: Building an Auto-Failover InnoDB Cluster

By IT From Zero October 25, 2026

A step-by-step guide to setting up a MySQL InnoDB Cluster with Group Replication and MySQL Shell, enabling automated detection and failover in 2–3 seconds.

Development

How to Back Up SQLite to S3 with Litestream: Real-Time Production Backups

By IT From Zero October 23, 2026

Litestream's Continuous WAL Replication makes SQLite production-ready with real-time backups to S3 and second-accurate Point-in-Time Recovery.

MySQL

Configuring the FEDERATED Storage Engine in MySQL: Connect and Query Remote Tables

By IT From Zero October 22, 2026

The FEDERATED Storage Engine in MySQL lets you directly query remote tables without building an ETL pipeline. This guide covers step-by-step setup, credential security, and critical performance pitfalls to avoid.

Python

Battle-Tested SQLAlchemy 2.0 Async: Eliminating MissingGreenlet and Connection Pool Exhaustion

By IT From Zero October 21, 2026

Hit by connection pool exhaustion and MissingGreenlet at 2 AM? Here is a practical guide to configuring AsyncSession, eager loading, and streaming in SQLAlchemy 2.0 Async.

MySQL

Optimistic vs. Pessimistic Locking in MySQL: Eliminating Race Conditions and Overbooking

By IT From Zero October 20, 2026

A deep dive into Optimistic and Pessimistic Locking in MySQL, featuring practical code examples to prevent race conditions, deadlocks, and negative inventory.

Database

Configuring MySQL Read/Write Splitting with ProxySQL: Offload Read Queries Without Touching Application Code

By IT From Zero October 18, 2026

MySQL Master hitting 100% CPU while replicas sit idle? A step-by-step guide to configuring automatic Read/Write Splitting with ProxySQL to save production without touching application code.

Database

How to Install and Configure pgRouting on PostgreSQL: Build Your Own Shortest Path Routing Engine

By IT From Zero October 17, 2026

A hands-on guide to resolving logistics dispatch bottlenecks: installing pgRouting on PostgreSQL, building graph topologies, and computing optimal shortest paths.

MySQL

A Guide to Using Multi-Valued Indexes in MySQL 8: Optimizing JSON Array Queries

By IT From Zero October 17, 2026

Real-world experience optimizing JSON array queries in MySQL 8 using Multi-Valued Indexes, slashing query times from 1.8s down to 2ms across tables with over 10 million rows.