After I came over ZFS and started reading about it's self healing capabilities I started to wonder about what other technologies which also use this. What came to my mind first was that all serious databases should have this.
So I started googling to find the answers.
The big commercial databases like Oracle, DB2, MS Sql Server claims to support self healing.
For Windows / SQL server I found this
http://www.infoworld.com/d/networking/windows-server-2008-windows-also-rises-286
and this
http://technet.microsoft.com/en-us/library/cc771388(WS.10).aspx
It says:
As for DB2 v9 the information was very sparse
http://www.ibm.com/developerworks/data/library/techarticle/dm-0606ahuja2/
It claims to have self-healing capabilities, but how does it work?
For Oracle I found this, quite detailed
http://www.dba-oracle.com/oracle11g/oracle11g_healthchecks.htm
PostgreSQL does not have self-healing according to this: http://www.xaprb.com/blog/2010/02/0...inst-partial-page-writes-and-data-corruption/
But it can be used with ZFS to get the self healing feature.
So I started googling to find the answers.
The big commercial databases like Oracle, DB2, MS Sql Server claims to support self healing.
For Windows / SQL server I found this
http://www.infoworld.com/d/networking/windows-server-2008-windows-also-rises-286
and this
http://technet.microsoft.com/en-us/library/cc771388(WS.10).aspx
It says:
Sounds quite similar to ZFS, but is it?Self-healing NTFS repairs file system corruption in the background, without interrupting service.
As for DB2 v9 the information was very sparse
http://www.ibm.com/developerworks/data/library/techarticle/dm-0606ahuja2/
It claims to have self-healing capabilities, but how does it work?
For Oracle I found this, quite detailed
http://www.dba-oracle.com/oracle11g/oracle11g_healthchecks.htm
And listed as one of the main features that came with Oracle 11g is self-healing. So my guess is that Oracle has self healing capabilities similar to ZFS?Data Block Integrity: detects disk image block corruptions such as checksum failures, head/tail mismatch, and logical inconsistencies within the block.
PostgreSQL does not have self-healing according to this: http://www.xaprb.com/blog/2010/02/0...inst-partial-page-writes-and-data-corruption/
But it can be used with ZFS to get the self healing feature.