My personal opinion on that is that it's another layer of complexity without too much to gain. It's something else to manage (operational overhead), and something else to interact with (programmer overhead).

MySQL by itself is plenty fast for us. As Baron mentioned, we don't even run the database servers at full capacity.