In this chapter, you will be introduced to issues related to hardware and software failure. Even expensive hardware is far from perfect, and it may fail from time to time. Troubles could occur in the form of failing memory, broken hard drives, or damaged filesystems, kernel-related issues and so on. In this chapter, some of the most common troubles will be covered.
Here are some of the important topics we will cover:
Checksums—Preventing silent corruption
Zero out damaged pages
Dealing with index corruption
Dumping single pages
Resetting the transaction log
Power out related issues