MySQL Archives - Page 4 of 16 - ITFROMZERO

How to Use Flyway for MySQL Schema Migration and Version Control in CI/CD

By IT From Zero October 3, 2026

Learn how to use Flyway to automate schema migrations and version control for MySQL databases. Eliminate schema drift during deployments and integrate safely into your CI/CD pipeline.

Database

Defeating SQL Injection in MySQL Production using ProxySQL Firewall

By IT From Zero September 26, 2026

A guide to configuring ProxySQL Firewall for MySQL Production. Learn how to use Query Rules to block SQL Injection and set up secure query whitelisting.

MySQL

Deploying MySQL NDB Cluster: A “Zero Downtime” Database Solution for 99.999% Uptime Systems

By IT From Zero September 18, 2026

Learn how to deploy MySQL NDB Cluster to achieve 99.999% uptime. This article provides a detailed guide from Docker setups and the 3-node architecture to RAM and network infrastructure tips for DevOps/DBA engineers.

MySQL

Migrating PostgreSQL to MySQL: Hard-won Lessons and a Real-world Workflow

By IT From Zero September 17, 2026

A step-by-step guide to the PostgreSQL to MySQL migration process, covering data type discrepancies and SQL syntax fixes to ensure data integrity.

MySQL

MySQL on Windows Server 2022: Don’t Let ‘Next -> Next’ Compromise Your System

By IT From Zero September 17, 2026

Don't just click 'Next' when installing MySQL. Learn how to configure Windows Authentication, optimize RAM for 15M+ records, and secure your firewall for production.

Database

Self-Hosting Apache Superset with Docker: A Cost-Effective BI Solution for MySQL and PostgreSQL

By IT From Zero September 6, 2026

A step-by-step guide to installing Apache Superset using Docker. A powerful open-source BI solution to visualize MySQL and PostgreSQL data while saving thousands in licensing fees.

MySQL

Delayed Replication in MySQL: A “Lifesaver” for Accidental Data Deletion

By IT From Zero September 5, 2026

Don't let a simple mistake destroy your entire database. Learn how to configure Delayed Replication in MySQL to create a 'time machine' for instant data recovery.

MySQL

InnoDB Page Compression: A Pro Tip to Reduce Storage by 50% and Extend SSD Lifespan for MySQL

By IT From Zero September 5, 2026

Discover how to use InnoDB Page Compression to reduce MySQL storage by 50%. Detailed guide on configuration, checking actual disk usage, and CPU performance considerations.

MySQL

MySQL Savepoint: Don’t Let a Small Error Ruin a Major Transaction

By IT From Zero September 5, 2026

Don't let a small error ruin your entire transaction chain. Learn how to use SAVEPOINT and ROLLBACK TO in MySQL for precise data control and optimized system performance.

MySQL

How to Find and Remove Unused Indexes in MySQL: Reclaim Disk Space and Speed Up Writes

By IT From Zero September 4, 2026

Unused indexes in MySQL don't just waste disk space — they slow down every write operation. This guide walks through how to safely identify and remove them using performance_schema and the sys schema, complete with a pre-drop checklist and an automated monitoring script.