Database Archives - Page 11 of 12 - ITFROMZERO

MySQL Full-Text Search: The Secret to Super-Fast and Accurate Search for Your Applications

By IT From Zero March 11, 2026

Search functionality is vital for many applications, but `LIKE` often leads to poor performance. This article guides you on using MySQL Full-Text Search to build super-fast, effective search with relevance ranking directly within your database.

Database

Optimizing PostgreSQL Queries with EXPLAIN ANALYZE: Analyzing and Improving Query Performance

By IT From Zero March 8, 2026

Learn how to use EXPLAIN ANALYZE in PostgreSQL to read execution plans, analyze slow queries, and optimize performance with the right indexes. This guide goes from a 5-minute quick start to advanced techniques like covering indexes, composite indexes, and auto_explain.

Database

Setting Up and Configuring Redis Sentinel: High Availability for Redis in Production

By IT From Zero March 7, 2026

A practical guide to setting up a 3-node Redis Sentinel cluster for high availability in production: configuring master-replica replication, automatic failover, connecting applications through Sentinel, and common operational pitfalls.

MySQL

MySQL Database Backup and Restore: Practical Lessons from Production

By IT From Zero March 6, 2026

A practical guide to MySQL database backup and restore based on real experience with a 50GB production database. Compares mysqldump, mysqlpump, and XtraBackup, with automation scripts and the 3-2-1 backup strategy.

Database

PostgreSQL Backup Done Right: Strategy, Automation, and Real-World Restore Testing

By IT From Zero March 4, 2026

PostgreSQL backup isn't just about running pg_dump and walking away — the more critical part is regular restore testing and monitoring backup file integrity. This post shares a battle-tested workflow with automation scripts, a comparison of pg_dump vs pg_basebackup, and a complete checklist to make sure your backups actually work when it counts.

MySQL

MySQL User Management and Access Control: Tips & Tricks from Real-World Experience

By IT From Zero March 3, 2026

A practical guide to MySQL user management and access control following the Principle of Least Privilege — creating users, managing GRANT/REVOKE permissions, and setting up a solid foundation for production projects. Real-world tips and tricks to protect your database from unnecessary risk.

Database

SQL vs NoSQL: When to Choose Each for Your Project

By IT From Zero March 2, 2026

SQL and NoSQL aren't competitors — each solves a different problem. This article breaks down when to choose SQL, when to use NoSQL, and how to combine both in real-world systems.

MySQL

MySQL JSON Data Type: Store Flexible Data Without Changing Your Schema

By IT From Zero March 1, 2026

MySQL JSON data type (available since MySQL 5.7.8) lets you store flexible data directly in a SQL column without changing your schema every time. This article walks through practical operations: creating tables, inserting data, querying with JSON_EXTRACT, updating with JSON_SET, and optimizing performance with generated columns — plus real-world experience on when to use it and when to avoid it.

MySQL

MySQL Master-Slave Replication Setup: From Real Incidents to Solutions

By IT From Zero March 1, 2026

A complete guide to MySQL Master-Slave Replication from start to finish, solving database overload and single point of failure. Covers each step from configuring Binary Log and creating the replication user to connecting and verifying the Slave.

Database

Optimizing PostgreSQL Performance with PgBouncer: Connection Pooling in Production

By IT From Zero February 28, 2026

A guide to installing and configuring PgBouncer to address connection overhead in PostgreSQL. Real-world experience after 6 months in production: server connections reduced from 180 to 25, API response time improved from 800ms to under 300ms.