From: <unknown Date: May 18 1999 4:11am Subject: Re: Database distribution List-Archive: http://lists.mysql.com/mysql/3503 Message-Id: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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. >