home.social

#binlog — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #binlog, aggregated by home.social.

  1. 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 valtersit.com/vault/continuous

  2. 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 valtersit.com/vault/gtidbased-

  3. 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 valtersit.com/vault/extract-si

Share on Mastodon

Enter the server where you have an account.