MySQL Performance: MySQL => Are binlogs required for InnoDB Recovery?

Members

Help

Home

Home » Performance » MySQL » Are binlogs required for InnoDB Recovery?

Show: Today's Messages :: Show Polls :: Message Navigator

Are binlogs required for InnoDB Recovery? [message #3621]

Fri, 10 October 2008 11:51

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

Re: Are binlogs required for InnoDB Recovery? [message #3654 is a reply to message #3621 ]

Mon, 27 October 2008 01:21

debug
Messages: 132
Registered: March 2008

Senior Member

Binlogs can help to recover database to latest version.
If you restore from archive done week ago - you will get an outdated database. But if then you execute binlogs which were written during this week - you will get up-to-date database.

Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting

Report message to a moderator

Previous Topic:	Advice
Next Topic:	How is the relay log supposed to work?

Goto Forum:

-=] Back to Top [=-

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

]

Current Time: Fri Jul 10 01:40:58 EDT 2009

Total time taken to generate the page: 0.02821 seconds

.:: Contact :: Home ::.

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.