Re: [cobalt-users] Looking for Near 100% Up Time for a Very Vocal Hosting Customer

[Alex Krohn <alex@xxxxxxxxxxxxxxxxxxxx>]

Hi Kam,

> >Never tried it with raq's, but I don't see why it wouldn't work there as well.
> >The tricky part is keeping the data in sync, but depending on your needs, you
> >can use things such as rsync, mysql server replication, or nfs.
> 
> Alex could you please elaborate on how you perform MySQL server replication ?
> Or please point me to a resource which explains how to do it in more detail ?
> 
> I've been looking for an effective way to do this for a wee while now :-)

Well, there isn't a generic answer, you typically need to tailor it to the
application. A good start would be to read over:

http://www.mysql.com/doc/en/Replication.html

You can have the backup server be a slave to the master server, and setup
heartbeat/fake to turn it into master if things fails. You can also separate
read/write database handles to different servers.

Hope that helps,

Alex