 |
 |
Hi Dieter & Charlie, I did ask and there is no procedure. I thought we could try to help with that, both Jacek and one of the Oracle folk have had mySQL training IIRC. When I get back I'll start talking to them. regards, Stephen On Mon, 20 Mar 2006, Dieter Best wrote: > Hi Charlie, > the short answer to this: No. (with the usual caveats, like as far as I > know, I don't claim to be in the loop with everything in Atlas, I think > nobody is). There is a web page that shows how to get "a" replica, the > one Wei pointed out to us a little while ago, but there seems no > guarantee that this is up-to-date (it wasn't in our case as it turned > out, not by a long shot). As far as I can tell there is still no > automatic or semi-automatic procedure that makes sure that all the > Tier1/2 sites use the same up-to-date replica. I would, however, consult > with Sasha Vaniachine to be certain. > -- Dieter > > Young, Charles C. wrote: > > >Hi Dieter, > > > >I have probably forgotten, but is there a standard procedure to get a replica? If I remember right, we copied something but that turned out to be missing some pieces, and they had to be added manually. Do people now create an image regularly (whether time or event driven) so remote sites could import for specific purposes? Cheers. > > > > Charlie > >-- > >Charles C. Young > >M.S. 43, Stanford Linear Accelerator Center > >P.O. Box 20450 > >Stanford, CA 94309 > >[log in to unmask] > >voice (650) 926 2669 > >fax (650) 926 2923 > > > > > > > >>-----Original Message----- > >>From: [log in to unmask] > >>[mailto:[log in to unmask]] > >>On Behalf Of Dieter Best > >>Sent: Monday, March 20, 2006 10:16 AM > >>To: atlas-sccs-planning-l > >>Subject: [Fwd: Re: New JT service for local MySQL replicas] > >> > >>... 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 > >>> > >>> > >>> > >> > >> > > -- /------------------------------------+-------------------------\ |Stephen J. Gowdy | SLAC, MailStop 34, | |http://www.slac.stanford.edu/~gowdy/ | 2575 Sand Hill Road, | |http://calendar.yahoo.com/gowdy | Menlo Park CA 94025, USA | |EMail: [log in to unmask] | Tel: +1 650 926 3144 | \------------------------------------+-------------------------/