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

[Phil Marsh]

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