diff options
| author | Morgan Tocker <tocker@gmail.com> | 2013-10-11 23:08:28 -0400 |
|---|---|---|
| committer | Morgan Tocker <tocker@gmail.com> | 2013-10-11 23:08:28 -0400 |
| commit | 8fb858f63d6308ff4a0dbc1737aa9191b6da5234 (patch) | |
| tree | 82378fecf48802632afe2c248300edd68b428799 /wiki | |
| parent | 6a49916e89d10e9c7e24593bb3171f40280d78b3 (diff) | |
I tried to rewrite the 'preserving data' section introduction, since I think InnoDB does a good job here with page checksums / crash recovery / doublewrite buffer, and is now the default.
Other database systems (Oracle) have the hardware resilience features you are describing, like mirroring, but InnoDB has made an intentional choice not to offer this functionality directly.
Diffstat (limited to 'wiki')
| -rw-r--r-- | wiki/mysql/choose-something-else.md | 13 |
1 files changed, 10 insertions, 3 deletions
diff --git a/wiki/mysql/choose-something-else.md b/wiki/mysql/choose-something-else.md index fb9b259..811569a 100644 --- a/wiki/mysql/choose-something-else.md +++ b/wiki/mysql/choose-something-else.md @@ -102,9 +102,16 @@ familiar with other SQL implementations). ### Preserving Data ... against unexpected changes: like most disk-backed storage systems, MySQL -is as reliable as the disks and filesystems its data lives on. MySQL makes -very little effort to do its own storage validation and error correction, but -this is a limitation shared with many, _many_ other systems. +is as reliable as the disks and filesystems its data lives on. MySQL provides +no additional functionality in terms of mirroring or hardware failure tolerance +(such as [Oracle ASM](http://en.wikipedia.org/wiki/Automatic_Storage_Management)). +However this is a limitation shared with many, _many_ other systems. + +When using the InnoDB storage engine (default since MySQL 5.5), MySQL maintains page +checksums in order to detect corruption caused by underlying storage. However, +many third-party software applications, as sell as users upgrading +from earlier versions of MySQL may be using MyISAM, which will frequently corrupt +data files on inproper shutdown. The implicit conversion rules that bite when storing data also bite when asking MySQL to modify data - my favourite example being a fat-fingered |
