MySQL – ITFROMZERO – Share tobe shared!

MySQL Query Rewrite Plugin: Optimize and Fix SQL Queries Without Touching Your Application Code

By admin May 21, 2026

MySQL Query Rewrite Plugin lets you intercept and modify SQL statements at the database layer without changing any application source code. This guide covers installation, configuration, and practical use cases for production environments.

Database

Using Debezium for Change Data Capture (CDC) from MySQL and PostgreSQL: Real-Time Sync to Kafka Without Touching Your Application

By admin May 21, 2026

A practical guide to setting up Debezium for real-time Change Data Capture (CDC) from MySQL and PostgreSQL, streaming events to Kafka — no application changes required, just reading the transaction log. Covers Docker Compose setup, connector registration, and common troubleshooting.

MySQL

Professional Database Monitoring with MySQL Audit Log Plugin

By admin May 19, 2026

A detailed guide on installing and optimizing the Percona MySQL Audit Log Plugin. This solution tracks all user actions, protects sensitive data, and meets security standards for production systems.

MySQL

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.