Database Archives - Page 2 of 12 - ITFROMZERO

MySQL Savepoint: Don’t Let a Small Error Ruin a Major Transaction

By IT From Zero September 5, 2026

Don't let a small error ruin your entire transaction chain. Learn how to use SAVEPOINT and ROLLBACK TO in MySQL for precise data control and optimized system performance.

Docker

Deploying a MongoDB Sharded Cluster with Docker Compose: Data Sharding for Large-Scale Applications

By IT From Zero September 3, 2026

A guide to deploying a MongoDB Sharded Cluster with Docker Compose, covering config servers, shard replica sets, and a mongos router. Based on real production experience with 10 million documents, including how to choose a shard key, verify data distribution, and monitor the cluster.

MySQL

Manage MySQL Like a Pro: Boost Performance 200% with the mycli and mytop Duo

By IT From Zero September 3, 2026

Speed up MySQL administration with mycli and mytop. A detailed guide on installation, smart autocomplete, and real-time database performance monitoring directly in your terminal.

MySQL

Protecting MySQL from Brute-force Attacks with Connection Control Plugin

By IT From Zero August 28, 2026

Protect MySQL from brute-force attacks using the Connection Control Plugin. A detailed guide on setting failed login thresholds and delay mechanisms for optimal security.

MySQL

MySQL Timezone Handling: Don’t Let Your App Get Lost Across Time Zones

By IT From Zero August 23, 2026

Eliminate MySQL timezone offsets with expert guidance. Learn the difference between TIMESTAMP and DATETIME, loading timezone tables, and optimizing indexes for millions of records.

Database

Installing and Mastering EdgeDB on Linux: A Powerful SQL Alternative

By IT From Zero August 22, 2026

Learn how to install EdgeDB on Linux and use EdgeQL to replace traditional SQL. Detailed guide from schema definition to safe migration management.

MySQL

MySQL Replication Filters: Pro Tips to Filter Databases and Tables to ‘Rescue’ Your Slave

By IT From Zero August 22, 2026

Learn how to use MySQL Replication Filters to optimize data synchronization. Save up to 80% disk space on your Slave and effectively reduce replication lag.

Docker

How to Dockerize SQL Server on Linux: Configuring Volumes, Users, and Practical Backup/Restore

By IT From Zero August 21, 2026

Forget manual SQL Server installations that take hours. This guide helps you Dockerize SQL Server on Linux accurately, ensuring data safety and optimizing your workflow.

MySQL

MySQL SQL Mode: A Shield Against Junk Data and Silent Logic Errors

By IT From Zero August 18, 2026

Stop MySQL from silently truncating your data. Learn how to configure SQL Mode to enable Strict Mode, prevent silent logic errors, and protect your system's data integrity.

Database

Mastering Redis OM: When Redis Becomes More Than Just a Caching Layer

By IT From Zero August 18, 2026

Redis OM helps you manage complex JSON data and perform Full-text search on Redis with lightning speed. Detailed guide for Python and Node.js.