Live Migration with pgcopydb: Zero Downtime Thanks to Follow Mode
Learn how to use pgcopydb's --follow option and logical replication slots to achieve near-zero downtime live migrations of PostgreSQL databases.
Category Production
Technical Architecture and Parallelization in pgcopydb
A deep dive into pgcopydb's multi-process architecture, table chunking features, and parallel index rebuilding capabilities for faster migrations.
pgcopydb: Redefining PostgreSQL Database Migration
Discover pgcopydb, a high-performance open-source tool by Dimitri Fontaine that revolutionizes PostgreSQL database migration by overcoming the limits of pg_dump.
Hardening Database Audits: Security and Data Protection Improvements in MySQLTuner
Security auditing tools occupy a unique position in an organization’s security posture. Because they require elevated privileges to read system variables, query databases, and analyze log files, these tools themselves must be highly secure. A vulnerability in an auditing utility…
What’s New in MySQLTuner v2.8.44: A Deep Dive into the Latest 3 Months of Performance Tuning Evolution
MySQLTuner is one of the most widely trusted open-source command-line utilities for auditing and optimizing database servers. Written in Perl, its simplicity, zero external dependency design (by default), and direct, actionable advice have made it a staple in the toolkit…
Mastering the MySQL Client on Linux: Boost Your Command-Line Performance!
The MySQL command-line client on Linux is a powerful tool for interacting with your databases directly from the terminal. Whether you are a database administrator or a developer, mastering this tool can significantly improve your management and development workflows. 🚀…