Hi
As far as i know, DON'T DO THIS
mysql with serveral instances accessing the same database will not work
as expected.
check
http://www.mysql.com/doc/M/u/Multiple_servers.html
we run mysql over nfs but only with one instance.
seems to be quite stable (db server freebsd - nfs server netapp filer)
regards
Sven Huster
Senior IT Systems Engineer
> -----Original Message-----
> From: Wouter de Jong [mailto:[EMAIL PROTECTED]]
> Sent: 13 June, 2001 10:21
> To: [EMAIL PROTECTED]
> Subject: load-balancing with NFS
>
>
> *This message was transferred with a trial version of
> CommuniGate(tm) Pro*
> Hello,
>
> I have an idea about setting up 1 machine that contains the
> var-directory (RAID5 for backup, etc). Then I mount the var
> directory from 2 (to explain now :>) other servers, via NFS,
> and run mysqld on those.
>
> My question : is this going to work ? I mean, will mysqld
> allow me to have a shared /var/ directory for all databases
> inside ? I want load-balancing, cause my server can't handle
> the pressure good anymore.
>
> database-01 IN A 192.168.0.101
> database-01 IN A 192.168.0.102
>
> 192.168.0.101: (running mysqld)
> 192.168.0.100:/opt/database/mysql/var /opt/database/mysql/var
>
> 192.168.0.102: (running mysqld)
> 192.168.0.100:/opt/database/mysql/var /opt/database/mysql/var
>
> 192.168.0.100: will be NFS-mounted by the 2 mysqld machines
>
> And how to configure MySQL with RAID(5) (3 disks, 1 spare) ?
> Is --with-raid anough, and everything will go automatically
> good ? I don't have to use other table-types then MyISAM ?
>
> Thanks for any input :>
>
> --
> Met vriendelijke groet/With kind regards,
>
> Cable & Wireless http://www.widexs.nl
> Wouter de Jong System-Administrator
> Tel +31 23 5698070 Fax +31 23 5698099
> Bijlmermeerstraat 62, 2131 HG HOOFDDORP, NL
>
> ---------------------------------------------------------------------
> 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
