MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Murad Nayal Date:March 14 2003 3:53pm
Subject:Re: running an mysql client on a linux cluster?
View as plain text  
Thanks a lot Walt,

do you happen to have any code examples/fragments handy you can share? 

thanks again


walt wrote:
> 
> Murad Nayal wrote:
> 
> > Hello,
> >
> > I wonder if anyone has encountered this problem before and has any
> > ideas. I need to run programs on a linux cluster that make client
> > connections to an mysql database on a different server. this linux
> > cluster is set up where only the main node has an internet connection.
> > so the problem is how make it possible for programs running on the
> > internal nodes to make connections to the mysql server. This may not be
> > a strictly an mysql question. but I am in a little bit of a bind and
> > would greatly appreciate any help if anyone has experience dealing with
> > a similar situation.
> >
> > many thanks
> >
> > Murad
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> >    http://www.mysql.com/manual.php   (the manual)
> >    http://lists.mysql.com/           (the list archive)
> >
> > To request this thread, e-mail <mysql-thread134708@stripped>
> > To unsubscribe, e-mail
> <mysql-unsubscribe-kernel=nea-fast.com@stripped>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> Murad,
> You could write a program that runs on the master node which makes the request on
> 
> behalf of the slave/secondary nodes and then returns the result back. We use
> something
> similar to this that we call a broker. The broker is the only thing that "talks"
> to the database.
> All clients make requests to the broker , the broker gets/updates the info, and
> returns the result
> to the client. It's a very simple concept and has worked well.  We wrote it to
> get around Oracle
> licensing (only one user connected to the db, but we could handle requests from
> multiple
> web servers).
> 
> Hope this helps!
> 
> walt

-- 
Murad Nayal M.D. Ph.D.
Department of Biochemistry and Molecular Biophysics
College of Physicians and Surgeons of Columbia University
630 West 168th Street. New York, NY 10032
Tel: 212-305-6884	Fax: 212-305-6926
Thread
Connection String?Nelson Tamayo14 Mar
  • running an mysql client on a linux cluster?Murad Nayal14 Mar
  • Re: running an mysql client on a linux cluster?walt14 Mar
  • Re: Connection String?barry.hawkins14 Mar
    • RE: Connection String?Mike Hillyer14 Mar
      • RE: Connection String?Barry C. Hawkins14 Mar
  • Re: running an mysql client on a linux cluster?Murad Nayal14 Mar