MySQL Forums
Forum List  »  InnoDB

Re: Power outage db down - crisis over
Posted by: Bob Bankay
Date: March 01, 2005 04:31PM


Thanks for your several replies.

At one point last week we decided to restore the Opteron master from the slave Sparc. Mysqld was getting lost every time it tried to do anything with the ibdata files on the master. So we re-created the ibdata and log files.

The data migration went as well as could be expected. We lost about 30 minutes worth of processing (thank goodness we are dealing with scientific data and not cash). The lost data will be reprocessed and we have invested in intelligent UPSs which can trigger automatic shutdown scripts. We expect to have 5 minutes survivabilty and are setting our innodb dirty_buffer_pct to make it around 105K pages(45%). This can be flushed in about 3 minutes at shutdown, so it should provide enough margin. Right now this limit will not impact performance.

This week we were able to prove the worth of our work since we had another power outage 36 hours ago. And this time there was no crisis or data loss. Lesson learnt.

PS I was interested in the comment about mounting the disks in Linux, setting hdparam to not cache. I will verify with my admin guy that disk mounting is set for no caching in the Opteron.

Bob Bankay

Options: ReplyQuote

Written By
February 23, 2005 07:17PM
February 24, 2005 10:09AM
February 24, 2005 11:26AM
February 24, 2005 11:57AM
February 24, 2005 07:09PM
February 24, 2005 07:54PM
February 25, 2005 03:30AM
February 25, 2005 01:46PM
Re: Power outage db down - crisis over
March 01, 2005 04:31PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.