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
MySQL Shell Dump and Load Utilities vs mydumper
Compare MySQL Shell 26.10 dump and load with mydumper 1.0 on locking, chunking, managed targets, deferred indexes, resume, and GTIDs, with commands for each step.
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 Clone Plugin: Provisioning Replicas Without a Backup Restore
Provision a MySQL 8.4 replica with the clone plugin: prerequisites, privileges, DDL and bandwidth settings, progress monitoring, and GTID replication after the clone.
MySQL Invisible Indexes: Drop an Index Safely
Test an index drop on MySQL 8.4 before you commit to it: find unused candidates on every server, hide one with ALTER INDEX INVISIBLE, compare plans, and drop it with a rollback.
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.
MySQL Explained (2026): InnoDB, 8.4 LTS, Replication & Production Patterns
Everything you need to know about MySQL: storage engines, replication topologies, performance tuning, and cloud deployment. From basics to advanced optimization.
MySQL "Communications Link Failure": Fix wait_timeout, HikariCP & All 8 Timeout Variables
MySQL wait_timeout, net_read_timeout, innodb_lock_wait_timeout and max_execution_time — production tuning rules and the HikariCP alignment trick that prevents 'communications link failure' errors.
MySQL binlog Retention, Rotation & Purge: Production Guide (2026)
Configure MySQL binlog retention safely: binlog_expire_logs_seconds, manual purging rules, AWS RDS retention, and the disk-exhaustion failure mode you should monitor for.
MySQL JSON Column Performance: Indexing, Querying, and Schema Design Trade-offs
Understand when MySQL JSON columns help and hurt performance. Learn functional indexes, JSON_TABLE, and when to migrate JSON to normalized columns.
MySQL Foreign Keys: Evolution from 5.7 to 8.4
MySQL's foreign key implementation has evolved significantly from 5.7 through 8.4 — with changes to metadata locking, instant DDL interactions, and Group Replication behavior that every DBA needs to understand.
Get the latest database insights and expert tips delivered to your inbox.
Subscribe to our RSS feed for instant updates.
RSS Feed