7 Replies Latest reply: Aug 1, 2012 11:03 AM by Joel Rosett RSS

Doubt about database modified after create Server Groups?

Joel Rosett

Hello Team,

 

I have a great doubt about the changes suffered at Database level... so my question is : there is a record or table added to the database after you add another server to the Server Group? or the database still being the same schema?

 

what are the changes suffered at database level after create  a server grouo environment? some body can help me with this? this question is because if I have a lineal solution, I mean without server group and after finished to configured and developes I want to carry my database to server group environment on...

 

could be an issue doing this activity?

 

regards

Joel Rosete

  • 1. Re: Doubt about database modified after create Server Groups?
    Laurent Matheo

    Actually when you add another server to a server group, at first startup of this server it'll add records for this server in form "server group ranking" (or something). That's pretty much all.

    This form only exist if at least one ARS Server is in server group.

     

    If your server isn't in server group and then you create a server group it's not a problem. Though there will be some manual steps.

    All is pretty much described in the documentation (and the installation documentation too):

    BMC Remedy IT Service Management Suite 7.6.04 Installing and Configuring Server Groups

    http://webapps.bmc.com/support/faces/az/prodversion.jsp?prodverseqid=187798&ic=0

     

    The first ARS server is installed as it was alone. Once it's fully installed (ARS to RKM):

    -> tell him it's a server group (check "server group member" in "server information->configuration"),

    -> Give it a server group name in ar.cfg (Server-Name),

    -> Keep the ARS server name in ar.cfg (Server-Connect-Name),

    -> Declare all members of server group in ar.cfg with "IP-Name" (short DNS, full DNS, IPs),

    -> stop it, start it.

    -> the form "AR Systel server group operation ranking" will be created / appear with the server name as rank1 for all operations, if not, configure the ranking,

     

    When you will install other ARS Servers, keep an eye on installation pdfs, you'll have sometimes to deactivate server group for some modules, but it's in documentation

     

    In the end, you'll need to change some entries in database to tell not to use a "ARS server name" but the server group name since the server group name is / will be identical on all ARS servers.

    For example in "Report" form the reports have server set to an ARS server, change it to server group name instead.

    There are a couple of forms like this to go through.

  • 2. Re: Doubt about database modified after create Server Groups?
    Joel Rosett

    Thanks so much Laurent for your great help on this....

     

    I have another doubt about this... what happend if I have the following scenary:

     

    1.- Nowadays, we have an environment with many configurations, and with many customizations..

    2.- I want to add another server, to create server groups for this environment

    3.- then after adding a new server (Server Groups) I decided not to do any other activities about customizations and configuration.(because this environemnt is working pretty well)

    4.- SO I decide to create an environemnt for QA, after create this environment, I perform a full copy of the database for the environemtn explained on point 2(Server Groups)

    5.- since this moment I start to work for test and create another configurations and customizations en QA environemnt.

    6.- finishing the activities I decided to do a full copy of the database again but this time is going to be for carry this databse to paste it on Server Group Environent, to this way get the all configuyrations and customizations created on QA..

     

    could I have some troubles on this steps, what ricks can you se doing this activities... all information you can give me about tips, would be fully help for me...

     

    regards

    Joel Rosete

  • 3. Re: Doubt about database modified after create Server Groups?
    Laurent Matheo

    I have another doubt about this... what happend if I have the following scenary:

     

    1.- Nowadays, we have an environment with many configurations, and with many customizations..

    2.- I want to add another server, to create server groups for this environment

    3.- then after adding a new server (Server Groups) I decided not to do any other activities about customizations and configuration.(because this environemnt is working pretty well)

    4.- SO I decide to create an environemnt for QA, after create this environment, I perform a full copy of the database for the environemtn explained on point 2(Server Groups)

    5.- since this moment I start to work for test and create another configurations and customizations en QA environemnt.

    6.- finishing the activities I decided to do a full copy of the database again but this time is going to be for carry this databse to paste it on Server Group Environent, to this way get the all configuyrations and customizations created on QA..

     

    could I have some troubles on this steps, what ricks can you se doing this activities... all information you can give me about tips, would be fully help for me...

     

    regards

    Joel Rosete

     

    Ok so if I get you correctly, you create an environment (let's call it Production for the example) with plenty of customizations, not server group. You configure the Server Group.

    You copy this database to QA.

    On QA you work on new customizations.

    Once it's done you copy the QA base to Production.

     

    It's usually ok (I can't tell for your customizations of course).

    Quite some customers take the Production Database and use it from time to time on Pre-Production for example for benchmarks, testing new customizations, upgrade etc...

     

    There are some steps though:

    1°) if the database itself doesn't have the same name on Environment 1 and Environment 2, check with your DBA if he can backup a database and restore it under another name, else you would have to change some details in ar.cfg file (there are some threads on communities on how to connect to another database ),

    2°) once you restore the database from another environment, you would have to enter the licenses informations again for the ARS Server (Key for the ARS Server),

    3°) If the ARS server and server group name aren't the same on both environments, you would have to change the server names in the "ranking" form I spoke about (or delete all records in this form and stop / start the ars servers so the records are created again), and go on some forms to change the "server group name" from environment 1 to environment 2,

     

    But yeah it'll work.

     

    Then the question will be of the "new" data of course that happened on the "source" environment.

    Let's say you used Production database and put it to QA. You worked on QA for 2 months.

    In the 2 months, 1500 incidents, 200 changes, 235 RKM articles, 500 people were created / modified on production.

    If you take the QA database to production, you'll loose all those new incidents and stuff.

     

    Though of course in my example you took the database from Production, perhaps it's not the case in your example

  • 4. Re: Doubt about database modified after create Server Groups?
    Carl Wilson

    Hi,

    for a "trick" for point 2 here:

     

    >> 2°) once you restore the database from another environment, you would have to enter the licenses informations again for the ARS Server (Key for the ARS Server),

     

    You can enter all environments Server License keys into Production so when you restore the DB to another environment such as Pre-Production, the correct license key will be applied and used.  ARS is smart enough to ignore keys that are not valid for the current server - this functionality was introduced in the 7.x versions.

     

    As Laurent has mentioned, it is very common to copy a Production DB to a Pre-Production / Development / Test / etc, so you have an up to date environment containing the latest data.

     

    I have created a tool that helps update the Server references (a new version will be up today to correct an issue with the AIE entries) when restoring a DB from one environment to another.

     

    http://www.missingpiecessoftware.com/downloads/viewcategory/5-remedy-restore-tool

     

    Cheers

    Carl

     

    http://www.missingpiecessoftware.com/

  • 5. Re: Doubt about database modified after create Server Groups?
    Joel Rosett

    Thank you very much for your great help…

     

     

     

    So my last question, and hope no bother you any more J ….

     

     

     

    1.- why is necessary execute again the BMC Remedy AR System Server Software

    in another server you are adding?

     

     

     

    2.- Because I understand that If I add another app server to the same

    database, is enough adding the parameters on ar.cfg, and on server

    information adding the name of Alias and checking that this new server

    belong to a server groups, after this the form AR System Operation Ranking

    form just appears after performing this activity to be able to rank the

    servers?

     

     

     

    3..- or is necessary execute the software just to create the services on

    this server? Or what is the clue in here…

     

     

     

    hope that I had explained good….

     

     

     

    Regards

     

    Joel Rosete

  • 6. Re: Doubt about database modified after create Server Groups?
    Carl Wilson

    Hi Joel,

     

    1.  The required binaries/services/configuration files/etc for AR System are required to be installed on the secondary servers, so this is why you need to re-run the installers.  The options allow you to specify it is a part of the Server Group so as not to overwrite the existing DB.

     

    2.  AR Server automatically installs the Server Group Ranking form to the DB when you enable the Server Group option on any Server (including a single server setup).  You can add an existing server into the Server Group but you would need to re-point this server to the correct database and update the password.  The Guides will give you more information on this.  You then update the Server Group Ranking form manually to set the options required.

     

    3.  Refer to question one.

     

     

    Cheers

    Carl

     

    http://www.missingpiecessoftware.com/

  • 7. Re: Doubt about database modified after create Server Groups?
    Joel Rosett

    Thank you very much for your help Carl and Laurent, I appreciated your help…

     

     

     

    Regards

     

    Joel Rosete