MySQL – Page 6 – ITFROMZERO – Share tobe shared!

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.

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.