On Tue, Jan 16, 2001 at 03:41:14PM +0800, Ganen Ganeswaran wrote:
> I'm a relative newbie in mySQL. I have 10 mySQL databases. At the
> moment I'm only using 1 of the databases. I was wondering if it's
> possible (and how) to setup some sort of replication/load balancing
> between all 10 dbs. Basically I want the information in one db
> replicated across the other 9. I also read some documentation that
> said that there can only be 100 simultaneous connections at any one
> time to a single databse, so I would like some sort of load
> balancing across these 10dbs (would I need to implement this myself,
> or is this inherent with mySQL?). Thanks in advance...
Oh, let's see...
(1) Do you have 10 databases or 10 database servers? I'm a bit
unclear based on your description?
(2) The limit of 100 clients per server is default which can be
changed. Some folks have had many, many more than that on a
reasonably configured server.
You can use MySQL replication to do some load balancing. You can have
a master database server (db0) and then configured db[1-9] as slaves
which get all their updates from db0. Then code your software to send
all updates to db0 and the bulk of your read-only queries to one of
the slaves. Which slave? It's up to you.
Does that help a bit?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
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