Databases: Production Configuration & Operations

Configure, tune, design schemas, migrate, back up, and review database engines - from single-node dev setups to PCI-compliant production clusters. The goal is correct, performant, durable databases that survive failures, pass audits, and don't wake you up at 3am.

Target versions (September 2026):

• PostgreSQL 18.6 (EOL 2030-11; August 13, 2026 release), back-branches: 17.11, 16.15, 15.19, 14.24; PostgreSQL 19 Beta 4 is for testing only
• MongoDB 8.0.32 (GA, EOL 2029-10); 8.0.32 fixes CVE-2026-89099 and is the security floor for the 8.0 lane. The rapid lane is Atlas-only with a short window - verify live before pinning
• MariaDB 11.8.9 (LTS, EOL 2028-06); 12.x rolling GA is quarterly and EOLs at each successor - verify live
• MySQL 8.4.12 (LTS; August 18, 2026 release); the innovation lane has a short support window - verify live
• Redis 8.10.2; Valkey 9.1.2 (9.0.6 on the 9.0 lane) - verify live before pinning
• SQL Server 2025 RTM + CU8 (released 2026-08-13)
• PgBouncer 1.25.2, Pgpool-II 4.7.2, ProxySQL 3.0.10 (ProxySQL 3.0.9+ fixes CVE-2026-48772/48773/48774)