Database – Page 2 – ITFROMZERO

Valkey Installation Guide: The Perfect Open Source Redis Alternative

By admin May 16, 2026

Valkey is a fully open-source fork of Redis created after its license change. Here is a detailed guide to installing Valkey on Docker and Ubuntu for developers.

Database

Horizontal MySQL Sharding with Vitess: Scaling Billions of Records with Zero Downtime

By admin May 13, 2026

Learn how to shard MySQL with Vitess to scale your system to billions of records with zero downtime. Practical insights on Vindex, resharding, and performance optimization for DevOps.

MySQL

MySQL 5.7 to 8.0: A Safe Upgrade Path and Pitfalls to Avoid

By admin May 12, 2026

A practical guide to safely upgrading MySQL 5.7 to 8.0. Learn how to handle authentication errors, reserved keywords, and optimize performance post-upgrade.

Database

Sysbench: How to Measure Real-World Load for MySQL and PostgreSQL (Not Just Theory)

By admin May 10, 2026

A detailed guide on using sysbench to benchmark MySQL and PostgreSQL performance through three stages: Prepare, Run, and Cleanup. Learn how to interpret TPS and Latency metrics to identify database bottlenecks.

Artificial Intelligence tutorial - IT technology blog

Build Your Own Text-to-SQL System with Vanna.ai: Let AI Handle 80% of Mundane Reporting Tasks

By admin May 8, 2026

Learn to build a professional Text-to-SQL system with Vanna.ai and Python. This article shares real-world experiences to help reduce mundane reporting tasks for tech teams by 70%.

MySQL

MySQL Clone Plugin: How to Copy Hundreds of GBs in a Flash Instead of Waiting for mysqldump

By admin May 6, 2026

Forget mysqldump! A detailed guide on using MySQL Clone Plugin to copy data directly between servers at ultra-high speeds, safe for databases of hundreds of GBs.

Database

Database Encryption: Don’t Leave Your Data Exposed with pgcrypto and AES_ENCRYPT

By admin May 5, 2026

Don't let user data leak in plain-text. Learn how to use pgcrypto and AES_ENCRYPT to encrypt sensitive data according to modern security standards.

Database

Mastering CockroachDB: When a ‘Resilient’ SQL Database Helps You Sleep Better

By admin May 1, 2026

A 2 AM system crash is every developer's nightmare. Discover how to deploy CockroachDB—a distributed SQL database with self-healing capabilities for absolute uptime.

Database

Getting Started with ClickHouse: A High-Performance OLAP Database for Large-Scale Analytics

By admin April 28, 2026

ClickHouse is a columnar OLAP database that lets you analyze hundreds of millions of rows in seconds. This guide covers installation on Linux, choosing the right table engine, importing real-world data, and production deployment tips for DevOps teams.

Database

PostgreSQL FDW: The Ultimate Trick to Query MySQL, MongoDB, and CSV Directly Without ETL

By admin April 28, 2026

Forget complex ETL! A detailed guide on using PostgreSQL FDW to query MySQL, MongoDB, and CSV directly. Speed up multi-source data processing with just a few SQL lines.