Add your own S3 folder organization at the backup job level.
Setup an individual backup job for each database for back up all-databases in one job.
Choose to stream file uploads to Amazon S3 and bypass writing any data to your local hard drive.
Select how many backup copies to keep and automatically rotate files after each job completes.
Get started quickly by storing your backup files on our built-in storage space, or bring your own AWS S3 account.
Configure the backup job with multiple options of how to export your data and structure.
If you need to backup a large database, or a database for a very high traffic website, it may be unacceptable to have a read-lock on tables while the backup is processed. In these situations Ottomatik’s mysqldump zero-downtime options can help. With this feature you can enable a "quick" option for large tables, skip locking and do the entire operation in a single transaction to ensure the backup’s consistency.
Depending on how your applications use the database, backing up your structure and data may not be enough. Ottomatik’s mysqldump job configuration allows you to include database functions, triggers and stored procedures (1) in your backup as well. You can even include relevant data from the MySQL Event Scheduler (2) if your application and database is using it.
If you are making backups of the MySQL Binlogs (and you should be), you will typically want to flush, or start a new binlog after each mysqldump operation. This will give you a complete "Logical Backup" of your database in the mysqldump file, and a transactional log of all changes that occurred after that via the new binlog. This configuration is a simple checkbox when setting up a mysqldump backup on Ottomatik.
Sometimes once you have a mysqldump backup file, it can be a pain to get that file physically on a server and perform the correct restore sequence via the command line. Using the point-and-click restore feature you can easily restore any backup in 3 clicks. You can even restore to a different server and provide alternative connection credentials if you like.