Re: [las_users] multiple MySQL drivers

["Jerome King" <jejeking@xxxxxxxxxxx>]

Hi Lynn,

It looks like ferret.pmel.noaa.gov is down.

I don't know how the sistering works with databases. The sistering thing 
allow you to get the necessary xml files so you can connect to a sister 
system. I don't know how it actually takes care of the database driver 
files.
I think the sistering thing works if the sister systems are configured the 
same way. I am not sure how the sistering thing would work if you had a 
system configured to work with mysql, one with oracle, one with 
Dapper...etc...

I need to read more about "sistering" when the website comes back up.

Thanks for the idea,
Jerome.




> From: "Lynn Dewitt" <Lynn.Dewitt@noaa.gov>
> To: "Jerome King" <jejeking@hotmail.com>
> CC: oar.pmel.las_users@noaa.gov
> Subject: Re: [las_users] multiple MySQL drivers
> Date: Tue, 15 Nov 2005 12:24:24 -0800
>
> Hi Jerome,
>   Can you just create another LAS that incorporates the four LAS's you've 
> got as "sister servers"?
>
> http://ferret.pmel.noaa.gov/LASdoc/serve/cache/52.html
>
> I'm not sure how well this works with insitu datasets.    Lynn
>
> On Nov 15, 2005, at 11:40 AM, Jerome King wrote:
>
> > Hi all,
> >
> > I have 4 LAS set up to talk to 4 different MySQL databases.
> >
> > I am now working into grouping those 4 LAS into ONE LAS. Therefore this 
> > ONE LAS will talk to 4 MySQL databases.
> > Since I wrote a different driver for each MySQL databases, I would like to 
> > just refer those drivers in the insitu.pl instead of writing ONE driver 
> > that would work for all 4 databases.
> >
> > I refered them as "mysql1", "mysql2", "mysql3",...but of course this did 
> > not work since the insitu.pl calls the module DBD/mysql.pm and there are 
> > no DBD::mysql1 module, DBD::mysql2 module,....
> >
> > I was wondering if there was a way to do this so I don't have to write a 
> > driver that encompasses all 4 mini MySQL drivers.
> >
> > Thanks,
> > Jerome
> Lynn deWitt
> NOAA/NMFS
> Environmental Research Division
> Southwest Fisheries Science Center
> 1352 Lighthouse Ave
> Pacific Grove, CA 93907
> (831)648-9036