[ic] Cluster and/or load balancing question

Joachim Leidinger interchange-users@icdevgroup.org
Thu Jul 11 04:18:01 2002


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?

Thank you very much!

Joachim Leidinger



-- 
Hans-Joachim Leidinger | Dipl.-Phys.Ing. Entwicklung eCommerce
[leidinger@bpanet.de]
Black Point Arts Internet Solutions GmbH
http://www.bpanet.de