[Webdev] mysql replication

[John Moylan]

Thomas,

This sort of replication is designed to add resiliance in case server A
or Server B go down. EG, you can have two servers load balancing using
LVS, they are replicating eachothers data and it makes no big deal if
one goes down or if you have to take one down for upgrades/maintenance.


John Moylan



Thomas Bridge wrote:
> 
> At 15:01 15/09/2000 +0100, Donncha O Caoimh wrote:
> >Two database servers/machines, A and B. Any writes/updates to A also
> >happen to B, magically!
> >It's fairly easy to setup and we had stock market information streaming
> >into db A for a few minutes and it seemed to be propogated into db B no
> >problem.
> 
> >There is one outstanding (known) bug for which there's a patch available
> >but that'll be cleared up for 3.23.25. I think it had something to do
> >with INSERT DELAYED so keep away from them for a while.
> 
> Any feedback on the robustness of this?   In particular - what happens if
> database A goes down for some reason?
> 
> T.
> 
> Thomas Bridge                           26 Upper Fitzwilliam St.,
> Head of the Network Operations Centre   Dublin 2,
> VIA NET.WORKS Ireland.                  Ph: +353 1 6763600
> thomas.bridge at via-net-works.ie          Fax: +353 1 6627674
> 
> _______________________________________________
> Webdev mailing list
> Webdev at linux.ie
> http://www.linux.ie/mailman/listinfo/webdev