[GE users] two cluster with the same reporting
jana.olivova at sun.com
Thu Nov 27 19:14:04 GMT 2008
I am assuming you are using 6.2, aren't you? Just reinstall the
reporting and enter both of the databases parameters. After you enter
the first parameters you will be asked:
Do you want to add another cluster? (y/n) [n] >>
Editing the config.xml directly would not work, since also the password
has to be generated.
To your other part of a question, if you are referring to cross-cluster
queries yes you onbly have to use fully qualified names if you want to
combine output from the tables from 2 different databases (database
schemas). Generally, you will just want to run the existing queries on a
sergio diaz wrote:
> Hi all,
> I want install other dbwriter in other cluster using the same reporting
> and also the same webconsole.
> If I create other database for the new cluster, the webconsole won't see
> this database because the reporting was set with the other database.
> Could I add to the file /gridware/sge/default/arco/reporting/config.xml
> two configuration of database?
> I.E. I have the following configuration and we could add the same only
> changed <database name="arco" host="machine.arco" port="3306"
> schema="arco"> for <database name="arco1" host="machine.arco"
> port="3306" schema="arco1">
> Configure the database connection to be used by the application
> <database name="arco" host="machine.arco" port="3306" schema="arco">
> <driver type="mysql">
> <user name="arco_read" passwd="XXXXXXX" maxConnections="10"/>
> If I read the following paragraph in the web page of arco, I guess that
> it isn't necessary and only If I want do a query using the two
> databases, I have to do for example "select arco.host, arco1.host from
> arco, arco1.sge_job;"
> Would be correct this suppose?
>> If you configure MySQL multiple databases using just one pair of users
>> (arco_write, arco_read) and grant the privileges as described in step
>> 7 of How to Configure the ARCo Database on MySQL
>> you can perform cross_cluster queries. You must use the
>> fully-qualified names when accessing objects, for example
> Many Thanks,
To unsubscribe from this discussion, e-mail: [users-unsubscribe at gridengine.sunsource.net].
More information about the gridengine-users