MySQL Archives - ITFROMZERO - Share tobe shared!

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.

Security

Guide to Securing MySQL Server on Linux: TLS/SSL, Audit Plugin, and InnoDB Encryption

By IT From Zero October 16, 2026

A step-by-step guide to in-depth MySQL Server security on Linux: encrypting in-transit connections with TLS 1.3, securing data-at-rest with InnoDB Tablespace Encryption, and monitoring queries using Percona Audit Log.

MySQL

A Guide to Automating MySQL Database Schema Migrations with Liquibase and CI/CD

By IT From Zero October 15, 2026

Ditch manual midnight SQL script deployments. Learn how to track MySQL schema changes with Liquibase and build safe CI/CD pipelines without table locks or drift.

MySQL

Advanced MySQL 8 Security: Mastering Roles (RBAC) and Practical Caching_sha2_password

By IT From Zero October 11, 2026

Take full advantage of Roles (RBAC) and the caching_sha2_password mechanism in MySQL 8. Discover essential configuration tips for clean, secure production user management.

MySQL

A Guide to MySQL High Availability with Orchestrator: Automated Topology Discovery and Safe 2 AM Failover

By IT From Zero October 10, 2026

Learn how to achieve High Availability for MySQL using Orchestrator: automated topology mapping, split-brain prevention, and reliable failover in under 15 seconds.

MySQL

How to Configure Change Data Capture (CDC) in MySQL with Debezium and Apache Kafka

By IT From Zero October 9, 2026

A comprehensive guide on setting up Change Data Capture (CDC) in MySQL with Debezium and Apache Kafka, streaming real-time data changes to Kafka while offloading production databases.

MySQL

Optimizing MySQL InnoDB Table Fragmentation: Using OPTIMIZE TABLE to Reclaim Disk Space

By IT From Zero October 7, 2026

Why does deleting millions of records fail to free up MySQL disk space? Here is how to detect InnoDB table fragmentation and safely use OPTIMIZE TABLE to reclaim disk space on production.

MySQL

Configuring MySQL High Availability with Keepalived and HAProxy: Automated Virtual IP (VIP) Failover

By IT From Zero October 6, 2026

A detailed comparison of MySQL High Availability solutions and a step-by-step guide to configuring Keepalived with HAProxy for automated Virtual IP (VIP) failover.

MySQL

Integrating MySQL with Elasticsearch via Logstash: Building an Automated Data Sync Pipeline

By IT From Zero October 5, 2026

Is your MySQL database hitting CPU bottlenecks from heavy search queries? Learn how to build an automated sync pipeline to Elasticsearch with Logstash JDBC—quick, clean, and without touching backend code.

MySQL

How to Use Flyway for MySQL Schema Migration and Version Control in CI/CD

By IT From Zero October 3, 2026

Learn how to use Flyway to automate schema migrations and version control for MySQL databases. Eliminate schema drift during deployments and integrate safely into your CI/CD pipeline.