Online DDL: Adding Indexes Safely in Production — ALGORITHM Matrix, Row Log & gh-ost vs pt-osc
Online Schema Change mechanics in MySQL and PostgreSQL: why staging finishes in 40s while production exhausts connection pools, ALGORITHM & LOCK matrix, innodb_online_alter_log_max_size overflow, gh-ost vs pt-osc, and PostgreSQL's INVALID index trap.