[ic] Multipal DB servers

[Richard Houston]

Now that is cool. Anywhere I can get info on setting this up? Would be 
great to take advantage of mysql's speed on table that are mostly static 
and use postgresql for stuff that you would like to use transactions on.
This is of course if you do not want to use INNOdb on mysql for some reason.

Thanks very much.

Rich

P.S. not trying to start a PGSQL Vs. MYSQL debate here.


Dan Browning wrote:

> At 11:45 AM 8/2/2002 -0500, you wrote:
>
>> Hi all,
>>
>> I know this may be a silly question and the answer maybe rather 
>> obvious but I figure it is better to ask than have egg on my face 
>> latter.
>>
>> Is there any issue with having cat1 use Mysql on host1 and cat2 using 
>> pgsql on another hosts and cat3 using oracle on third host? All cat 
>> would exist on the same interchange server.
>>
>> I looked at the dbconf stuff and it look like it is very possible and 
>> easy to setup. But I would rather ask the way more experienced users 
>> on this.
>>
>> Thanks in advance
>>
>> Rich
>
>
> No problem at all.  Further, you can have one catalog that uses 1 
> MySQL products table, 2 PostgreSQL cat/area tables, and, perhaps 2 
> Oracle transactions/order line tables -- all in the same catalog.  
> :-)  Interchange is kind of unique that way.
>
> +~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> | Dan Browning, Kavod Technologies <db@kavod.com>
> +~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> The day after tomorrow is the third day of the rest of your life.
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>