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...
The "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...
Almost 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...
Recently 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...
In 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...
Custom 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...
