Risharde's Blog

For some reason, when I implemented mysql replication about 1 month ago, the databases went out of sync. Not certain as to what happened. Since then, I've added 3 servers to do replication excluding my master server.

I'll be check it this week but it seems everything today synchronized nearly instantaneously which is great. I can see the potential in doing this but applications will have to be modified to do updates to master only and possible reads from 1 out of the 3 servers (perhaps 4 if you include the master).

I suppose that one could round rubbing via DNS A records in which the hostname points to multiple ip addresses but different client applications deal with this in many different ways and some don't implement a choice function.

I suppose on a simplistic level, having a server as the frontend to forward to other servers could work as well.

Heartbeat on a server might be a better solution as well. Over the few weeks I'll be working on such a project if I can't find one on the internet.

Rsync is nice to replicate the website data and I only tested it a little while ago, nice to have file transfers over the encrypted SSH tunnels.