From - Fri Mar 16 16:02:49 2001 Received: from othello.physics.gla.ac.uk (infnts.ts.infn.it [140.105.6.150]) by quark.ts.infn.it (8.9.3/8.9.3) with SMTP id JAA15273 for ; Thu, 15 Mar 2001 09:05:50 +0100 (MET) Received: from othello.physics.gla.ac.uk (130.209.204.200) by INFNTS with TCP/IP SMTP; Thu, 15 MAR 01 09:05 CET Received: from a5.ph.gla.ac.uk ([130.209.45.103]) by othello.physics.gla.ac.uk with esmtp (Exim 3.13 #1) id 14dSlV-0006RN-00; Thu, 15 Mar 2001 08:05:45 +0000 Received: from localhost (stdenis@localhost) by a5.ph.gla.ac.uk (8.8.8/8.8.8) with ESMTP id IAA26742; Thu, 15 Mar 2001 08:05:44 GMT X-Authentication-Warning: a5.ph.gla.ac.uk: stdenis owned process doing -bs Date: Thu, 15 Mar 2001 08:05:42 +0000 (GMT) To: Stefano Belforte cc: Jack Cranshaw , Igor Gorelov , franco.semeria@bo.infn.it In-Reply-To: <3AAFE709.88939C4B@ts.infn.it> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: From: "Rick St. Denis" Reply-To: Subject: Re: DB export to Italy Dear Stefano I have not heard from Mark for some time and lost touch with operations of the database as I have been teaching since February. So the proposals and intentions for export were fine, but needed action from proponents. Jack has had to put as first and only priority the second commissioning run. Er. I mean Run II. So I am frankly not sure what happened to export and could not chase it. We can mumble lots about who has responsibility to provide what, which commmittee wants what thing, but if you really want to get the full CDFDB, then I think we need someone who is doing what Igor Gorelov of New Mexico has done. He has studied oracle, having taken official courses, set up a server on a linux box at new mexico and started replication to it. He is now going to FNAL for 6 months having realized how much he needs to know to actually get a server working and how much he can learn from the Fermilab Computing Division people, like Nelly Stanfield and others. But even then, you have a whole new problem: the network connectivity. The fact is that when we modify the schema -- and we do this more than we would have liked -- we have to wipe out the replication and refresh it all. As the database has grown, this becomes quite demanding! Also, when you talk about the full database, you probably dont want every silicon raw calibration. But to pick and choose, you need mark's solution. If you go with the oracle solution, you are looking at a lot of work and resource usage. Kinda like buying a jaguar. I will try to find out therefore what mark is up to, but suspect i will not get a lot of happiness. cheers rick ***************************** Dr. Richard St. Denis,Dept. of Phys.& Astr., Glasgow University Glasgow G12 8QQ; United Kingdom; UK Phone: [44] (141) 330 5887 UK Fax : [44] (141) 330 5881 ====================================== FermiLab PO Box 500; MS 318 Batavia, Illinois 60510 USA FNAL Phone: [00] 1-630-840-2943 FNAL Fax: [00] 1-630-840-2968 Sidet: [00] 1-630-840-8630 FCC: [00] 1-630-840-3707 On Wed, 14 Mar 2001, Stefano Belforte wrote: > Rick, > given the kind of network connectivity we have among italian sites, > and between Italy and Fnal, it make sense for us to look for a > solution that exports the full CDF DB to just one place and then > processes running all over Italy could access this common location > rather then having local copies. > This would hoepfully simplify our work over there. > While this sort of naturally blends (I think) with a full blown > Oracle replica, it may still be a work-saving solution also for > the freeware export. > Franco kindly offered to set up this on a central server in Bologna > if/when a proper technical proposal is singled out. > We very much need your opinion and input on this and definitely > would like to talk about it sometimes in the next couple of weeks > when Franco will also be at Fermilab (I am at Fnal all months). > We definitely can start by e-mail, just as you find more convenient. > > Looking forward to hearing from you > Stefano > -- > Stefano Belforte - I.N.F.N. tel : +39 040 375-6261 (fax: 375-6258) > Area di Ricerca - Padriciano 99 e-mail: Stefano.Belforte@ts.infn.it > 34012 TRIESTE TS - Italy Web : http://www.ts.infn.it/~belforte > at Fermilab: CDF trailers 169-N tel: (630)840-8698 >