MySQL Archives - Page 2 of 4

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.

Database

Migrating MySQL to PostgreSQL with pgLoader: A 2 AM Survival Guide

May 3, 2026

Migrating a production database at 2 AM is stressful. This guide shows you how to use pgLoader to automate MySQL to PostgreSQL transitions, fix data type mismatches, and resolve 'zero-date' errors.

Database

Querying MySQL, MongoDB, and CSV Directly from PostgreSQL using FDW

May 1, 2026

Tired of ETL? Learn how to use PostgreSQL Foreign Data Wrappers (FDW) to query MySQL, MongoDB, and CSV files as if they were local tables. Real-world performance tips included.