Bonjour Michael,
>>>>>> "BAUMEISTER" == BAUMEISTER Alexandre <[EMAIL PROTECTED]> writes:
BAUMEISTER>> Bonjour,
BAUMEISTER>> Would it be reliable to have two servers with a mysql daemon on each
BAUMEISTER>> one and with the database files on the hard disk of one of the two
BAUMEISTER>> servers, the second one accessing the database through NFS mount ?
BAUMEISTER>> As someone already done that ?
BAUMEISTER>> Here is what I want to do :
BAUMEISTER>> I would like to use a load balancing system for my actual database
BAUMEISTER>> server which is a little overloaded by the quantity of requests it
BAUMEISTER>> gets. So I'm looking for a way to share the database between two
BAUMEISTER>> computer in order to get more power from the database system.
BAUMEISTER>> If this is possible, will the system with two computer be really
BAUMEISTER>> more preferment than 1 server, 1 database or will it be limited by
BAUMEISTER>> the use of a single hard drive ?
MW> Hi!
MW> The above will not help; Sharing files over NFS will make the
MW> database 5 times slower. The easiest way to balance load is to get a
MW> second CPU or another hard disk and balance your tables on different
MW> hard disks!
But how can I balance tables files over multiple disks ? Is there a
way to tell Mysql to use this disk for this table and this other disk
for this other table ... ?
Alex.
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
