On Wed, Jun 13, 2001 at 08:55:50PM +0200, Sven Huster wrote:
> Hi
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
Thanks, I'll skip the plan. No load-balancing for me thus :>
> 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
> >
> >
--
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