Database Administration – ITFROMZERO

MySQL Multi-Source Replication: The Ultimate Consolidation Trick for Data Engineers

By admin May 17, 2026

Tired of manual data aggregation? Discover how to configure MySQL Multi-Source Replication to consolidate data from multiple masters into a single source. Practical tips on handling ID conflicts and speed optimization for MySQL 8.0.

MySQL

Percona XtraBackup Guide: Back up 100GB+ MySQL Databases Without System Freezes

By admin May 16, 2026

No more website crashes during MySQL backups! A detailed guide on using Percona XtraBackup for safe Hot Backups of large data without table locking.

MySQL

ALTER TABLE on Large MySQL Tables Without Downtime: A Guide to pt-online-schema-change

By admin May 15, 2026

Don't let ALTER TABLE crash your system. Learn how to use pt-online-schema-change to modify large MySQL tables safely, smoothly, and without downtime.

Database

Is Your PostgreSQL Disk Bloating? Pro Tips to Fix Bloat and Optimize Autovacuum

By admin April 21, 2026

PostgreSQL disk full due to Database Bloat? Learn how to optimize Autovacuum, use pg_repack, and REINDEX CONCURRENTLY to free up space without downtime.

Ubuntu

Installing PostgreSQL on Ubuntu 22.04: From Zero to Production Deployment

By admin March 29, 2026

Learn how to professionally install and configure PostgreSQL on Ubuntu 22.04. A guide to creating users, securing remote connections, and managing disk space effectively.