Database – ITFROMZERO – Share tobe shared!

Optimizing my.cnf for MySQL 8: Don’t Let Your Server ‘Choke’ on Default Settings

By admin June 28, 2026

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.

MySQL

MySQL InnoDB Locking: Understanding Row, Gap, and Next-Key Locks to Prevent System Crashes

By admin June 27, 2026

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.

Database

Professional Database Schema Management with Bytebase: GitOps Workflow and SQL Review for Dev Teams

By admin June 27, 2026

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.

MySQL

Optimizing MySQL Storage: Choosing the Right Data Types to Speed Up I/O and Save RAM

By admin June 26, 2026

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.

Database

pg_cron: Schedule Automated Jobs Inside PostgreSQL Without System Cron

By admin June 23, 2026

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.

MySQL

MySQL Isolation Levels: Don’t Let Transactions Ruin Your Data

By admin June 21, 2026

Dirty Read, Non-repeatable Read, and Phantom Read are classic database errors. Learn how MySQL uses four Isolation levels to protect your data.

MySQL

Fixing MySQL Connection Errors: From 1045 to ‘Too Many Connections’ – Real-World Stories and Solutions

By admin June 20, 2026

Fix MySQL errors 1045, 2002, and Too Many Connections with hands-on, real-world guidance. Learn how to accurately diagnose problems and optimize database connections based on practical experience.

Database

MongoDB Change Streams in Node.js: Real-Time Data Change Tracking

By admin June 18, 2026

MongoDB Change Streams let your Node.js application listen for data changes in real time instead of polling. This article covers practical implementation, resume token handling, and safe reconnect strategies for production environments.

Database

ArangoDB: The All-in-One Solution Replacing MongoDB, Redis, and Neo4j

By admin June 18, 2026

ArangoDB is a Native Multi-model solution that replaces MongoDB, Redis, and Neo4j with a single engine. Check out our guide to installing and optimizing RocksDB to speed up your system.

MySQL

MySQL Semi-synchronous Replication: Zero Data Loss Without Group Replication

By admin June 13, 2026

MySQL Semi-synchronous Replication ensures zero data loss for production databases by requiring at least one slave to acknowledge receipt of the binlog before the master commits. This article compares async, semi-sync, and Group Replication, analyzes when each is appropriate, and provides a step-by-step deployment guide from enabling the plugin to real-world monitoring.