MySQL Binlog Automatic Backups Made Easy

Binlog backups allow you to recover and / or undo individual statements which have happened after your last full MySQL dump backup.

Binlog backups allow you to recover and / or undo individual statements which have happened after your last full mysqldump backup.

A MySQL Binlog Backup Job will configure an dedicated remote container that will connect to your server and monitor the binlogs.

Any changes to your database will be replicated in real time to the remote container.

The replicated log files will then be uploaded to the Archive Location at an interval you configure.

A statement omission recovery allows you to search and sort the statements from the binlogs you selected. You can flag any statements you'd like to omit from the patch you would like to replay on your database.

This recovery method will create a patch containing all statements in the binlogs you selected, minus any statements you selected for omission.

Ottomatik allows you to execute a Point In Time recovery with granularity up to the second.

Additionally you can have full visibility into the statements that are associated with that particular time.

The internals of MySQL’s binary logging system keeps track of statements in a log with a "log position". Each statement has a distinct and unique start and end position.

There are some advanced use-cases, often involving database replication, where you may know a particular binlog position you'd want to restore to. This functionality is similar to a Point In Time recovery, and only takes a couple clicks.