My vote goes to a my.cnf configuration file. (/etc/my.cnf - or one of
the other possible locations)
It is, after all, a configuration option.
[Raid]
directory1=/disk1/mysql
directory2=/disk2/mysql
directory3=/disk3/mysql
etc..
> -----Original Message-----
> From: Markwalder Philip [mailto:[EMAIL PROTECTED]]
> Sent: 18 June 2001 14:40
> To: Tonu Samuel
> Cc: [EMAIL PROTECTED]
> Subject: Re: raid tables
>
>
> Hi Samuel
>
> I would do this in sql. I thinks this would be much more
> convenient to administrate. It would be great if you would
> see these informations also in with the command eg:
>
> show database storage
>
> and you can see as return, where the files are located.
>
>
> Thanks
>
> Philip
>
> On Mon, 18 Jun 2001 12:13:50 +0200 (CEST)
> Tonu Samuel <[EMAIL PROTECTED]> wrote:
>
> > On Mon, 18 Jun 2001, Jamie Krasnoo wrote:
> >
> > > Yes. It definitely would. I didn't know Yahoo uses MySQL.
> > >
> > > What would be great for an interim is if a script could determine
> > > the space available and suggest the settings to create
> the table. I
> > > see that by setting RAID_CHUNKS you could tell how many
> directories
> > > MySQL should make. The script could evenly distribute those
> > > directories and make the links and directories for MySQL.
> > > Sent: Sunday, June 17, 2001 11:53 PM
> > > To: Jamie Krasnoo
> > > Cc: MySQL
> > > Subject: Re: raid tables
> > >
> > >
> > > On Sun, Jun 17, 2001 at 11:48:04PM -0700, Jamie Krasnoo wrote:
> > > >
> > > > Is there a way to tell MySQL to automatically spread its tables
> > > > over a number of disks without going through the trouble of
> > > > symbolic linking the chunks to the different disks?
> > >
> > > There isn't yet, no. It'd certainly be a nice addition, though,
> > > wouldn't it?
> >
> > As author of this RAID code I would like to know, how did
> you see this
> > in your mind:
> >
> > - As MySQL command "DISTRIBUTE TABLES ...."?
> > - As some kind of external script?
> > - Other way?
> >
> > I would like to implement this feature but currently I do
> not see an
> > smooth way to do it. Maybe something like "LINK RAID DIR 1 to
> > /mnt/bigdisk" ?
> >
> >
> > --
> > For technical support contracts, goto https://order.mysql.com/
> > __ ___ ___ ____ __
> > / |/ /_ __/ __/ __ \/ / Mr. Tonu Samuel <[EMAIL PROTECTED]>
> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator
> > /_/ /_/\_, /___/\___\_\___/ Hong Kong, China
> > <___/ www.mysql.com
> >
> >
> >
> ---------------------------------------------------------------------
> > 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
> >
>
>
> --
> Besten
> Dank
>
> Philip Markwalder
>
> ==============================
> Markwalder Philip
> Consultant
> [EMAIL PROTECTED]
>
> Trivadis AG
> Kanalstrasse 5
> CH-8152 Glattbrugg
> Tel.: +41- 1-808 70 20
> Fax : +41- 1-808 70 21
> Mobile: +41-79-445 77 87
> http://www.trivadis.com
> ==============================
>
> ---------------------------------------------------------------------
> 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
