MySQL Forums
Forum List  »  InnoDB

Re: Power outage db down - need help
Posted by: Bob Bankay
Date: February 24, 2005 11:57AM

Hi Heikki,

Thanks for responding. It is still a bit crazy here and I forgot to say this previously.

Forgot to mention the we are using mysql 4.0.23 on the crashed Opteron and 4.0.13 on the slave replica.

Here is a 3rd recovery option:
The replica server appears to be coming up and was 30 minutes behind. If is does come up and we can get the master to stay up while serving binlog to the slave....then we could bring the slave up to a point within 1 second (or less) of the crash. Is this doable while we are in this state?

We should probably do a full backup of the replica before attempting anything like this; there may be master binlog corruption that could cause a slave error.

Options: ReplyQuote


Subject
Views
Written By
Posted
6259
February 23, 2005 07:17PM
2891
February 24, 2005 10:09AM
2853
February 24, 2005 11:26AM
Re: Power outage db down - need help
2657
February 24, 2005 11:57AM
2659
February 24, 2005 07:09PM
3063
February 24, 2005 07:54PM
3341
February 25, 2005 03:30AM
2664
February 25, 2005 01:46PM


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.