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.
Tag Open Source
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.
Modernizing Legacy Perl: How MySQLTuner Reached 92% Test Coverage and Zero-Dependency Autonomy
Maintaining a single-file, zero-dependency legacy script is one of the hardest challenges in software engineering. Over time, codebases written in languages like Perl can become difficult to test, prone to regressions, and challenging for new contributors to navigate. However, the…
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…
Open Source Audit plugins from MySQL 5.7/MySQL 8.0
Conclusion first MySQL Oracle since 5.7.33 doesn’t get any open source auditing solution I have tried several options: Create a VirtualBox with Vagrant Useful links Creating a Centos/7 virtual server Prepare Virtual machine for MySQL 5.7 Install compilation environment Download…