Re: Web hosting scalability?
Sounds like a transaction server to me. Curtis John Masterson said: > 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
RE: Web hosting scalability?
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
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