MySQL Archives - ITFROMZERO - Share tobe shared!

How to Configure Change Data Capture (CDC) in MySQL with Debezium and Apache Kafka

By IT From Zero October 9, 2026

A comprehensive guide on setting up Change Data Capture (CDC) in MySQL with Debezium and Apache Kafka, streaming real-time data changes to Kafka while offloading production databases.

MySQL

Optimizing MySQL InnoDB Table Fragmentation: Using OPTIMIZE TABLE to Reclaim Disk Space

By IT From Zero October 7, 2026

Why does deleting millions of records fail to free up MySQL disk space? Here is how to detect InnoDB table fragmentation and safely use OPTIMIZE TABLE to reclaim disk space on production.

MySQL

Configuring MySQL High Availability with Keepalived and HAProxy: Automated Virtual IP (VIP) Failover

By IT From Zero October 6, 2026

A detailed comparison of MySQL High Availability solutions and a step-by-step guide to configuring Keepalived with HAProxy for automated Virtual IP (VIP) failover.

MySQL

Integrating MySQL with Elasticsearch via Logstash: Building an Automated Data Sync Pipeline

By IT From Zero October 5, 2026

Is your MySQL database hitting CPU bottlenecks from heavy search queries? Learn how to build an automated sync pipeline to Elasticsearch with Logstash JDBC—quick, clean, and without touching backend code.

MySQL

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.

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.

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.