[ic] Cluster and/or load balancing question

[interchange-users@icdevgroup.org (Bill Carr)]

On Thu, 2002-07-11 at 07:20, Bill Carr wrote:
> On Thu, 2002-07-11 at 04:19, Joachim Leidinger wrote:
> > Hi List,
> > 
> > 
> > I've searched for any answer in the mail archivs to get a right 
> > using/installation/configuration of IC with 2 servers as a cluster and 
> > later with a load balancing solution. But I'm unsure about the right way 
> > to the solution.
> > 
> > I've FreeBSD, IC and different two machines. I've read, that Postgresql 
> > is the right or better SQL-Server than MySQL, because MySQL-Server as a 
> > Slave can't update the Master. But maybe the URL
> > 
> > http://www.phpbuilder.com/columns/tanoviceanu20000912.php3
> > 
> > can show me the solution for a multiple way of replication with MySQL.
> > 
> > I would prefer to use MySQL, because I'm new in SQL and I've a little 
> > experience with MySQL.
> > 
> > I'm unsure, which files should be moved from db into SQL? What is with 
> > the other files like order.number, usertrack, etc.? I've read, that the 
> > session files, which is stored in catalogs/mycatalogname/session and 
> > catalogs/mycatalogname/tmp should be moved into the SQL-Server as a 
> > session file (see 
> > http://interchange.redhat.com/pipermail/interchange-users/2001-April/007636.html)
> > I know, most tables of IC is read only. But I've not a list of files 
> > with write permissions. What have I to notice, if I use IC in a cluster?
> > 
> > 
> > Are there a white paper about "How to use IC in a cluster and/or 
> > load-balancing system with or without SQL Server"?
> > 
> > Are there any documentation or description for clustering webserver with 
> > IC and SQL?
> > 
> > Who can help me with any tips and hints?
> Check out http://linuxvirtualserver.org/ and http://linux-ha.org/
> 
> I use a LVS-DR setup like this:
> 
>           Internet
>              |
>         ----------
>         | LVS-DR |
>         ----------
>              |
>       ----------------
>       |              |
> ------------    ------------
> | www/ic 1 |    | www/ic 2 |
> ------------    ------------
>       |              |
>       ----------------
>              |
>         ---------------------
>         | MySQL/NFS Server  |
>         ---------------------
> 
> I would start with this and once you get something like this working
> consider load balancing or replicating your database. You will have a
> single point of failure in your database server so through your best and
> most sturdy hardware at it.
through should be throw. Sorry for the terrible spelling. I will go get
coffee now.

> 
> Please go for it and become an expert. I think that there is only myself
> and Dan Browning that run any kind of rig like this now.
> 
> -- 
> Bill Carr
> Worldwide Impact
> bill@worldwideimpact.com
> 413-253-6700
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
> 
-- 
Bill Carr
Worldwide Impact
bill@worldwideimpact.com
413-253-6700