ProxySQL Archives - ITFROMZERO - Share tobe shared!

Configuring MySQL Read/Write Splitting with ProxySQL: Offload Read Queries Without Touching Application Code

By IT From Zero October 18, 2026

MySQL Master hitting 100% CPU while replicas sit idle? A step-by-step guide to configuring automatic Read/Write Splitting with ProxySQL to save production without touching application code.

MySQL

Configuring ProxySQL for MySQL: Read/Write Splitting, Connection Pooling, and Query Caching

By IT From Zero October 16, 2026

ProxySQL serves as an intelligent bridge between your application and MySQL database clusters. Here is a practical guide to configuring transparent read/write splitting, optimizing connection pooling, and enabling in-memory query caching without modifying application code.

Database

Defeating SQL Injection in MySQL Production using ProxySQL Firewall

By IT From Zero September 26, 2026

A guide to configuring ProxySQL Firewall for MySQL Production. Learn how to use Query Rules to block SQL Injection and set up secure query whitelisting.

MySQL

Setting Up and Configuring ProxySQL: A Connection Pooler and Load Balancer Solution for MySQL Production

By IT From Zero March 12, 2026

ProxySQL is a powerful connection pooler and load balancer that optimizes performance and stability for MySQL production. This article provides a guide to basic and advanced installation and configuration, along with practical tips for effective ProxySQL deployment, addressing connection management and load distribution issues.