Database – ITFROMZERO – Share tobe shared!

KeyDB: The Multi-Threaded Fork That Supercharges Redis on Multi-Core Servers

By admin June 1, 2026

Is your Redis CPU-bound? Discover KeyDB—a multi-threaded fork that boosts performance 5x and offers powerful Active Replication for large-scale systems.

MySQL

MySQL 8 Dual Password: Smooth Password Rotation Without Downtime

By admin June 1, 2026

Changing MySQL passwords without triggering Access Denied errors? Explore the Dual Password feature in MySQL 8 to keep your system online 24/7 during maintenance.

Database

Mastering Prisma ORM with Node.js & TypeScript: Say Goodbye to Type-safety and Migration Woes

By admin May 30, 2026

Upgrade your Node.js workflow with Prisma ORM. A detailed guide from setup to advanced techniques for absolute type-safe queries and professional database management.

Database

Installing FerretDB: How to Run MongoDB on PostgreSQL to Simplify Your Infrastructure

By admin May 30, 2026

Install FerretDB to run MongoDB on PostgreSQL: The perfect solution to save resources, simplify DevOps workflows, and escape MongoDB SSPL licensing hurdles.

Centos

Installing PostgreSQL 16 on CentOS Stream 9: A Survival Guide for Production Environments

By admin May 27, 2026

A production-ready guide for installing PostgreSQL 16 on CentOS Stream 9. This article focuses on SELinux, Firewalld security, and practical performance tuning tips.

Fedora

Installing and Configuring MariaDB on Fedora Server: Production Database Deployment with SELinux and firewalld

By admin May 22, 2026

A complete guide to getting MariaDB production-ready on Fedora Server: securing the installation with mysql_secure_installation, opening ports correctly with firewalld rich rules, handling SELinux context for custom datadirs, and debugging refused connections. Includes basic performance tuning and a final production checklist.

Database

SurrealDB Tutorial: A Database to Replace PostgreSQL, Redis, and Neo4j?

By admin May 20, 2026

Forget about installing Postgres, Redis, and Neo4j all at once. Discover SurrealDB - a Multi-model database written in Rust that optimizes real-time applications and simplifies backend architecture.

Database

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.