Database – ITFROMZERO – Share tobe shared!

PostgreSQL Full-Text Search: High-Performance Vietnamese Search Without Elasticsearch

By admin May 19, 2026

Don't rush to install Elasticsearch! A detailed guide on building high-speed, accurate Vietnamese search directly in PostgreSQL using only tsvector and GIN Index.

Database

Deploying MariaDB Galera Cluster: A Multi-master High Availability Solution for Production

By admin May 16, 2026

A detailed guide on setting up a 3-node MariaDB Galera Cluster. This synchronous multi-master solution ensures your database system stays online and secure against hardware failures.

Database

Meilisearch: A “Lightning-Fast” Search Engine to Replace Elasticsearch for Small and Mid-sized Projects

By admin May 16, 2026

Meilisearch is a high-speed search solution and a perfect alternative to Elasticsearch for small to medium websites. This article covers setup, configuration, and practical insights from 6 months of production use.

Database

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.