MySQL – Page 5 – ITFROMZERO – Share tobe shared!

MySQL Multi-Source Replication: The Ultimate Consolidation Trick for Data Engineers

By admin May 17, 2026

Tired of manual data aggregation? Discover how to configure MySQL Multi-Source Replication to consolidate data from multiple masters into a single source. Practical tips on handling ID conflicts and speed optimization for MySQL 8.0.

MySQL

Percona XtraBackup Guide: Back up 100GB+ MySQL Databases Without System Freezes

By admin May 16, 2026

No more website crashes during MySQL backups! A detailed guide on using Percona XtraBackup for safe Hot Backups of large data without table locking.

MySQL

ALTER TABLE on Large MySQL Tables Without Downtime: A Guide to pt-online-schema-change

By admin May 15, 2026

Don't let ALTER TABLE crash your system. Learn how to use pt-online-schema-change to modify large MySQL tables safely, smoothly, and without downtime.

Database

Horizontal MySQL Sharding with Vitess: Scaling Billions of Records with Zero Downtime

By admin May 13, 2026

Learn how to shard MySQL with Vitess to scale your system to billions of records with zero downtime. Practical insights on Vindex, resharding, and performance optimization for DevOps.

MySQL

MySQL 5.7 to 8.0: A Safe Upgrade Path and Pitfalls to Avoid

By admin May 12, 2026

A practical guide to safely upgrading MySQL 5.7 to 8.0. Learn how to handle authentication errors, reserved keywords, and optimize performance post-upgrade.

Database

Sysbench: How to Measure Real-World Load for MySQL and PostgreSQL (Not Just Theory)

By admin May 10, 2026

A detailed guide on using sysbench to benchmark MySQL and PostgreSQL performance through three stages: Prepare, Run, and Cleanup. Learn how to interpret TPS and Latency metrics to identify database bottlenecks.

MySQL

MySQL SSL/TLS: Don’t Let Your Data Go “Naked” in Transit (mTLS Configuration Guide)

By admin May 9, 2026

Don't let your MySQL data be intercepted. Here is a detailed guide on configuring SSL/TLS and mTLS for maximum security between your application and database server.

Database

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.