MySQL – Page 2 – ITFROMZERO – Share tobe shared!

Secure phpMyAdmin Installation on Linux: Authentication, IP Restrictions, and Nginx Reverse Proxy

By admin July 8, 2026

A practical guide to installing and securing phpMyAdmin on Linux: combining HTTP Basic Auth, IP whitelisting, and deployment behind an Nginx Reverse Proxy. Includes fail2ban and rate limiting configuration to prevent brute-force attacks.

MySQL

gh-ost: Zero-Downtime MySQL Schema Changes — GitHub’s Answer to pt-osc

By admin July 8, 2026

gh-ost is a tool developed by GitHub for making MySQL schema changes on tables with tens of millions of rows without any downtime. Unlike pt-osc which uses triggers, gh-ost reads the binlog directly — safer, with the ability to pause/resume and adjust speed in realtime throughout the migration.

MySQL

JSON_TABLE() in MySQL 8: Converting Nested JSON Data into Relational Tables

By admin July 6, 2026

JSON_TABLE() in MySQL 8 converts JSON arrays into relational rows, enabling standard GROUP BY, JOIN, and aggregate operations. This guide compares it with JSON_EXTRACT and application-side processing, analyzes when to use each approach, with real-world examples including NESTED PATH and inconsistent data handling.

MySQL

Solving MySQL Replication Lag: Speed Up Syncing with Parallel Replication

By admin July 5, 2026

Eliminate MySQL Replication Lag using Parallel Replication (MTS) and real-world I/O optimization techniques to keep your systems perfectly in sync.

MySQL

Mastering MySQL Optimizer Hints: When to Take the Wheel from the Optimizer?

By admin July 5, 2026

Don't let MySQL decide everything. Discover how to use Optimizer Hints in MySQL 8 to optimize indexes, control JOIN order, and instantly speed up queries.

Centos

Installing MySQL 8 on CentOS Stream 9: Official Repository, SELinux, and Performance Tuning

By admin July 3, 2026

Guide to installing MySQL 8 on CentOS Stream 9 from the official repository — avoiding the common pitfall of getting MariaDB instead. Covers SELinux configuration, firewalld access control, and InnoDB buffer pool tuning for production servers.

MySQL

Configuring MySQL Active-Active Replication: Bidirectional Data Sync and Concurrent Write Conflict Handling

By admin July 2, 2026

A step-by-step guide to configuring MySQL Active-Active (Master-Master) Replication — from setting up binlog users and configuring auto_increment to prevent ID collisions, to handling write conflicts and practical routing tips from a 50GB production database.

MySQL

Multi-tenant Architecture in MySQL: From Hard-Learned Lessons to Scaling SaaS for Thousands of Users

By admin July 1, 2026

Learn how to implement Multi-tenancy in MySQL based on real-world experience. A detailed comparison of Database-per-tenant and Shared Schema, including data security tips using Session Variables.

MySQL

Rescuing MySQL Data: A Hands-On Guide to Handling InnoDB Corruption

By admin June 28, 2026

MySQL crashed due to InnoDB corruption? Don't panic. Follow this 5-step process using innodb_force_recovery to safely and efficiently recover your data.

Database

Analyzing MySQL Slow Query Log with pt-query-digest: Pinpointing the Real Culprit Behind Database Slowdowns

By admin June 27, 2026

pt-query-digest from Percona Toolkit analyzes MySQL Slow Query Log by grouping and ranking queries by their performance impact. A step-by-step guide: enable logging, install the tool, read the report, and optimize real-world queries.