JusDB
Free DB Audit

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.

50 canonical articlesBrowse the complete archive

Popular Searches

MySQL Articles

← Clear filter

Showing 12 of 50 articles

MySQL User Permissions Best Practices: Least Privilege and Password Policy

Harden MySQL user permissions with host-scoped grants, validate_password plugin, account locking, and privilege auditing. Essential for SOC2 and PCI-DSS compliance.

MySQL5 minApr 25, 2025
Read

MySQL Audit Logging: MariaDB Audit Plugin, General Log, and Trigger-Based Auditing

Implement MySQL audit logging for SOC2, PCI-DSS, and HIPAA compliance. Covers MariaDB Audit Plugin, general query log, trigger-based auditing, and SIEM integration.

MySQL7 minApr 16, 2025
Read

MySQL 8.4 Full-Text Search: InnoDB FTS Tuning and Best Practices

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.

MySQL8 minApr 8, 2025
Read

MySQL Encryption at Rest and in Transit: InnoDB, TLS, and Binary Log Encryption

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

MySQL1 minApr 7, 2025
Read

MariaDB vs MySQL in 2026: Which Should You Choose?

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

MySQL9 minMar 4, 2025
Read

MySQL InnoDB Crash Recovery: Diagnosis and Emergency Procedures

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

MySQL4 minFeb 17, 2025
Read

Diagnosing MySQL Connection Saturation: Too Many Connections Fix

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

MySQL1 minFeb 7, 2025
Read

MySQL InnoDB Deadlocks: Diagnosis, Root Causes, and Prevention

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

MySQL6 minJan 10, 2025
Read

MySQL 8.0 Is EOL: Upgrade Checklist for 8.4 LTS (5 Breaking Changes to Fix First)

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.

MySQL17 minAug 13, 2024
Read

MySQL Replication Options: Native Replication vs Group Replication vs InnoDB Cluster

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.

MySQL9 minNov 9, 2023
Read

Securing MySQL Connections with SSL/TLS: A Complete Configuration Guide

MySQL transmits data in plaintext by default, exposing passwords and query results to network interception. Here's how to configure SSL/TLS for MySQL — from certificate generation to enforcing encrypted connections.

MySQL9 minSep 23, 2023
Read

ProxySQL: The Complete Guide to MySQL Load Balancing and Connection Pooling

ProxySQL pools thousands of application connections into a small backend pool, splits reads to replicas automatically, and lets you change routing without touching application code or restarting MySQL.

MySQL10 minMay 9, 2023
Read
Newsletter

Get the latest database insights and expert tips delivered to your inbox.

Stay Connected

Subscribe to our RSS feed for instant updates.

RSS Feed