The JusDB Database Engineering Blog

Use MySQL JSON columns effectively with path operators, functional indexes via generated columns, JSON_CONTAINS filtering, and partial updates with JSON_SET.

MySQL Group Replication and Galera Cluster both promise multi-primary high availability, but they behave very differently under load, network partitions, and node failures.

Connection exhaustion is one of the most common causes of database downtime at scale. Here is how production teams use PgBouncer and ProxySQL to handle 10,000+ concurrent connections.

MySQL 8 introduced comprehensive password management — password validation policies, reuse history, expiration, and dual passwords for zero-downtime credential rotation.

Implement MySQL table partitioning with RANGE and HASH strategies. Covers instant partition drops for data lifecycle, partition pruning verification, and key gotchas.

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

Aurora and RDS share the MySQL engine but diverge at the storage layer in ways that produce very different cost and performance profiles — the right choice depends entirely on your I/O pattern.

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

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.

A detailed comparison of Google Cloud SQL, Amazon RDS, and Azure Database for MySQL and PostgreSQL — HA architecture, failover times, connection pooling, pricing for equivalent instances, and platform-specific features.

Configure MySQL Group Replication (MGR) with Paxos-based consensus for fault-tolerant clustering. Covers prerequisites, bootstrap, joining nodes, and health monitoring.