MySQL Archives - Page 5 of 13 - ITFROMZERO

MySQL Spatial Data: The Ultimate Guide to Handling GPS Coordinates and Finding Nearby Locations

By IT From Zero July 19, 2026

Is calculating GPS distance with DECIMAL slowing down MySQL? Discover how to use Spatial Data, POINT, and Spatial Index to optimize nearby location searches for maximum speed.

MySQL

MySQL E-commerce Schema Design: Don’t Let Your Database Become a Bottleneck When Scaling Up

By IT From Zero July 12, 2026

A practical guide to MySQL schema design for E-commerce. Learn how to manage product variants, inventory, and price snapshots to keep your system stable at scale.

MySQL

Connecting to MySQL with PHP PDO: Absolute Security with Prepared Statements and Transactions

By IT From Zero July 11, 2026

Switching from mysqli to PDO is a vital step for web security. Learn to use Prepared Statements to prevent SQL Injection and Transactions to protect data in PHP.

MySQL

MySQL, Spring Boot & HikariCP: Transaction and Connection Management Secrets to Prevent 2 AM Crashes

By IT From Zero July 11, 2026

Master MySQL and Spring Boot with this practical HikariCP optimization guide. Reduce database CPU load and eliminate Connection Timeout errors in large systems.

MySQL

MySQL Error Log and General Query Log: Production Troubleshooting Techniques for Sysadmins

By IT From Zero July 11, 2026

Learn how to configure MySQL Error Log and General Query Log for rapid system diagnostics. Practical insights on log management and production debugging.

MySQL

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

By IT From Zero 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 IT From Zero 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 IT From Zero 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 IT From Zero 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 IT From Zero 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.