MySQL Archives - ITNotes

MySQL Replication with GTID: Master-Slave Setup and Safe Production Failover

October 18, 2026

Discover how switching to GTID-based MySQL replication eliminates fragile binary log coordinates during production incidents. Follow this real-world guide to configure master-slave clusters and execute zero-data-loss failover safely.

Database

Database Migration with Liquibase: Schema Versioning, Safe Rollbacks, and CI/CD Automation

October 16, 2026

Learn how to version and automate database migrations using Liquibase. This guide covers ChangeSet configuration, tracking mechanisms, safe rollbacks, and CI/CD pipelines.

Database

MySQL Hot Backup with Percona XtraBackup: Automated Full and Incremental Backups for Production

October 4, 2026

Logical backups with mysqldump often cause severe latency and multi-hour restore delays on large datasets. Learn how to implement zero-downtime physical hot backups for MySQL using Percona XtraBackup, complete with automated full and incremental schedules.

Database

Automated Database Schema Migration with Flyway: PostgreSQL, MySQL, and CI/CD Setup

October 3, 2026

Managing schema changes across 14 microservices and two database engines used to trigger bi-weekly deployment panics. Here is how we rolled out Flyway across PostgreSQL and MySQL clusters to make schema updates fully automated and deterministic.

Database

SQL Refactoring: How to Convert Nested Subqueries to CTEs for Better Performance and Readability

September 14, 2026

Deeply nested SQL subqueries are hard to read, debug, and maintain. This guide shows you how to convert them to Common Table Expressions (CTEs) step by step, with real before/after examples and performance verification tips for PostgreSQL and MySQL.

Database

Advanced Vietnamese Search in PostgreSQL and MySQL: Collation, Unaccent, and Index Optimization

September 14, 2026

Vietnamese diacritics break naive database search queries. Here's how to configure Collation in MySQL and the Unaccent extension in PostgreSQL — plus functional and GIN indexes — so searches work correctly without a performance hit.

Database

Scaling Beyond Locks: A Practical Guide to MVCC in PostgreSQL and MySQL

September 8, 2026

MVCC is why your database doesn't crawl to a halt during high traffic. Learn the differences between PostgreSQL and MySQL's approach and how to avoid common concurrency traps.

Database

Querying PostgreSQL, MySQL, and MinIO with Trino: A Single SQL Interface for Multi-Source Data Analysis

August 24, 2026

Learn how to use Trino to run federated SQL queries across PostgreSQL, MySQL, and MinIO S3. This guide covers setup, configuration, and performance tips for multi-source data analysis without ETL.

Database

Multi-language Database Design: 3 Proven Strategies for PostgreSQL and MySQL

August 21, 2026

Don't let your database become a bottleneck as you scale globally. Explore the pros and cons of column-based, relational, and JSONB strategies for multi-language support.

Database

Mastering the MySQL Slow Query Log: Stop Guessing and Start Fixing Production Bottlenecks

August 21, 2026

Is your MySQL database dragging? Learn how to use the Slow Query Log to identify hidden performance bottlenecks, configure logging for production, and use tools like pt-query-digest to speed up your app.