Running ALTER TABLE migrations on multi-terabyte MySQL tables historically caused thread contention, lock exhaustion, and replication lag due to synchronous database triggers. gh-ost solves this as GitHub's open-source, triggerless online schema migration tool. By streaming row-based binlog events as an external replica, gh-ost enables non-blocking, pausable DDL migrations with atomic cutovers. #MySQL #ghost #DatabaseArchitecture #DevOps #SRE #DBA #GitHub #DataEngineering #FinOps #SysAdmin
Running Docker Desktop for local database testing drains laptop battery and introduces memory bloat. Pairing DBngin (native multi-version engine runner for PostgreSQL, MySQL, and Redis) with DBX (the open-source 25MB GUI client supporting 100+ databases with native MCP agent support) creates a zero-Docker local database stack. #DBngin #DBX #Database #PostgreSQL #MySQL #Redis #DevOps #WebDev #Backend #LocalDev #TablePlus #MCP
Default MySQL collations compare strings case-insensitively, matching tokens like 'A7f3B9' and 'a7f3b9'. Laravel 13.27 introduces whereBinary() and whereNotBinary() for byte-exact, case-sensitive database queries natively in Eloquent. Learn how to optimize query indexing and prevent collation bugs. #Laravel #PHP #MySQL #Database #Eloquent #Backend #SQL #WebDev #LaravelDev #DatabaseDesign