MySQL – ITFROMZERO – Share tobe shared!

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

By admin 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 admin 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 admin 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 admin 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 admin 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 admin 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 admin 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.

MySQL

Manage MySQL Like a Pro: Boost Performance 200% with the mycli and mytop Duo

By admin September 3, 2026

Speed up MySQL administration with mycli and mytop. A detailed guide on installation, smart autocomplete, and real-time database performance monitoring directly in your terminal.

MySQL

Migrating MSSQL to MySQL: Pro Tips for Troubleshooting and Data Type Mismatches

By admin September 3, 2026

Migrating MSSQL to MySQL is more than just clicking a button. This guide helps you resolve DATETIME2 and NVARCHAR(MAX) errors and use bcp for high-speed data migration.

MySQL

mysqlslap: How I “Torture” MySQL to Find Real-World Load Limits

By admin September 2, 2026

Don't wait for a crash to optimize. Learn how to use mysqlslap to simulate hundreds of users, test MySQL load limits, and optimize indexes based on real-world data.