Note: Please go to to access the current RightScale documentation set. Also, feel free to Chat with us!
Home > ServerTemplates > Archive > 11H1 > Runbooks > Database Manager for MySQL Stripe Runbook > MySQL Stripe Problem Scenarios > The Master-DB is corrupted

The Master-DB is corrupted

There are two main ways that the data on the Master-DB can become corrupted. 

  1. Data corruption due to the modification of the data stored on the disk (not due to SQL queries). For example, data mutations due to disk malfunctions, filesystem errors, etc.
  2. Data corruption due to modifications of the database caused by unwanted or incorrect SQL statements. For example, a bug in an application might "destroy/corrupt" the contents of the database.

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

If you think that your database is corrupted, you have probably already noticed odd behavior that's probably related to your database.  If it's disk or filesystem corruption you'll probably see error messages in the instance log. If the corruption is  caused by a bug in the application, you'll probably notice that data is missing or get application errors complaining about missing relationships, records not found, or failed transactions.

The plan of action changes dramatically depending on the two cases:

Case A - Only my master DB is corrupted

When the data corruption is local to the Master-DB such as disk errors, filesystem errors, etc., it's likely that the problem does not affect the Slave-DB instance.  In this case, you can use the Slave-DB for recovery since it has the most recent copy of the non-corrupted data.  In this situation, the recovery is the same as when The Master-DB instance failed.

Required actions: What scripts should I run to solve the situation?

  1. Promote Slave-DB to Master-DB
  2. Launch a new Slave-DB

Case B - Data on both master and slave DB is corrupted

See Both the master and slave are corrupted.

You must to post a comment.
Last modified
21:33, 16 May 2013



This page has no classifications.



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