Michael Widenius wrote:
> >>>>> "Benjamin" == Benjamin Grosman <bgrosman@stripped>
> >> 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.
> Benjamin> Distributed Database theory is an extremely difficult field. Although
> Benjamin> research has been done on it since the 70's, no real major
> Benjamin> have yet been made, and there are really no commercial products
> Benjamin> to perform any real multidatabase operations.
> Thanks Benjamin for your very good answer!
> I just wanted to add that by adding RAID and multiple CPU:s you can
> scale MySQL up a lot (the failover is still of course a problem).
> We have here at Linux EXPO got very good feedback for MySQL; One of
> the most asked features (even before sub-selects) seems to be
> replication so we will look at this into the very near future!
Has anybody ever been able to use MySQL on a network
cluster of Linux (or maybe not Linux) machines? If you
have, could you share your experience and tips for
setting it up.