MySQL Archives - ITNotes

Native MySQL High Availability: A Practical Guide to InnoDB Cluster and Router

June 4, 2026

Ditch the complex third-party HA tools. This guide shows you how to deploy a native MySQL InnoDB Cluster with MySQL Router for automated failover and zero data loss.

Database

SQL Joins in Production: How We Fixed Our 10-Second Query Problem

June 1, 2026

A production-focused guide to SQL Joins. Learn the differences between INNER, LEFT, and FULL OUTER joins, and discover how to optimize query performance using indexing and CTEs based on real-world experience.

Database

Scaling Database Performance: A Practical Guide to Read Replicas in PostgreSQL and MySQL

May 24, 2026

Is your database hitting 100% CPU? This guide shows you how to implement Read Replicas in PostgreSQL and MySQL to offload traffic and keep your app fast.

Database

Soft Delete Pattern in Database: Safe Record Deletion, Recovery, and Index Optimization with PostgreSQL and MySQL

May 21, 2026

Soft delete pattern lets you mark records as deleted instead of physically removing them — enabling safe recovery, audit trails, and GDPR-compliant data retention. This guide covers practical implementation in PostgreSQL and MySQL, including partial indexes, unique constraint handling, and cleanup strategies.

Database

MySQL on Fire: Rescuing Production with Percona Toolkit

May 17, 2026

Database meltdowns don't have to be disasters. Learn how to use Percona Toolkit to identify slow queries, change schemas without downtime, and fix replication drift in high-load MySQL environments.

Database

MySQL Schema Migrations at Scale: A Deep Dive into gh-ost

May 17, 2026

Schema migrations on large MySQL tables don't have to cause downtime. This guide explores the triggerless approach of gh-ost, comparing it with native DDL and pt-osc while providing a step-by-step migration workflow.

Database

MySQL Sharding at Scale: A Practical Guide to Vitess on Kubernetes

May 16, 2026

Scaling MySQL horizontally doesn't have to be a nightmare. This hands-on guide walks you through sharding your database using Vitess on Kubernetes, from setup to VSchema configuration.

Database

Zero-Downtime Database Upgrades: A Survival Guide to Blue-Green Deployment

May 16, 2026

Forget the 2 AM panic. I walk through how to use Blue-Green deployment and logical replication to upgrade PostgreSQL and MySQL with zero downtime and total control.

Database

Deploying TiDB on Docker: Scaling HTAP with a Distributed NewSQL Database

May 12, 2026

Struggling with MySQL scaling or slow analytical queries? Learn how to deploy TiDB on Docker to leverage distributed NewSQL and HTAP capabilities, allowing you to handle transactions and real-time analytics in a single, MySQL-compatible database.

Database

Scaling MySQL with ProxySQL: From Master Screams to Production Stability

May 5, 2026

Scale your MySQL environment effectively. This guide shows you how to implement ProxySQL for read/write splitting, reduce CPU load via connection pooling, and handle replication lag automatically.