Re: [GeneX-dev] What do you think of that?

[Michael P. <mic...@ho...>]

Ron,

You shouldn't need to duplicate the GeneX "application" server. Instead,
just run postgresql on a second machine, and load the genex database on
that. There is a parameter "GENEX_HOST" that gets set during the =
installation
process to specify the hostname of the system where the database is =
located.
Unless there are problems at the postgres level, then there shouldn't be =
any problem
with mixing platforms for the database server and genex server.

There are a couple of caveats with this:
1) I don't know if this configuration has been tested through the =
install-all.pl script
I notice at least one place where construction of a connect string =
involving  a
remote host is commented. You may need to manually load the database =
dump on
the database server.
2) you will need to make sure that postgresql allows network =
connections. That may
require modifying a file "pg_hba.conf" on the database server. You can =
test for
a working connection from your genex host with "pgsql -h <dbhostname> =
genex genex"

I've used the remote connections from other machines to the genex db in =
postgresql,
but I've not set this up for our genex server.

Regarding the mirroring, that may be more difficult and would need to be =
resolved purely
at the postgresql level.

Regards,

Michael Pear

  ----- Original Message -----=20
  From: Ron Ophir=20
  To: gen...@li...=20
  Sent: Thursday, June 14, 2001 4:49 AM
  Subject: [GeneX-dev] What do you think of that?


  Hi All,
  Genex integrates database  and microarray analysis tools. Whereas =
database transaction are relatively fast, microarray analysis are cpu =
and memory consuming. Therefore I thought of implement them on to =
different servers. The scheme I see in mind is the following:


  |-----------------|                                                    =
  |------------------|
  |                       |                                              =
        |                        |
  |                       |                                              =
        |                        |
  |       HTTPd      |                                                   =
   |   HTTPd          |
  |                       |                                              =
        |                        |
  |-----------------|                                                    =
  |------------------|
             |                                                           =
                    |
             |                                                           =
                    |
  =AF----------------                      NFS                          =
-------------------------
  |   DB server    |----------------------------------------| =
Application server  |
  =AF----------------                                                    =
  =AF-----------------------

  all I have to do then is to redirect the links in the html documents. =
Moreover, I may install-all twice on each server and miror the database =
in that way each server can back up the other by restoring the html =
documents for single mode (server) using.
  What do you think wil it work?
  In addition, that may be another solution for R on MacOSx, if use =
MacOSX as a databse server and PC as application server.
  Ron