Posted inDatabase
Dragonfly: A Redis Alternative for Systems with Millions of Requests
Is single-threaded Redis slowing down your system? Discover Dragonfly - a multi-threaded in-memory database fully compatible with Redis but 25x faster.
Posted inCentos
Installing MySQL 8 on CentOS Stream 9: Official Repository, SELinux, and Performance Tuning
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.
Posted inMySQL
Configuring MySQL Active-Active Replication: Bidirectional Data Sync and Concurrent Write Conflict Handling
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.
Posted inDatabase
PostgreSQL Anonymizer: The Ultimate Trick to Mask Production Data for Staging Without PII Leaks
No more worrying about PII leaks during Production dumps. A detailed guide on using PostgreSQL Anonymizer to automatically anonymize emails and phone numbers for Staging/Dev.
Posted inMySQL
Optimizing my.cnf for MySQL 8: Don’t Let Your Server ‘Choke’ on Default Settings
MySQL 8's default configuration is often underpowered. This guide shows you how to optimize my.cnf to maximize RAM and CPU usage for better database load handling.
Posted inMySQL
MySQL InnoDB Locking: Understanding Row, Gap, and Next-Key Locks to Prevent System Crashes
A deep dive into Row, Gap, and Next-Key Locks in MySQL InnoDB. Real-world experience for preventing deadlocks and optimizing performance for high-scale systems.
Posted inDatabase
Professional Database Schema Management with Bytebase: GitOps Workflow and SQL Review for Dev Teams
A detailed guide on using Bytebase to manage Database Schema Changes following GitOps standards. Help dev teams automate SQL reviews for safer and more professional deployments.
Posted inMySQL
Optimizing MySQL Storage: Choosing the Right Data Types to Speed Up I/O and Save RAM
Choosing the wrong MySQL data types causes unnecessarily bloated databases, high I/O, and wasted RAM. This article shares real-world experience from a 50GB production database: how to choose correctly between INT/BIGINT, VARCHAR/TEXT, ENUM, and TIMESTAMP to optimize performance right from schema design.
Posted inDatabase
pg_cron: Schedule Automated Jobs Inside PostgreSQL Without System Cron
pg_cron is an extension that lets you schedule recurring jobs directly inside PostgreSQL without needing system cron or pgAgent. This article walks through installation, creating jobs for log cleanup and materialized view refreshes, and practical tips for managing jobs effectively.
Posted inMySQL
MySQL Isolation Levels: Don’t Let Transactions Ruin Your Data
Dirty Read, Non-repeatable Read, and Phantom Read are classic database errors. Learn how MySQL uses four Isolation levels to protect your data.