I don't know much about replication, but I'd like to learn. Can you recommend any books/courses/tutorials that address the sorts of design decisions you're talking about?
- High Performance MySQL (Schwartz et al)
- MySQL High Availability (Bell et al)