MySQL Binlog Backup

Real-time backup, allowing you to re-write the history of your database.

See our how-to video guides

  • How to setup
Browser Image

How it works?

Secure your data. 14 days free. No credit card required.

Binlogs Keep
The binlogs keep a record of all statements that made any changes to your database in the order they occurred.

This is an important difference from a mysqldump backup, which represents a full "Logical Backup" of your database structure and content at the time of the backup.

Binlog Backups
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
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.

Multiple recovery options

Secure your data. 14 days free. No credit card required.

Statement
Statement Omission Recovery

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.

Point
Point In Time Recovery

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.

Binlog Position
Binlog Position Recovery

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.

Try ottomatik today. Secure your data.

14 days free. No credit card required.