MySQL replication help

Last night I had a conversation with a colleague who is setting up a set of MySQL servers, he was specifically asking me about replication, so I came up with a bullet list of items. No great revelations and there is still a lot of work to be done to get some of these ideas going, but it is starting point…

Read the whole post for a good set of principles/tips/techniques. One thing that François forgot to mention was the real crux of using replication for load-balancing: MySQL replication is single-threaded. So depending on your load, you could in fact use it for load balancing reads. But I’m not the expert and am just learning this whole sharding strategy.