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,

Re: ZFS Few Questions

2011-11-17 Thread Eduardo Morras
At 19:26 17/11/2011, you wrote: Hello everyone I just had a few questions about ZFS. Question 3: Anyone Recommend for MySQL server? (Performance) A short comment about databases. With ZFS and similar file systems, when you make a snapshot the file system is recoverable/congruent/ok, but the

Re: ZFS Few Questions

2011-11-17 Thread Matthew Seaman
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 of IO pattern for ZFS (or any filesystem for that matter) to mana

Re: ZFS Few Questions

2011-11-17 Thread Freddie Cash
On Thu, Nov 17, 2011 at 11:51 AM, Mark Felder wrote: > On Thu, 17 Nov 2011 12:58:32 -0600, Freddie Cash > wrote: > > Question 2: >>> >>> FreeBSD 9.0 installable on ZFS root? >>> >>> Yes. >> > > This is now an option in the installer? It wasn't last time I checked, > but that was a while ago an

Re: ZFS Few Questions

2011-11-17 Thread list, mailing
Wow. Great reply. Going to do some practice with mirror type and 9 RC 2. Thanks again On Thursday, November 17, 2011, Freddie Cash wrote: > On Thu, Nov 17, 2011 at 10:26 AM, list, mailing wrote: >> >> Hello everyone I just had a few questions about ZFS. >> I normally use Hardware RAID 5. >> >>

Re: ZFS Few Questions

2011-11-17 Thread list, mailing
Thanks for all the help. On Thursday, November 17, 2011, Mark Felder wrote: > On Thu, 17 Nov 2011 12:58:32 -0600, Freddie Cash wrote: > >>> >>> Question 2: >>> >>> FreeBSD 9.0 installable on ZFS root? >>> >> Yes. > > > This is now an option in the installer? It wasn't last time I checked, but th

Re: ZFS Few Questions

2011-11-17 Thread Mark Felder
On Thu, 17 Nov 2011 12:58:32 -0600, Freddie Cash wrote: Question 2: FreeBSD 9.0 installable on ZFS root? Yes. This is now an option in the installer? It wasn't last time I checked, but that was a while ago and last I heard it wasn't going to make it in... I'll have to fire up the la

Re: ZFS Few Questions

2011-11-17 Thread Freddie Cash
On Thu, Nov 17, 2011 at 10:26 AM, list, mailing wrote: > Hello everyone I just had a few questions about ZFS. > I normally use Hardware RAID 5. > > Question 1: > > With the ZFS snapshots what is the lost in drive space? > > If no data changes after you create the snapshots, then no disk space is

Re: ZFS Few Questions

2011-11-17 Thread Mark Felder
On Thu, 17 Nov 2011 12:26:49 -0600, list, mailing wrote: Question 1: With the ZFS snapshots what is the lost in drive space? ZFS tracks the blocks that change. If you change 60GB of data, you'll lose 60GB of space. (roughly... there is probably some slight overhead but you get the point)

ZFS Few Questions

2011-11-17 Thread list, mailing
Hello everyone I just had a few questions about ZFS. I normally use Hardware RAID 5. Question 1: With the ZFS snapshots what is the lost in drive space? Hard drives I have: 4 x 500 GB = 1.5T on RAID 5 I have see lots of videos like: http://www.youtube.com/watch?v=CN6iDzesEs0 Question 2: FreeB