Well, there are a few reasons.. We have a system with 4 8G drives.. If we
use one for root and one to mirror that root, we have 2 drives left. Now,
if we raid those 2 remaining drives (RAID5) we get about 12 Gigs of space
available... If we merely use one of the remaining drives completely, and
use the last one to mirror it, we have 8 gigs available. On the root drive,
however, there will be an additional 4 gigs of space not used.. so again,
we're at 12 gigs, but with a higher redundancy value.
So, I want to be able to put tables in /mysql/data (8 gig mirrored) and
/data (4 gig mirrored on the root drive) so I can still use 12 gigs of space
with better redundancy...
As an aside here, does anyone have any decent information on Linux software
raids? We have been having a large problem with them failing for no
apparent reason and I've lost enough data to last me a lifetime... (all
backed up now...)
---------------------------
Jason H. Frisvold
Senior ATM Engineer
Engineering Dept.
Penteledata
CCNA Certified - CSCO10151622
[EMAIL PROTECTED]
---------------------------
"I love deadlines. I especially like the whooshing sound they make as they
go flying by." -- Douglas Adams
-----Original Message-----
From: Sam Wong [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 30, 2001 6:32 AM
To: [EMAIL PROTECTED]
Subject: Re: MySQL Tables over Multiple Drives
Yes, you've to recreate the tables with RAID option (read the manual for
details)
and move and link the directoris manually.
I think there may be a performance gain, instead of performance
hit...Because as the file spread on diff discs, the seek time gain.
The code should has been stablize already, I think.
BTW, why you want it to span over multiple drive?
----- Original Message -----
From: "Jason Frisvold" <[EMAIL PROTECTED]>
To: "'Sam Wong'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 7:15 PM
Subject: RE: MySQL Tables over Multiple Drives
> Sam,
>
> Thanks for the reply.. Is that a stable way of doing things? Is
> there a performance hit when using the --with-raid option?
>
> I assume I will need to move the files manually and link them
> manually as well?
>
> ---------------------------
> Jason H. Frisvold
> Senior ATM Engineer
> Engineering Dept.
> Penteledata
> CCNA Certified - CSCO10151622
> [EMAIL PROTECTED]
> ---------------------------
> "I love deadlines. I especially like the whooshing sound they make as they
> go flying by." -- Douglas Adams
>
>
> -----Original Message-----
> From: Sam Wong [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 30, 2001 5:41 AM
> To: [EMAIL PROTECTED]
> Subject: Re: MySQL Tables over Multiple Drives
>
>
> Compile mysql with --with-raid option, then use symbolic link to link it
to
> other drive
>
> ----- Original Message -----
> From: "Jason Frisvold" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, January 30, 2001 6:33 PM
> Subject: MySQL Tables over Multiple Drives
>
>
> > I looked through the manual briefly and did not see this addressed
> > anywhere.. Is it possible to have a table span over multiple drive
> without
> > a raid? Or perhaps possible to specify a directory where a table will
> > reside other than the default directory?
> >
> > Thanks,
> >
> > ---------------------------
> > Jason H. Frisvold
> > Senior ATM Engineer
> > Engineering Dept.
> > Penteledata
> > CCNA Certified - CSCO10151622
> > [EMAIL PROTECTED]
> > ---------------------------
> > "I love deadlines. I especially like the whooshing sound they make as
they
> > go flying by." -- Douglas Adams
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
> >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
