Re: [SSI-users] Apache and MySQL Cluster

[Dave P. <dp...@w3...>]

Take advantage of the high availability (HA) add-ons to OpenSSI to=20
scale your Apache instance.  Likewise with qmail.

MySQL is best scaled by using its internal replication features.  MySQL=20=

isn't a good candidate for lobbing onto an OpenSSI cluster because of=20
the way it's designed and how it utilizes threads (which aren't /yet/=20
supported on an OpenSSI cluster.  I've got multi-master replication=20
which replicate to any number of slave ("read only") nodes.  The only=20
challenge is creating the appropriate middleware to get your=20
application to fail over to different MySQL read and, if appropriate,=20
write nodes.

Kind Regards,
-dsp

On Sunday, Oct 26, 2003, at 00:55 US/Eastern, Dave Cook wrote:

> Hello:
> =A0
> I'm very new to clustering in Linux.=A0 I run a site that is starting =
to=20
> catch on and I want to scale up.=A0 I mainly run Apache, Qmail and=20
> MySQL.=A0=A0A document=A0server runs a=A0standard RH9.0 ext3 =
filesystem.=A0 I=20
> have one box for MySQL, one for Apache+Qmail, and one for the document=20=

> server.=A0 It's a start-up company hence the small investment in=20
> hardware.=A0 Now things are taking off and I'd like to build more=20
> availability/scalability and manageability into the mix much like=20
> Bruce mentions in his OpenSSI paper.=A0 (Which really opened my eyes I=20=

> might add). =A0I didn't realize there were so many types of=20
> clusters.=A0=A0The OpenSSI approach is definitely the right way to =
think.=A0=20
> I've spent the better part of 3 days trying to distill all the=20
> components out there and basically ended up scratching my head until I=20=

> stumbled across the OpenSSI=A0project....That said, enough of my =
babble.
> =A0
> Do you have any pointers for a newbie trying to consolidate my above=20=

> scenario into a cluster configuration?=A0 I'm quite familiar with =
Linux=20
> and Open Source tools and I'm not afraid of going deep into it.=A0 I=20=

> completely agree with your approach.=A0 I asked the same question when =
I=20
> started hunting around.=A0 Why wouldn't I want all three components in =
a=20
> cluster solution?=A0 I want my cluster to be available, scalable and=20=

> yes, manageable.=A0 Maybe if you've heard of anyone trying this or =
know=20
> of more articles to read I'd be greatly appreciative...
> =A0
> regards,
> Dave F. Cook
> CTO
> Street Solutions Inc.
> =A0
> P.S. Dumb question: How does this project compare to say commercial=20
> offerings from Emic Networks (http://www.emicnetworks.com/)=A0