The JusDB Database Engineering Blog
Deep dives on PostgreSQL, MySQL, MongoDB and more — performance tuning, high availability, migrations and production war stories from our DBAs.
Popular Searches
Latest Articles
Showing 5 of 5 articles
MySQL 26.7 and Calendar Versioning: Which MySQL Should You Run Now?
Learn how MySQL 26.7 and 26.10 calendar versions work, how LTS and Innovation tracks differ, which upgrade paths are allowed, and which MySQL version to run in 2026.
MySQL INSTANT DDL: What Is Instant and What Still Copies the Table
Learn which ALTER TABLE changes are instant on MySQL 8.4 and 9.7, how to make MySQL refuse a silent table copy, and how to avoid metadata lock pileups.
MySQL Histograms: When the Optimizer Needs Them
Learn when a MySQL histogram beats an index, how to build one with ANALYZE TABLE, how to read its effect in EXPLAIN, and how to keep it fresh with AUTO UPDATE.
Upgrading MySQL 8.4 LTS to 9.7 LTS: Path, Checks, and Rollback
Plan a MySQL 8.4 to 9.7 LTS upgrade: the supported path, the 9.0 to 9.6 removals to fix first, the upgrade checker run, a replica-first cutover, and rollback limits.
MySQL 8.4 Authentication Errors: mysql_native_password and caching_sha2_password Fixes
Fix MySQL 8.4 authentication errors: why mysql_native_password is not loaded, what caching_sha2_password needs, which drivers work, and how to migrate before 9.x.
Get the latest database insights and expert tips delivered to your inbox.
Subscribe to our RSS feed for instant updates.
RSS Feed