[NCLUG] ZFS RAID-Z2 for /home on Ubuntu 12.04

[Jesse Griffin]

I realize the L in NCLUG stands for Linux, but...

I've been using ZFS on PC-BSD (which is simply FreeBSD under the hood) for
several years now and the feature set is simply awesome ;).  I've yet to
encounter a ZFS related problem on FreeBSD.

Also, the latest version of PC-BSD is a rolling-release model that tracks
FreeBSD 9-stable and which includes support for ZFS boot environments.  In other
words, you can snapshot your OS before you do an upgrade and then when you
reboot GRUB will allow you to boot into a previous snapshot if your upgrade
causes problems.

This, http://blog.pcbsd.org/2013/07/rolling-release-and-9-2-beta1-released/, and
much more at http://blog.pcbsd.org/.


Thank you,
Jesse Griffin
tummy.com, ltd.

On 08/09/2013 06:47 PM, Phil Marsh wrote:
> If you don't mind, Sean and anyone else who want to respond, I have another question, namely, has anyone tried ZFS for their /home directory? I think Sean has and I was going to rebuild my main system with Ubuntu 12.04 with five disks.
> A 500GB disk would have the ext4 filesystem and contain the OS and grub.
> Then, I was thinking of setting up a ZFS pool raid-Z2 with four 1TB drives which would hold the /home directory.
> Can I use the FUSE configuration file (I might have the name wrong) to mount the ZFS raid-Z2 pool to /home on boot up as I did with my RAID 5 configuration (ext3)?
> Does anyone see any problems with remote mounting of the resulting /home mount using sshfs?
> Does anyone see any other pitfalls to the above? Do you recommend ZFS on Ubuntu like this?
> Thanks,
> Phil
> 
> 
> 
> 
> 
> 
> Sent from my iPad
> 
> On Aug 8, 2013, at 5:29 PM, Brian Grossman <brian-nclug at admin.softhome.net> wrote:
> 
>> So your link tables are missing?  (http://en.wikipedia.org/wiki/Junction_table)
>>
>> Or do you mean foreign keys? (http://en.wikipedia.org/wiki/Foreign_key)
>>
>> Does it work if you use mysqldump directly?  If not, what options did you use?
>>
>> Brian
>>
>> On Thu, 8 Aug 2013 16:01:07 -0700 (PDT)
>> phil marsh <montanaembassy at yahoo.com> wrote:
>>
>>> Hi Stephen,
>>> Some of the tables contain links to files on disk.
>>> Relationships are database structures that link one table to another in
>>> the database. Say if one table contains a person's name, and another
>>> table in the database also contains the person's name with other columns
>>> containing personal information, a relationship will link the two
>>> columns containing the person's name in the two tables of the database.
>>> These above two structures are apparently not being saved in the export
>>> database backups I'm trying to make. My Google efforts have been
>>> fruitless and it's almost as if nobody else has seen this, so my error
>>> is likely obvious and/or simple but I just can't find it. Thanks, Phil
>>>
>>>
>>>
>>>
>>> ________________________________
>>> From: Stephen Warren <swarren at wwwdotorg.org>
>>> To: Northern Colorado Linux Users Group <nclug at lists.nclug.org> 
>>> Cc: phil marsh <montanaembassy at yahoo.com> 
>>> Sent: Thursday, August 8, 2013 4:50 PM
>>> Subject: Re: [NCLUG] mysql: backing up database - cannot save
>>> relationships 
>>>
>>> On 08/08/2013 03:59 PM, phil marsh wrote:
>>>> Hi all,
>>>> I was wondering if any of you saw this issue and could kindly give me
>>>> your opinion? When I attempt to backup my mysql databases from
>>>> phpmyadmin or mysql directly via export (SQL data) then import them,
>>>> the imported database lacks the relationships and also the links.
>>>
>>> What exactly are "relationships" and "links". Are they simply tables
>>> that contain the keys of other tables? Do those tables appear in the
>>> dump itself?
>>> _______________________________________________
>>> NCLUG mailing list       NCLUG at lists.nclug.org
>>>
>>> To unsubscribe, subscribe, or modify
>>> your settings, go to:
>>> http://lists.nclug.org/mailman/listinfo/nclug
>> _______________________________________________
>> NCLUG mailing list       NCLUG at lists.nclug.org
>>
>> To unsubscribe, subscribe, or modify
>> your settings, go to:
>> http://lists.nclug.org/mailman/listinfo/nclug
> _______________________________________________
> NCLUG mailing list       NCLUG at lists.nclug.org
> 
> To unsubscribe, subscribe, or modify
> your settings, go to:
> http://lists.nclug.org/mailman/listinfo/nclug
>