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 JSON Functions: A Complete Guide to JSON_EXTRACT, JSON_SET, and Multi-Valued Indexes

A complete guide to MySQL JSON functions — JSON column type, JSON_EXTRACT and arrow operators, JSON_SET vs JSON_INSERT vs JSON_REPLACE vs JSON_MERGE_PATCH, functional indexes, and multi-valued indexes for arrays.

MySQL10 minFeb 28, 2023
Read

MySQL Indexes Explained: Complete Data Structure Guide for Query Optimization

Master MySQL index data structures and optimization strategies. Learn B+ tree internals, index selection, covering indexes, and real-world performance case studies.

MySQL20 minJan 17, 2023
Read

MySQL Full-Text Search: FULLTEXT Indexes, MATCH AGAINST, and Boolean Mode

A production guide to MySQL full-text search — FULLTEXT index creation, MATCH AGAINST in natural language and boolean modes, the 50% rule, InnoDB vs MyISAM FTS, combining with B-tree indexes, and comparison against Elasticsearch.

MySQL11 minNov 14, 2022
Read

Troubleshooting MySQL Issues: Daily Queries Every DBA Should Know

Essential MySQL diagnostic queries every DBA needs. Quickly identify slow queries, lock contention, replication lag, memory issues, and connection problems.

MySQL7 minOct 4, 2022
Read

MySQL Replication Filters: Selective Replication for Specific Databases and Tables

MySQL replication filters let you replicate only specific databases or tables — but misconfiguration can silently drop transactions. Here's how to use binlog-do-db, replicate-do-db, and replicate-do-table safely.

MySQL8 minSep 24, 2022
Read

MySQL Replication Lag: Causes, Diagnosis, and Fixes

A comprehensive guide to MySQL replication lag — why it happens, why Seconds_Behind_Master lies, how to measure accurately with pt-heartbeat, and how to fix it with multi-threaded replication and LOGICAL_CLOCK parallelism.

MySQL13 minSep 15, 2022
Read

MySQL Online Schema Change: pt-osc and gh-ost in Production

A production guide to online MySQL schema changes — when to use pt-online-schema-change vs gh-ost vs MySQL 8.0 INSTANT DDL, configuration parameters, the cutover mechanism, and a step-by-step safety playbook.

MySQL12 minAug 23, 2022
Read

MySQL GTID Replication: Complete Setup and Failover Guide

GTIDs eliminate manual binlog position tracking in MySQL replication. This guide covers enabling GTIDs, CHANGE MASTER TO MASTER_AUTO_POSITION, and failover.

MySQL9 minAug 11, 2022
Read

MySQL Connection Lifecycle: Complete Guide to Connection Management and Optimization

Optimize MySQL connection management for maximum throughput. Learn connection pooling with HikariCP, ProxySQL load balancing, and thread pool configuration.

MySQL17 minJul 19, 2022
Read

Online Schema Change for Tables with Triggers: pt-osc and gh-ost Workarounds

Performing online schema changes on MySQL tables with triggers is a known pain point — pt-osc creates conflicting triggers, and gh-ost has its own limitations. Here are the safe approaches.

MySQL10 minJun 14, 2022
Read

Geospatial Data Handling Made Easy with MySQL 8.0

MySQL 8.0 significantly improved geospatial support with SRID-aware columns, spatial reference systems, and accurate geographic distance calculations. Here's how to use it in production.

MySQL9 minMay 4, 2022
Read

MySQL Tablespace Encryption (TDE): Encrypting Data at Rest

MySQL InnoDB tablespace encryption (TDE) encrypts data pages on disk without changing application code — using a two-tier keyring architecture that separates the master key from table keys.

MySQL9 minMar 22, 2022
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