Ottomatik MySQL Binlog Backups allow you to backup the MySQL Binlogs (a.k.a "Binary Logs") in real time and upload them to your Amazon S3 archive.
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 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.
Get started quickly by storing your backup files on our built-in storage space, or bring your own AWS S3 account.
Select how many backup copies to keep and automatically rotate files after each job completes.
Add your own S3 folder organization at the backup job level.
Ottomatik’s MySQL binlog backup operates on the same technology as master-slave database replication, however replication to a slave is not an effective backup strategy. Any destructive or erroneous statement executed on a master will immediately be replicated to the slaves, leaving both in a degraded state.
The binlogs are a record of the statements themselves NOT the data transformed by the execution of those statements. Therefore they can be "replayed" on a data set to bring it up to a particular point in time. Or perhaps you want to replay all statements except one that was an error, and distructive.
With the combination of Ottomatik’s mysqldump and binlog backups you can have a database backup strategy with a real-time recovery point. Further, through the use of Ottomatik’s MySQL Binlog Recovery feature, the logistics of accessing, parsing and replaying Logical Backups and binlogs is point and click.