Emiliano Heyns <[EMAIL PROTECTED]> said:
> Emiliano wrote:
>
> > anyway part of the demo is a cluster of servers sitting behind a load
> > balancer/heartbeat.. - We have installed the mysql replication (not
> > repliguard) to test it out - anyway, it seem to replicate, however you
_can_
> > send queries to the slaves and they will update _locally_ and not
replicate! -
> > this eventuall causes the whole replication to fall apart!!!!
>
> Not much of a replication mechanism BTW. Is this MySQL internal?
Yes, as per the manual :)
You can send select requests to the slave (eg. localhosts) and it will
obviously take the load off the master..
but you _must_ send the update and insert requests to the master..
we used ldirectord and ipvsadm to do the loadbalancing/heartbeat - seems to
work pretty well.. - At present I have just created a special domain for the
admin server so that it only resolves to the master SQL server. - so updating
is done on 1 machine and all machines other machines read for their local
slaved mirror.
obviously this will fall down if any of the web pages makes a mgd_update
call!!
It's pretty cool pulling the ethernet / power out of one and watching it stay
up.. - It also uses ext3 which gets rid of fsking!!
regards
alan
>
> Does anyone have experiences (first-, second- or Xth-hand experience,
> whatever)
> on recall (http://www.fault-tolerant.org/recall/)? This definately
> looks
> like something I want to use for Midgard at some point.
>
> Emile
>
> --
> This is The Midgard Project's mailing list. For more information,
> please visit the project's web site at http://www.midgard-project.org
>
> To unsubscribe the list, send an empty email message to address
> [EMAIL PROTECTED]
>
>
>
--
Technical Director
Linux Center (HK) Ltd.
www.hklc.com
--
This is The Midgard Project's mailing list. For more information,
please visit the project's web site at http://www.midgard-project.org
To unsubscribe the list, send an empty email message to address
[EMAIL PROTECTED]
