Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » Are binlogs required for InnoDB Recovery?
Are binlogs required for InnoDB Recovery? [message #3621] Fri, 10 October 2008 11:51 Go to previous message
haaseg is currently offline haaseg
Messages: 8
Registered: November 2007
Location: Maryland
Junior Member
I was under the impression that the binlogs were required for InnoDB recovery, but in testing, I have successfully recovered on a different server using an lvm snapshot without them (bin-logs are on a separate lv).

The only thing I can think of is that there are no running transactions due to FLUSH TABLES WITH READ LOCK so no rollback has to occur during recovery. Either that or I've just gotten crazy luck 3 times in a row now.
Report message to a moderator
[Message index]

Read Message
Read Message
Previous Topic:Advice
Next Topic:How is the relay log supposed to work?
Goto Forum:

  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 10 00:33:34 EDT 2009

Total time taken to generate the page: 0.00826 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.