MySQL – ITFROMZERO – Share tobe shared!

MySQL with Go (Golang): Connecting with database/sql, SQLX, and Optimizing Connection Pool for Microservices

By admin July 10, 2026

A practical guide to connecting MySQL with Go using database/sql and SQLX, complete with an optimized Connection Pool configuration for production microservices — solving too many connections errors and delivering meaningful query performance gains.

MySQL

MySQL Connections in Python with PyMySQL and mysql-connector-python: Connection Pooling, Prepared Statements, and Safe Transactions to Prevent SQL Injection

By admin July 10, 2026

A practical guide to connecting MySQL in Python using PyMySQL and mysql-connector-python: setting up Connection Pooling to reuse connections, using Prepared Statements to prevent SQL Injection, and handling Transactions safely with a context manager — complete code examples from quick start to production.

MySQL

Connecting MySQL in Node.js with mysql2: Connection Pooling, Prepared Statements, and Transactions

By admin July 9, 2026

A guide to connecting MySQL in Node.js with the mysql2 library the right way, avoiding the common mistakes junior developers make. Learn how to use Connection Pooling for performance optimization, Prepared Statements to block SQL Injection, and Transactions to ensure data integrity when operating across multiple tables simultaneously.

MySQL

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.