The JusDB Database Engineering Blog

How RDS Extended Support bills MySQL 8.0 since 1 August 2026, how to estimate it per vCPU-hour, what opting out really does, and how to stop the charge with a blue/green upgrade to 8.4.

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.

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.

Provision a MySQL 8.4 replica with the clone plugin: prerequisites, privileges, DDL and bandwidth settings, progress monitoring, and GTID replication after the clone.

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.

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.

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.

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.