Traceroute: Not so hardI’m sure most of you might have already heard about traceroute. If not, it’s a command line tool generally used to trace the path of the packet over the network. I recently came across the implementation detail of it, and it’s surprisingly simple to ...Oct 4, 2025·6 min read·42
Schema change without locking.Performing schema changes on production databases comes with significant overhead, such as locking entire tables and potentially causing replication lag in master-slave architectures. For MySQL and its variants, there's a powerful tool that mitigates...Sep 13, 2024·2 min read·69
Character Vs ByteThe "characters vs bytes bug" usually refers to an issue that arises in programming when there is confusion between the number of characters and the number of bytes in a string. This is a common issue in languages and systems where the encoding of ch...Jul 29, 2024·3 min read·102
Zero, Zero, What Are You? A Deep Dive into Type ConversionAlmost every computer uses a text input buffer for handling user input, providing feasibility and wide-ranging support across various applications. However, it may not be immediately apparent how the characters we type are converted internally for nu...Jul 24, 2024·3 min read·64
Docker Security ProfileRecently I was diagnosing a frequent crash of my xtrabackup container which is in a docker network along with the MySQL container. After digging through logs for a very good minute, I came across this error: mbind: Operation not permitted mbind: Op...Jul 2, 2024·3 min read·102
Consistent HashingIn distributed systems, efficiently distributing data or load across multiple servers is critical. Two common methods for achieving this are Simple Hashing and Consistent Hashing. Let's look into how each method works and compare their advantages and...May 31, 2024·3 min read·88
How To: Add Custom Metric Panel in PMMCustom Metrics are defined in a file deployed on each server that we are monitoring. To add the custom metrics navigate to the following DIR: For MySQL: /usr/local/percona/pmm2/collectors/custom-queries/mysql For PostgreSQL: /usr/local/percona/pm...Nov 25, 2023·2 min read·236
