Performing scheduled MySQL database backups

In this recipe, you will learn how to perform a scheduled backup of your MySQL database and upload it to Amazon S3.

Getting ready

To complete this recipe, you will need an application with a MySQL cartridge. Please refer to the Adding a MySQL cartridge to your application recipe of this chapter to learn how to install the MySQL cartridge. Also, you need to have an Amazon AWS account. Visit http://aws.amazon.com/, and sign up for a new account if you don't have one already.

How to do it…

Follow these steps to schedule a daily backup of your MySQL cartridge:

  1. Go to https://console.aws.amazon.com/s3/home, and create a new bucket to store your database backups.
  2. Add a cron cartridge to your application by running ...

Get OpenShift Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial