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 --------------------------------------------------------------------- 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
