"High Performance MySQL" ByJeremy D. Zawodny, Derek J. Balling — It's been very helpful to me
http://oreilly.com/catalog/9780596003067 http://www.amazon.com/High-Performance-MySQL-Jeremy-Zawodny/...
"High Performance MySQL" ByJeremy D. Zawodny, Derek J. Balling — It's been very helpful to me
http://oreilly.com/catalog/9780596003067 http://www.amazon.com/High-Performance-MySQL-Jeremy-Zawodny/...
http://www.amazon.com/High-Performance-MySQL-Jeremy-Zawodny/...
You can learn the basics of MySQL online or through just about any book, but once you've gotten beyond that and want to learn more, this book is loads better than all the others.
I really don't like code that "hacks together" a solution and then requires a substantial remedy later (who does?!) so I'm quite interested in getting it right from the beginning.
Assuming that many of us here develop web applications, and that some are going to need to scale heavily, what do you recommend as a good solution?
I have yet to read either of these two books, but they are on my list (I only have one at home, the other I'll order): http://www.amazon.co.uk/Building-Scalable-Web-Sites-Henderso... http://www.amazon.co.uk/Performance-MySQL-Advanced-Technique...
Both are O'Reilly so I'm assuming they'll be good!
Let me know if you have any other resources for this, because I imagine it's a very common issue for successful startups.
If you think that automatic sharding is the answer to handle high loads then your are in for a very exciting surprise specially when things go awry and all that missing ACID compliance comes knocking...