Discover the latest features in MySQLTuner v2.8.44! Learn about the new zero-dependency HTML reports, advanced SQL dump compression, and core-aware cache optimization recommendations.
Tag: Open Source
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.
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 recent development cycle of MySQLTuner-perl (v2.8.41 to v2.8.44) in mid-2026 demonstrates that legacy tools can […]
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 of Database Administrators (DBAs), DevOps engineers, and system administrators worldwide. In the last three months, […]
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 MySQL 5.7.40 source code Adding code source from MySQL 5.7 AWS audit plugin Compile source […]