[GE users] two cluster with the same reporting
sdiaz at cesga.es
Fri Nov 28 08:41:19 GMT 2008
[ The following text is in the "UTF-8" character set. ]
[ Your display is set for the "ISO-8859-10" character set. ]
[ Some characters may be displayed incorrectly. ]
Thank very much Jana.
I'm using 6.1 but in a few days we are going to migrate to 6.2. Can I do
this with 6.1, can't I? And when the cluster are migrated, we will have
to reinstall the both dbwriter?
> Hi Sergio,
> 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 specified cluster.
> Jana Olivova
> 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,
Sergio Díaz Montes
Centro de Supercomputacion de Galicia
Avda. de Vigo. s/n (Campus Sur) 15706 Santiago de Compostela (Spain)
Tel: +34 981 56 98 10 ; Fax: +34 981 59 46 16
email: sdiaz at cesga.es ; http://www.cesga.es/
To unsubscribe from this discussion, e-mail: [users-unsubscribe at gridengine.sunsource.net].
More information about the gridengine-users