ROMHARSHANARCHITECTURE • AI • CLOUD
RELATIONAL DATABASE

MySQL

Production MySQL architecture: InnoDB, transactions, indexing, replication, schema design and recovery.

Start with the pillar →
PILLAR GUIDE
MySQL

MySQL Production Architecture: InnoDB, Transactions, Replication and Scaling

A production blueprint for MySQL covering InnoDB, schema design, transaction boundaries, indexes, replication, backups and scaling decisions.

Read architecture pillar →
PRODUCTION GUIDES

Deep dives for MySQL

5 published
MySQL

MySQL Schema Design and Partitioning: Production Trade-offs

How I design MySQL tables, keys, data types and partitions around access patterns, retention, operational scale and predictable queries.

2 Sept 2026 · 0 views
MySQL

MySQL Replication, High Availability, Backup and Recovery in Production

How I design MySQL primary-replica systems around failover, replica lag, read consistency, binary logs, backups and tested recovery.

2 Sept 2026 · 1 views
MySQL

MySQL Transactions, Isolation, Locking and Deadlocks: A Production Guide

A practical guide to InnoDB transaction scope, isolation levels, row and gap locks, deadlocks, retry strategy and lock-wait diagnosis.

2 Sept 2026 · 0 views
MySQL

MySQL InnoDB Indexing and Query Optimization in Production

How I use clustered primary keys, composite indexes, covering queries, EXPLAIN ANALYZE and buffer-pool awareness to tune MySQL workloads.

2 Sept 2026 · 0 views
CONTINUE EXPLORING
All technology hubs →Technical journal →