MySQL – Page 2 – ITFROMZERO – Share tobe shared!

Free Your Hands with SchemaSpy: Automating ERD Diagrams and Database Documentation

By admin May 8, 2026

Stop drawing ERD diagrams by hand! A guide to using SchemaSpy for automated database scanning, generating HTML reports, and professional relationship diagrams in minutes.

MySQL

MySQL Clone Plugin: How to Copy Hundreds of GBs in a Flash Instead of Waiting for mysqldump

By admin May 6, 2026

Forget mysqldump! A detailed guide on using MySQL Clone Plugin to copy data directly between servers at ultra-high speeds, safe for databases of hundreds of GBs.

Database

Database Encryption: Don’t Leave Your Data Exposed with pgcrypto and AES_ENCRYPT

By admin May 5, 2026

Don't let user data leak in plain-text. Learn how to use pgcrypto and AES_ENCRYPT to encrypt sensitive data according to modern security standards.

MySQL

MySQL Router: The ‘Gatekeeper’ Enabling Automatic Failover and Fault Tolerance for InnoDB Clusters

By admin May 4, 2026

Don't let your database become a single point of failure. This guide covers how to set up MySQL Router to automate routing and failover for production InnoDB Clusters.

MySQL

MySQL Generated Columns: The Ultimate Query Speed ‘Hack’ Without Changing Code

By admin April 30, 2026

Don't let complex calculations slow down your database. Discover how to use MySQL Generated Columns to optimize indexes for JSON and calculated data for superior query performance.

MySQL

MySQL on Kubernetes: Don’t Let Your Data Vanish – Practical Experience with StatefulSet

By admin April 30, 2026

A practical guide to deploying MySQL on Kubernetes. Explore how StatefulSet and Persistent Volume protect your database and learn performance optimization tips from real-world experience.

MySQL

MySQL GTID Replication Setup Guide: Advanced Data Synchronization and Automatic Failover

By admin April 27, 2026

A step-by-step guide to configuring MySQL GTID Replication on Ubuntu: set up Master and Slave, verify data synchronization, and handle automatic failover without manually tracking binlog positions.

MySQL

Monitor MySQL Performance with Performance Schema and sys Schema: Find Bottlenecks Fast

By admin April 24, 2026

A hands-on guide to using Performance Schema and sys Schema in MySQL to detect slow queries, lock waits, and I/O bottlenecks — a step-by-step workflow for developers just starting to optimize their database.

MySQL

MySQL: Don’t Let utf8 Deceive You – The Ultimate Guide to Fixing Emojis and Font Issues with utf8mb4

By admin April 24, 2026

Don't let MySQL's 'utf8' mislead you. A detailed guide on configuring utf8mb4 to support Emojis and Vietnamese, plus how to handle the 767-byte index error based on real-world experience.

MySQL

MySQL 8: Leveraging Functional and Invisible Indexes to Handle Millions of Records

By admin April 22, 2026

Discover how to optimize MySQL 8 with Functional and Invisible Indexes. Speed up JSON and date queries while safely testing indexes in production environments.