My organisation has been looking into how to spread our servers around geographically while keeping backups very up to date, and ideally spreading the load.
The initial thing I have in mind is Rails on MySQL. The write rate isn't too high (articles/comments being left at less than 1 per minute, though some have large media attachments).
- does MySQL replication work well across wide area networks?
- Does the connection (or a slave server) going down mean that manual intervention is required (once the two servers can talk to each other again) or is recovery automatic?
- If the master disappears, what is required to turn a slave into a master? Are there standard scripts/tools to help manage that?
- Any other gotchas etc?