Database Archives - Page 7 of 13 - ITFROMZERO

ArangoDB: The All-in-One Solution Replacing MongoDB, Redis, and Neo4j

By IT From Zero June 18, 2026

ArangoDB is a Native Multi-model solution that replaces MongoDB, Redis, and Neo4j with a single engine. Check out our guide to installing and optimizing RocksDB to speed up your system.

MySQL

MySQL Semi-synchronous Replication: Zero Data Loss Without Group Replication

By IT From Zero June 13, 2026

MySQL Semi-synchronous Replication ensures zero data loss for production databases by requiring at least one slave to acknowledge receipt of the binlog before the master commits. This article compares async, semi-sync, and Group Replication, analyzes when each is appropriate, and provides a step-by-step deployment guide from enabling the plugin to real-world monitoring.

MySQL

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

By IT From Zero 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 IT From Zero 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 IT From Zero 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 IT From Zero 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 IT From Zero 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 IT From Zero 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 IT From Zero 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 IT From Zero 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.