MySQL Backup and Recovery: A Guide to Logical and Physical Backups with Modern Architectures
Physical vs. Logical Backups: When to Choose Which
Physical backups operate directly on database files, copying raw disk data to a backup location. This approach delivers fast recovery times but incurs higher storage costs. The xtrabackup tool (XBK) from Percona is the primary open-source solution, along with MySQL Enterprise Backup for license ...
Posted on Mon, 28 Sep 2026 16:35:09 +0000 by coldwerturkey
Handling Character Encoding Issues When Using mysqlbinlog with binlog_format=ROW
In MySQL, the binary log format (binlog_format) can be set to STATEMENT, ROW, or MIXED. The ROW format records every row change individually, which porvides higheer consistency and reliability. However, when using the mysqlbinlog utility to inspect a binary log written in ROW format, the output may appear garbled because the tool does not autom ...
Posted on Tue, 19 May 2026 16:03:12 +0000 by anonymousdude