MySQL – Page 5 – ITFROMZERO – Share tobe shared!

TiDB: The “Ice-Breaking” Solution for Overloaded MySQL and Big Data Analytics

By admin May 28, 2026

MySQL overloaded? Sharding too difficult? Discover TiDB—a perfect MySQL-compatible distributed database solution for handling billions of rows and ultra-fast HTAP analytics.

Network

Mastering Nginx Stream Module: TCP/UDP Load Balancing for Databases, Redis, and MQTT

By admin May 27, 2026

A practical guide to using Nginx Stream Module for TCP/UDP load balancing for MySQL, Redis, and MQTT. Learn Layer 4 configuration, security optimization, and real-world troubleshooting tips.

Fedora

Installing and Configuring MariaDB on Fedora Server: Production Database Deployment with SELinux and firewalld

By admin May 22, 2026

A complete guide to getting MariaDB production-ready on Fedora Server: securing the installation with mysql_secure_installation, opening ports correctly with firewalld rich rules, handling SELinux context for custom datadirs, and debugging refused connections. Includes basic performance tuning and a final production checklist.

MySQL

Deploying MaxScale as a Database Proxy: Automatic Read/Write Splitting for MySQL

By admin May 22, 2026

A detailed guide on deploying MaxScale as a Database Proxy for MySQL. Learn how to configure automatic Read/Write Splitting and handle Slave Lag to optimize performance.

MySQL

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.