Book Image

OpenShift Cookbook

By : Shekhar Gulati
Book Image

OpenShift Cookbook

By: Shekhar Gulati

Overview of this book

Table of Contents (19 chapters)
OpenShift Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Running OpenShift on a Virtual Machine
Index

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 the following command:

    $ rhc add-cartridge cron --app myapp
    
  3. SSH into the application gear, and download the s3-bash utility in $OPENSHIFT_DATA_DIR. Then, extract it to the s3-bash directory by running the following commands:

    $ rhc ssh --app myapp...