The JusDB Database Engineering Blog

Set up MySQL Galera Cluster for synchronous multi-master replication — configuration, split-brain avoidance, and monitoring

Evaluate PlanetScale for MySQL workloads — Vitess-based branching, non-blocking schema changes, and pricing

MySQL 8.0 exposes error logs through performance_schema.error_log — enabling SQL-based filtering by severity, component, and timestamp without grep-ing log files.

Choose a current MySQL logical backup tool from measured recovery needs, and migrate legacy mysqlpump jobs and archives without risking production data.

Deploy and operate MySQL InnoDB Cluster 8.4 safely with AdminAPI, Group Replication, Router, tested failover, and recoverable outage procedures.

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.

ProxySQL's read/write splitting routes SELECT queries to replicas and writes to the primary automatically — but getting the configuration right requires understanding hostgroups, query rules, and lag-aware routing.

ProxySQL maintains a rich internal stats schema that most teams never fully explore. Here's how to use ProxySQL's built-in monitoring to track query latency, backend health, and connection pool utilization.

MySQL generates multiple log files that will fill your disk if left unmanaged. Here's how to configure logrotate correctly for MySQL error logs, slow query logs, and binary logs.

MySQL 8 dramatically improved JSON support with functions that eliminate the need for application-side parsing. Here are 10 JSON functions that will transform how you work with JSON columns in MySQL.