Tag: mysql
Browse 11 practical software engineering resources tagged with "mysql". Discover code recipes, design patterns, documentation templates, and in-depth guides to help you build, deploy, and maintain production-ready solutions involving mysql. Each resource is written for engineers who ship real systems, with copy-paste examples and practical trade-offs.
MySQL in Production
MySQL is one of the most widely used open-source relational databases. Production MySQL requires attention to indexing, replication, backups, connection management, and query optimization.
The resources below cover schema design, transactions, replication, partitioning, performance tuning, and high availability. Each guide helps you run MySQL reliably for real-world workloads.
Every resource includes clear explanations, copy-paste code, and practical warnings. Use them to make informed decisions, avoid production pitfalls, and speed up your delivery. If you are just getting started, read the beginner-friendly articles first; if you are experienced, jump straight to the advanced patterns and architecture guides. New resources are added regularly, so bookmark this page and check back for the latest patterns.
Database Connection Pooling
Configure and tune database connection pools to maximize throughput while preventing connection...
Handle Database Deadlocks and Retries
Detect, prevent, and recover from database deadlocks with automatic retry logic, consistent lock...
Create and Use Database Views and Materialized Views
How to create and use database views and materialized views to simplify queries and improve read...
Implement Event Sourcing in a Relational Database
Build event sourcing in a relational database. Store immutable events, project read models, and use...
Find and Remove Duplicate Rows in SQL
Detect duplicate records in SQL tables using GROUP BY and HAVING, then remove them safely while...
Database Failover Runbook
A step-by-step runbook for executing database failover procedures safely with minimal downtime and...
Database Query Tuning Checklist
A working checklist for tuning slow SQL queries: read the EXPLAIN plan, fix indexes, kill N+1...
Read Replicas: Scale Reads Without Changing Your App
Production guide to database read replicas: streaming replication setup, read/write routing (app,...
SQL Joins — Visual Guide with Examples
A visual guide to SQL joins: INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF joins with practical...
SQL Window Functions — Complete Guide
A practical guide to SQL window functions: ROW_NUMBER, RANK, DENSE_RANK, LEAD, LAG, SUM, AVG over...