Also keep in mind that you don't have to install two different versions of the database software(kernels) available. If you want to run several databases with different storage locations, all while using the same VERSION of MaxDB, you can do one of two things:
1) When you create your volumes, specify the path you want to put it. There's no reason why you can't put it somewhere else, like, /bigdataarea/DAT_001, /bigdataarea/DAT_002
2) Alternatively, if you are running Unix, you can use symbolic links to relocate the volumes.
As Daniel said, the relationship between XServer and your database instances is a "One-to-Many" relationship. *One* xserver listens and directs the connections to the *Many* instances that are running. You will, of course, have to start these instances. I think you may be thinking of the way databases like MySQL handle connections, wherein the program that accepts connections does not appear to be separate from the database.
Hope that helps,
JLS Dittmar, Daniel wrote:
Ideally I would like to have the two databases have distinct storage
in the SAN frame. So my question is can I have two different installs?
For example for the OLTP database I would have the folders as
/var/opt/oltp/sdb/data, /opt/oltp/sdb/programs and /opt/oltp/sdb/<version> .
The DataWareHouse would have the folders as /var/opt/DW/sdb/data,
/opt/DW/sdb/programs and /opt/DW/sdb/<version> .
You can have multiple software installations on the same machine (of the same or of different releases). Each installation can be used for multiple databases.
If this is possible, do I need to start two different xserv
services?
The xserver will be installed only once (into <independent_programs>) and can be used to connect to any number of databases on the same machine.
Daniel Dittmar
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
