Note: Please go to docs.rightscale.com to access the current RightScale documentation set. Also, feel free to Chat with us!
Home > ServerTemplates > Archive > Pre-11H1 > MySQL-S3 > Database Manager for MySQL-S3 Runbook > MySQL-S3 Problem Scenarios > The Master-DB instance failed

The Master-DB instance failed

Recovering from a master DB failure is similar to having no running DB instances with one major and important difference, which is that we use the data from the existing slave as the DB content. This ensures minimal data loss and avoids having to restore the DB data from an external source, which can take a substantial amount of time.

Verification: How do I know my system is in this situation?

  1. Access the "active instances" (Manage -> Servers)
  2. Verify that none of the running instances are derived from the master or slave templates (i.e., click on each instance and check that its template field is not Master MySQL v? or Slave MySQL v?).

Required actions: What recipes should I apply to solve the situation?

  1. Promote slave DB to master DB
  2. Launch a new slave-DB
  3. Initialize slave DB from master DB
You must to post a comment.
Last modified
21:34, 16 May 2013

Tags

Classifications

This page has no classifications.

Announcements

None

Powered by MindTouch ®

© 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.