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 <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > 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 --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
