Multiple installations

In article <3se829$8h5@clyde.open.ac.uk>,
   Richard Yates  wrote:
>We are considering multiple Ingres installations on one (Sun) host. What do 
>you think are the arguments for & against this?

>Richard.
>~~~~~~~~

Richard:

	At my installation, we were faced with this scenario a couple of years 
ago. At the time, we were running out of locks (INGRES has (had???) a hard 
limit of ~65000 locks per installation) and we had no choice but to separate 
our development environment from our production environment. Having lived for 
a couple of years with this topology, I have a few points that may be of 
interest:

1> MAKE SURE that your log files are located on separate spindles 	
(preferably/ideally alone on that spindle). The volume of traffic to 	and 
from the log file will degrade both installations.

2> MAKE SURE that you have plenty of disk space. You will require enough space 
	on disk to store two complete copies of your INGRES release tape. 
	There may be some files you can get rid of. I would talk with TS 
	before doing this however.

3> TALK with the system guru at your site (If you are him, then you are one up 
	on me) to get a feel for the amount of resources currently being 
	utilized by your one running INGRES installation. Once you have a feel 
	for this, in consultation with the system admin., determine if you can 
	afford to 1) dedicate that amount of furhther resources to another 
	INGRES installation, or 2) add necessary disk/memory/??? to your 
	system to take advantage of a second installation. Also note, on UNIX 
	systems (ours at least), significant changes may be required to the 
	kernal.


	Having said all this (and I know that there are some things I have 
forgotten), the experience of moving to a second installation was relatively 
painless.

	I hope this helps. If you want to discuss this further offline, feel 
free to contact me at the E-Mail address on the header (repeated below).

	Good Luck.

Sean O'Hara		INGRES DBA
			NCH Promotional Services
			Saint John, NB CANADA
			E-Mail: oharas@mi.net


> I wonder if it is possible to run two different ingres versions on a single
> Sun box (Solaris) at the same time.
>
> Say I iibuild two ingres on different locations and set up two sets of
> environment variables for ingres account. I can specify each of the ingres
> server to serve specific databases. Then I startup one ingres (say 6.4/04)
> with the default env and startup another (say 6.4/06) with another set of
> env...
>
> Any response appreciated.
> Wei Lei

Wei Lei

What you have described is called peer installations and is described
in the relevant manuals.  It works.  You just have to be careful to
keep everything separate including the installation id.
--
Gavin Trigg     Email: G.Trigg@its.unimelb.EDU.AU
                Telephone: +61 3 9344 6003      Fax +61 3 9347 4803
		Manager Administrative Systems Processing, Information
		Technology Services,
		The University of Melbourne, Parkville, Australia.  3052.



		
> John writes:
>		
> We are trying to run two complete instances of OI 1.2 on one machine. It
> seems that the iidbdb has some paths setup in the table that we need to
> change. Is there any way to recreate the iidbdb table with the paths that we
> need? (IE. OI #1 is running out of /rdbms/ingres and OI #2 needs to run out
> of /rdbmsb/ingres)

Hi John,

    I may have the wrong end of the stick on this one, but...

    When creating multiple installations of Ingres or OpenIngres you must
    come up with a different value of II_SYSTEM and then completely install
    ingres under the new value of II_SYSTEM.

    Ditto II_DATABASE,II_CHECKPOINT,II_JOURNAL etc.

    Dont forget that if you create a separate installation that you have to
    channel users into and outof these installations. Ditto scripts.
    This can be a lot of fun, leading to no end of entertaining errors.

    Martin Bowes
Ingres Q & A
To William's Home Page
Email William