I think the main disadvantage would be the memory... Running two servers
means it would use twice the amount of memory... So say you are using 256mb
for the key cache... running two servers would use 512mb (not the exact
moment the servers start but after a prolonged period of time of course).
This situation gets even worse if you are depending on a larger key cache
for performance.
ryan
----- Original Message -----
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "William Chi" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, July 19, 2001 3:59 AM
Subject: Re: Running multiple MySQL servers on one machine
> 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
>
---------------------------------------------------------------------
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
