The JusDB Database Engineering Blog

MySQL InnoDB full-text search is underused and often misconfigured. With 8.4 LTS, new defaults and tuning opportunities can cut FTS query time by 60% or more.

Encrypt MySQL data at rest with InnoDB tablespace encryption and in transit with TLS. Covers keyring plugin, require_secure_transport, and binary log encryption.

MariaDB and MySQL have diverged significantly. This guide compares licensing, Galera vs Group Replication, thread pool, cloud support, and migration paths.

Systematically diagnose MySQL replication lag: single-threaded applier, large transactions, missing replica indexes. Enable parallel replication and use pt-heartbeat.

Understand InnoDB crash recovery mechanics and handle edge cases with innodb_force_recovery. Emergency dump procedures and durability settings to prevent future crashes.

Systematically diagnose and fix MySQL 'Too many connections' errors. Learn to identify connection leaks, tune wait_timeout, and implement ProxySQL pooling.

Configure ProxySQL for transparent read/write splitting, connection pooling, and replication lag monitoring. Covers query rules, hostgroups, and stats analysis.

Diagnose MySQL 8.4 InnoDB deadlocks from lock evidence, correct ordering and indexing, use SKIP LOCKED only for queues, and retry whole transactions safely.

MySQL 8.4 LTS removes variables, enforces new replication defaults, and ships changed InnoDB settings that can silently break 8.0 configurations. This production checklist covers every item to verify before upgrading.

Your MySQL instance is at 80% CPU and nobody knows which query is responsible. Learn to enable the slow query log, analyze it with pt-query-digest, and fix the top patterns causing CPU and I/O saturation.

MySQL 8.0 end-of-life is April 2026. Plan your upgrade to MySQL 8.4 LTS now. Learn migration strategies, new features, and compatibility considerations.

MySQL offers multiple replication topologies — traditional async replication, semi-sync, Group Replication, and InnoDB Cluster. Understanding the trade-offs determines whether your failover takes seconds or minutes.