Hello, I have installed the new JobTransformations at SLAC (cache 11.0.41.6) and gave the CSC production a shot. There is a new environment variable that needs to be set, for example T_ATLASMYSQLSERVER=osgserv04.slac.stanford.edu But I have encountered problems. Not necessarily related to our database replica since if I replace osgserv04.slac.stanford.edu with atlasdbdev.cern.ch I find similar problems (testing on an interactive machine). If I unset this environment variable csc.simul.trf works as expected. I emailed Alessandro di Salvo et al my findings, maybe more tomorrow. -- Dieter Dieter Best wrote: > ... and Martin Woudstra et al, the people working on the new python > Job Transforms, plan to add the same functionality. Looks like this > feature is in the main stream now. > -- Dieter > > -------- Original Message -------- > Subject: Re: New JT service for local MySQL replicas > Date: Mon, 20 Mar 2006 17:14:35 +0100 > From: Martin Woudstra <[log in to unmask]> > To: Alessandro De Salvo <[log in to unmask]> > CC: Davide Costanzo <[log in to unmask]>, Mireia Dosil i > Bonmatí <[log in to unmask]>, Andrea Di Simone <[log in to unmask]>, > Kaushik De <[log in to unmask]>, Dieter Best <[log in to unmask]> > References: <[log in to unmask]> > > > > Hi Alessandro, > > Can you tell me where I can find this new tool? > I will then also add the same functionality to the python jobtransforms. > > Cheers, > Martin > > > Alessandro De Salvo wrote: > >> Dear all, >> I've just introduced a new JT tool to allow to use the local MySQL >> replicas. The new service is called "addLocalMySQLSupport" and will >> appear from JobTransforms 11.0.41.6 in the production caches, as it will >> be ready. >> I've changed all your transformations (csc.*, ctb.*) in that cache to >> add the new service, so you may want to take a look at them. >> This service is very useful for sites like SLAC, where we need to use >> local replicas to access the CondDB. In that case the execution agent >> should only set the env variable T_ATLASMYSQLSERVER to the name of the >> local server with the replica(s). If the variable is not set, the >> service addLocalMySQLSupport does nothing. >> I'm waiting a bit before creating the cache because I want to add some >> other changes in there too, but I'll soon put it in production. >> Cheers, >> >> Alessandro >> >