Re: FW: CLAS sofware at UR: MYSQL

[Luminita Todor <luminita@jlab.org>]

We want both the client and the server installed on the new cluster.
The client allows us to use the JLAB database. However this might be slow
due to network traffic or JLAB database even broke down couple of times
unable to handle the numerous requests. Then it's better to have a mirror
at UR and for that we need the client. Once MySQL is installed and Mark
Ito established the new mirroing scheme (he is working on changes right
now) I will create a new database mirror in UR cluster.

Luminita Todor
postdoctoral research associate
Carnegie Mellon University, Pittsburgh, PA
research site - Thomas Jefferson National Facility / Hall B
tel. 757-269-5538

On Fri, 22 Nov 2002, gilfoyle wrote:

> mike and luminita,
> 
>    you all know more about this than i do. what do you think about
> sasko's question?
> 
> jerry
> 
> "Stefanovski, Sasko" wrote:
> > 
> > Jerry,
> > 
> > Before installing anything on pscm1, I need some information.
> > 
> > Mike mentioned that Francisco has setup some time while ago a mysql server
> > on psc1.
> > 
> > Do you want to keep the same setup - mysql server on psc1 and have mysql
> > client only on pscm1?
> > Or both the server and the client to be installed on the new cluster?
> > 
> > Thanks,
> > Sasko
> > 
> > -----Original Message-----
> > From: Luminita Todor [mailto:luminita@jlab.org]
> > Sent: Thursday, November 21, 2002 7:27 PM
> > To: Stefanovski, Sasko
> > Cc: Mike Vineyard; Markus Geiger
> > Subject: RE: CLAS sofware at UR: MYSQL
> > 
> > Sasko,
> > 
> > I think we need MySQL on pscm1 installed if not too difficult.
> > CLAS software uses sets of detector&time related values
> > organized in a MySQL database with a master version at
> > JLAB and a mirror at UR.
> > 
> > I expect to pick up the software build next Monday - it
> > would be great if it is installed at that time.
> > If the effort is too big I can just copy the relevant
> > libraries from JLAB.
> > 
> > Please also let me know where you put the CERN libraries (path&version).
> > Are you going to move old-home to new directories or should
> >  I do it - as root of course? The directories with different
> > releases of CLAS software is named... clas
> > Thank you,
> > 
> > Luminita Todor
> > postdoctoral research associate
> > Carnegie Mellon University, Pittsburgh, PA
> > research site - Thomas Jefferson National Facility / Hall B
> > tel. 757-269-5538
> > 
> > On Thu, 21 Nov 2002, Stefanovski, Sasko wrote:
> > 
> > > Luminita,
> > >
> > > /home/old-home directory is just there temporary. That's why 'old-home'
> > > Everything below is supposed to be moved to /home.
> > > User need to move their home directory too.
> > >
> > > BTW, mysql is not installed on pscm1. If you need it, it can be installed.
> > > It is not a part of the default RedHat 7.2 installation and that's why
> > it's
> > > missing.
> > >
> > > Sasko
> > >
> > > -----Original Message-----
> > > From: Luminita Todor [mailto:luminita@jlab.org]
> > > Sent: Thursday, November 21, 2002 2:29 PM
> > > To: gilfoyle
> > > Cc: Mike Vineyard; Sasko Stafanovski; Markus Geiger
> > > Subject: CLAS sofware at UR: MYSQL?
> > >
> > >
> > >
> > > Today I started to install release-4-4 of CLAS sofware on
> > > pscm1. I checked out the software in my account and copy
> > > the sources in
> > > /usr/old-home/clas/builds/release-4-4
> > > (to be side-by-side with the previous releases)
> > >
> > > I tried to build and I run into some errors in caldb
> > > related to absence of some mysql header.
> > > ....
> > > calib_connect.c:10:19: mysql.h: No such file or directory
> > > ....
> > > At JLAB I have included in the PATH
> > > MYSQL_INCLUDE_PATH=/group/clas/mysql/LinuxRH7/include
> > > MYSQL_LIB_PATH=/group/clas/mysql/LinuxRH6/lib
> > > MYSQL_INCLUDE=/apps/mysql/include/mysql
> > > MYSQL_LIBS=/apps/mysql/lib/mysql
> > >
> > > Here comes the question:
> > > Is NOW mysql installed in UR cluster? Where? How/which related variables
> > > were set? It might as well be that you avoid the MySQL
> > >
> > > There are some other minor problems - I think Mark Ito will help me clear
> > > them soon. So I'm working on it.
> > >
> > > Luminita Todor
> > > postdoctoral research associate
> > > Carnegie Mellon University, Pittsburgh, PA
> > > research site - Thomas Jefferson National Facility / Hall B
> > > tel. 757-269-5538
> > >
> > >
> > >
> 
> -- 
> Dr. Gerard P. Gilfoyle
> Physics Department                e-mail: ggilfoyl@richmond.edu
> University of Richmond, VA 23173  phone:  804-289-8255
> USA                               fax:    804-289-8482
>