Logged in: Logged in as: Log in
Register
call_us_today.gif

subscribe_rss.gif
Search:
Page last modified 19:56, 20 Nov 2008 by deano
RightScale Support Wiki > References > RightScale > RightScale Dashboard > General Topics > MySQL Databases > Manager for MySQL-S3 Runbook > MySQL-S3 Problem Scenarios > The Master-DB instance failed
Redirected from 2. References/Manager for MySQL Runbook/MySQL Problem Scenarios/Scenario 2 - The master DB instance has 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

 

 

Tag page
What links here

Files 0

Attach file or image
 

Images 0

 
You must login to post a comment.
Powered by MindTouch Deki Open Source Edition v.8.08.1a