Restoring MySQL replica from source
Restoring replica from master
Mar 24, 20252 min read53
Command Palette
Search for a command to run...
#mysql
Articles tagged with #mysql
pt-table-sync
I recently had a situation when a lot of rows from one of our replicas was missing.One of the solutions that came in mind is to use the snapshot of the source and reconfigure it as replica. While this would have worked, it seemed like an extreme appr...
Mar 17, 20252 min read52
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, 20242 min read69
Docker Security Profile
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...
Jul 2, 20243 min read102