Re: ZFS Few Questions

2011-11-18 Thread Tom Evans
On Fri, Nov 18, 2011 at 10:40 AM, Eduardo Morras wrote: > I mean that surely db will be corrupted and nothing could be recovered. I > know postgresql and there you have a begin snapshot - end snapshot for this > topic, data changes are stored in temporal archives and main db files are > consistent

Re: ZFS Few Questions

2011-11-18 Thread Tom Evans
On Thu, Nov 17, 2011 at 9:36 PM, Matthew Seaman wrote: > On 17/11/2011 19:04, Mark Felder wrote: >>> Question 3: >>> Anyone Recommend for MySQL server? (Performance) >> >> No idea; I haven't run any SQL servers on ZFS > > The sort of randomly located small IOs that RDBMSes do is the hardest > sort

Re: ZFS Few Questions

2011-11-18 Thread István
No problem for the most of the MySQL DBAs because consistency is not in their dictionary anyway :) On Fri, Nov 18, 2011 at 7:54 AM, Eduardo Morras wrote: > At 19:26 17/11/2011, you wrote: > >> Hello everyone I just had a few questions about ZFS. >> >> Question 3: >> >> Anyone Recommend for MyS

Re: ZFS Few Questions

2011-11-18 Thread Eduardo Morras
At 11:33 18/11/2011, István wrote: No problem for the most of the MySQL DBAs because consistency is not in their dictionary anyway :) I mean that surely db will be corrupted and nothing could be recovered. I know postgresql and there you have a begin snapshot - end snapshot for this topic,