topic Re: Parallell installations ? in Server Management - Systems Insight Manager

Parallell installations ?

Mikael Rönnbäck — Thu, 15 Sep 2005 02:35:26 GMT

Could anyone from HP tell me whether it is possible and/or supported to run 2 parallell installations towards the same SQL database ?

The problem I see with this is the risk for data corruption.

My cause for asking is that I'm looking for alternatives, since our current cluster installation performance has dropped to nothing, getting a view from a query takes between 2-4 minutes (even if the query just contains "get me all servers starting with a"
Logging in usually takes 30 seconds to one minute.

Now I have been doing quite some troubleshooting and coming up with nothing, the servers are idle, the database is idle, and yet performance stinks, so next and only option seems to be reinstallation, and so I'm looking for options.

1. I would very much like to keep the settings, and the question is if they're all stored in the database and I can just save that one ?

2. I need to have a redundant solution and from what I can see clustering just makes the solution complex and slow, and does not work, so I can think of either two parallell installations towards same database, hence my question above, alternatively two parallell installations with 2 independent databases, but that again requires double the amount of diskspace and double the amount of administration.

Is there any other way that I haven't thought of ?

Re: Parallell installations ?

sandu_1 — Fri, 16 Sep 2005 04:19:21 GMT

It is possible to point 2 HPSIM to the same database.

Do the following steps for migration:
1. Install the new HPSIM and point that to a new database. (make sure that the new setup uses the same login name and password as in the old setup)
2. After the installation copy the following files from your old setup and paste that in the new setup
a. database.props
b. database.admin
c. globalsettings.ptops
d. database.tpl
e. databaseadmin.tpl
f. databaseadminupd.tpl
g. databaseupdate.tpl

restart the HPSIM service on the new server

Re: Parallell installations ?

Aravindh Rajaram — Fri, 16 Sep 2005 08:19:51 GMT

Interesting question. My answer is that it may be little too risky. When the practicality comes into play there is lot many things that drive HPSIM other than the database. The trust relationship, tight integration with of the host that is hosting SIM. I mean there are few other parameters in globalsettings.props like CMS devicekey,entries in nodesecurity.xml, SSH passwords.....and so many others that should be tuned to perfection.

Re: Parallell installations ?

Mikael Rönnbäck — Mon, 19 Sep 2005 08:31:15 GMT

Ok, so a parallell installation with 2 completely separate databases would be preferrable I take it. I guessed that would be the solution :)