On Thu, Jun 14, 2001 at 05:05:56PM -0700, Justin Bauer wrote:
> You can do load balancing, you just need to have the same information on
> each server. With mysql you would use "Replication" to keep the servers
> sync'ed.
Well, then you'd have to do 2way replication. And that doesn't work great with
AUTO_INCREMENT fields, etc AFAIK :< And since I have no way of controlling query's
(it's a database-server for our customers), I don't think that's going to
work...*argh* :>>>
> Once you have a few servers with the same information, you have a few
> options. You can use round-robin dns, or use a load balancing machine.
>
> hope this helps,
Thx :>
> Justin
>
>
> > 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
> >
--
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
