Well, Oracle lets you use a big shared RAID array (or any kind of drive
array, they could just be concatenated drives, as long as they're shared)
to allow multiple database servers to serve requests from a single data
source. They've got a ton of cross-server locking work done to make that
happen tho, and I don't think MySQL's gonna be doing that any time soon.
---
tani hosokawa
river styx internet
On Mon, 17 May 1999, Sasha Pachev wrote:
> David Johnson wrote:
> >
> > Hello everyone,
> >
> > I was wondering if anyone out there has ever figured out how to distribute their
> data across multiple database instances. What I'm kind of looking for is a RAID array for
> my database, so that I can load balance the work across multiple CPUs and have error
> failover in the case that one machine goes down. Any MySQL solutions? Any other out of
> the box solutions?
> >
> > I am betting this is a very hard problem to solve but at my database's/service's
> current rate of growth I am going to run out of database CPU cycles in a matter of
> months...
> >
> > Thanks,
> >
> > DJ
>
> I am not sure if RAID has much to do with multiple CPU utilization, some
> correct me if I am wrong, but it is there to speed up disk access and/or
> provide redundancy. I think it is more of an OS configuration issue than
> MySQL, since MySQL relies on the filesystem to store the data.
>
>
> --
> Sasha Pachev
> http://www.sashanet.com
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread3497@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>
