On Mon, Jul 16, 2001 at 12:40:24PM +1000, William Chi wrote:
> Hi,
>
> I was wondering if anyone has any opinions on the advantages and
> disadvantages of running multiple servers on one machine. Each
> server would be used to access different databases.
Off the top of my head, since I haven't seen a reply yet...
Benefits:
* If one crashes, the other does not.
* You could run them under different userids.
* You could run different versions of MySQL.
Disadvantages:
* You'll probably use more memory that way.
* Client applications have to be configured to use different port
numbers. This may or may not be trivial.
* You have more servers to monitor.
* Usernames and passwords are not shared across the servers.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 <-- NEW
MySQL 3.23.29: up 33 days, processed 257,419,842 queries (90/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
