Re: Is ECC RAM necessary for MySQL server
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 durability. Memory failure > although not so frequent can still, in my opinion, corrupt anything > included Innodb buffers. > I would like the opinion of some other Innodb gurus. > Happy new year. > Claudio > On Dec 31, 2011 2:04 PM, "Ryan Chan" wrote: > >> 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? >> >> Thanks. ECC memory helps ensure both the program and the data is correct. If you are running 24/7 operation rather than a test system which will be continually restarted, IMHO you need ECC memory. Otherwise you cannot guarantee that the instructions the program is executing is what the program writer intended. If the memory can have an error and your system cannot detect it ACID won't help, it will just ensure the error is reliably written to disk. -- William R. Mussatto Systems Engineer http://www.csz.com 909-920-9154 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Is ECC RAM necessary for MySQL server
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 opinion, corrupt anything included Innodb buffers. I would like the opinion of some other Innodb gurus. Happy new year. Claudio On Dec 31, 2011 2:04 PM, "Ryan Chan" wrote: > 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? > > Thanks. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql > >
Re: Is ECC RAM necessary for MySQL server
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 makes a mistake there is no software which can make this unhappen because the software can not know that a "ok written" did never happen or did not write the expected data in my workstations i never used ECC-RAM, and hey i did not die on production servers i would always use server hardware where this normally is not a question signature.asc Description: OpenPGP digital signature