Yep.. this is very feasible.. And there are some packages to do this already.
http://www.firstworks.com/sqlrelay.html Is a good package and library/API to implement what you want to do. We have done this in the past for a large community based website. -----Original Message----- From: John Masterson [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 1:22 PM To: [EMAIL PROTECTED] Subject: Web hosting scalability? Situation: mass virtual website hosting, with php/perl/python. One master mysql server, one or more replicated slaves. Question: would it be possible/feasible to write a daemon that accepts connections on behalf of mysqld, and depending on what type of query it is (updating or selecting) farm the query out to the appropriate database server? Perhaps it could do some connection pooling as well. The reason: we'd like to keep telling our users to connect to "the database server", instead of hoping that they will always write correct code and connect to the appropriate servers, which of course they won't. Any feedback (such as, "that's the stupidest idea I've ever heard, why don't you just do _____") would be appreciated :) John Masterson Modwest Powerful, Affordable Web Hosting http://www.modwest.com --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
