On Fri, Jun 15, 2001 at 09:54:32AM +0200, Wouter de Jong wrote:
> 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* :>>>
What`s wrong with the most obvious way:
database1.widexs.nl
database2.widexs.nl
database3.widexs.nl
?
Just tell them on which server there dbaseaccount lives and they are happy.
But that`s probably the way it is right now.
Just curious,
Harmen
> > > > 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)
--
The Moon is Waning Crescent (37% of Full)
nieuw.nl - 2dehands.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
