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 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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Get the latest database insights and expert tips delivered to your inbox.
Subscribe to our RSS feed for instant updates.
RSS Feed