Re: Is ECC RAM necessary for MySQL server

2011-12-31 Thread Wm Mussatto
On Sat, December 31, 2011 05:14, Claudio Nanni wrote: > Ryan, > My opinion here. > Any write to memory can go wrong, > OS , MySQL , Storage engines, client library and so on. > Innodb has some advanced mechanism for ACID compliance like the double > write buffer but these are mostly to assure durab

Re: Is ECC RAM necessary for MySQL server

2011-12-31 Thread Claudio Nanni
Ryan, My opinion here. Any write to memory can go wrong, OS , MySQL , Storage engines, client library and so on. Innodb has some advanced mechanism for ACID compliance like the double write buffer but these are mostly to assure durability. Memory failure although not so frequent can still, in my op

Re: Is ECC RAM necessary for MySQL server

2011-12-31 Thread Reindl Harald
Am 31.12.2011 14:03, schrieb Ryan Chan: > Assume I am using InnoDB, which is ACID compliant. > > Do I still need to use ECC RAM, in order to make sure there is no > chance of data corruption due data write? define "necessary" what has this to do with InnoDB / ACID if the underlying hardware ma