Re: Write cache
I found this:
=============
It is worth noting that if you are using InnoDB, and both the log and datafiles are backup-able (is that a word?) in a single snapshot by LVM, then you *don't* need to lock the tables first.
Since LVM takes a consistent snapshot, InnoDB will be able to recover, just as if there was a system crash, from the LVM backup when restored. It even tells you the binary log coordinates to recover from during the crash recovery for replaying the binary logs.
=============
If we have a battery-backed-up RAID controller, it would write the unwritten data at boot, before (or in the early process of) booting the OS, so it would be fine right?
Subject
Views
Written By
Posted
3126
July 11, 2007 02:50PM
Re: Write cache
2131
July 12, 2007 05:22AM
2017
July 12, 2007 12:01PM
2199
July 18, 2007 02:05PM
7589
July 18, 2007 02:02PM
1778
November 14, 2007 09:53AM
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.