Home > Tutorials > Amazon Web Services (AWS) > Standard Edition Deployment > Database Setups > MySQL Database Setups

MySQL Database Setups

Table of Contents

Warning: This page contains outdated or otherwise non-applicable product information, and has been deprecated. Please use the RightScale Support Portal's search feature to search for up-to-date information on this topic.

 


There are two different ways of setting up a redundant MySQL database on Amazon EC2.  In both cases, there will be a Master-DB and Slave-DB with replication for failover and recovery.  The core difference between each setup is how the backups are saved.  See Overview of MySQL-EBS Setups for more details about the various types of MySQL database setups.

WARNING!  Before you set up your Master/Slave databases, you should complete each step of the Deployment Setup.  Each database tutorial assumes that you have already setup your SSH keys, security groups, etc.

Below are the three main types of MySQL database setups:

  • MySQL-S3 - Backups of the database are saved directly to S3 as *.tar files.  ("MySQL Bootstrap" and "MySQL Additional" ServerTemplates)
  • MySQL-EBS (no Striping) - Backups of the database are saved as EBS snapshots to S3. 
  • MySQL-EBS (w/ Striping) - Backups of the database are saved as a set of EBS snapshots to S3.

 

diag-MySQL_Setup_Diagrams-v2.png

You must to post a comment.
Last Modified
09:07, 31 Jul 2013

Page Rating

Was this article helpful?

Tags


Announcements

UCP Migration

Glossary | 用語용어 Site Map | Site Help Community Corporate Site Get Support Dashboard Login
Doc Feedback Product Feedback Resources MultiCloud Marketplace Forums

Dashboard Status


© 2006-2014 RightScale, Inc. All rights reserved.
RightScale is a registered trademark of RightScale, Inc. All other products and services may be trademarks or servicemarks of their respective owners.