Database – Page 2 – ITFROMZERO

How to Use MySQLTuner to Diagnose and Quickly Optimize MySQL Server Configuration

By admin June 13, 2026

MySQLTuner is a Perl script that analyzes your running MySQL configuration and delivers specific optimization recommendations in just a few minutes. This guide walks through installation, interpreting the output, and applying key settings like innodb_buffer_pool_size and thread_cache_size in practice.

MySQL

Dockerize MySQL for Dev Environments: Using Init Scripts to Auto-Initialize Schema and Sample Data

By admin June 13, 2026

A guide to Dockerizing MySQL with init scripts — automatically creating schema and seed data when the container first starts. Set up in 5 minutes, giving the whole team a consistent environment with zero manual steps.

Database

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.