[prog] MySQL performance question

[jennyw]

Moreover, you can have the different databases on different disk sub-systems 
(if you have that option) which would make things faster on a single 
machine.

Of course, I've never run a few hundred instances on MySQL. Web hosts do it 
all the time, though, so I don't think there's much of a problem with that 
...

Jen


----- Original Message ----- 
From: "Yaroslav Fedevych" <jaroslaw at linux.org.ua>
To: <programming at linuxchix.org>
Sent: Tuesday, July 05, 2005 10:02 AM
Subject: Re: [prog] MySQL performance question


> On Tue, Jul 05, 2005 at 09:10:13AM -0700, April wrote:
>> I need to set up a farm of a database heavy program (MediaWiki).
>> Eventually, there will be a few hundred instances of MediaWiki running
>> on the same server.  Performance-wise, is it better to have a new mySQL
>> database for each one, or stick them all on one database?
>
> Well... AFAIK Mediawiki needs a separate database anyway (I am running
> one). Moreover, when you wish to migrate one of the wikis onto a
> separate server, using separate databases will save you a lot of
> migraine.
>
> -- 
> X windows: Power tools for power losers.
>
> _______________________________________________
> Programming mailing list
> Programming at linuxchix.org
> http://mailman.linuxchix.org/mailman/listinfo/programming
>