[ic] Cluster and/or load balancing question

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

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.

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