Stream MySQL binlogs to S3 for offsite PITR: mysqlbinlog --read-from-remote-server --raw --stop-never, then aws s3 cp with checksum verify. #mysql #binlog #s3 https://www.valtersit.com/vault/continuous-binlog-archiving-to-s3-for-offsite-pitr-1ad773/
#binlog — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #binlog, aggregated by home.social.
-
Replay binlogs by GTID instead of file/position with mysqlbinlog --include-gtids/--exclude-gtids. Survives failovers and topology changes. MySQL 8.0.17+: #mysql #gtid #binlog https://www.valtersit.com/vault/gtidbased-pointintime-replay-with-mysqlbinlog-c09218/
-
Filter binlog events by schema and table with mysqlbinlog --database and --rewrite-db, pipe only matching row events into a temp restore DB. Surgical PITR for one table, no full restore. #mysql #binlog #pitr https://www.valtersit.com/vault/extract-single-table-from-binlog-for-surgical-pitr-b6cb02/