summaryrefslogtreecommitdiff
path: root/wiki/mysql
diff options
context:
space:
mode:
authorMorgan Tocker <tocker@gmail.com>2013-10-11 23:08:28 -0400
committerMorgan Tocker <tocker@gmail.com>2013-10-11 23:08:28 -0400
commit8fb858f63d6308ff4a0dbc1737aa9191b6da5234 (patch)
tree82378fecf48802632afe2c248300edd68b428799 /wiki/mysql
parent6a49916e89d10e9c7e24593bb3171f40280d78b3 (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/mysql')
-rw-r--r--wiki/mysql/choose-something-else.md13
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