When deciding on your backup strategy, one of the key components for Point In Time Recovery (PITR) will be the binary logs. Thankfully, the mysqlbinlog command allows you to easily take binary log backups, including those that would otherwise be encrypted on disk using encrypt_binlog=ON.
When
mysqlbinlog
is used with
--raw --read-from-remote-server --stop-never --verify-binlog-checksum
then it will retrieve binary logs from whichever master it is pointed to, and store …
[Read more]