If you want to use DNS, that's the way to go. You can also use LVS to setup clusters of databases.
http://www.linuxvirtualserver.org -----Original Message----- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Friday, March 07, 2003 6:05 PM To: John Masterson Cc: [EMAIL PROTECTED] Subject: Re: clustering/scalability question On Fri, Mar 07, 2003 at 04:56:54PM -0700, John Masterson wrote: > Hello, > > We're a web hosting company currently hosting nearly 2000 MySQL > databases (3.23.54) at around 200-300 queries/second. Amazing > performance, really. But we're growing fast and planning for the next > step. Our wishlist is short: > > We want to allow all our customers to have one set of instructions that > says "connect to db.modwest.com" (as opposed to 'read from here, write > to there', or 'connect to db2 if your domain name starts with M-Z'). Of > course on the invisible backend, multiple servers would be servicing > these requests. Tell them to connect to db.$their_domain.com and setup CNAMEs in DNS that point to their "real" server. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.8: up 32 days, processed 1,005,162,161 queries (357/sec. avg) --------------------------------------------------------------------- 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