Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Can anyone refer me a good book or a small tutorial for various use cases for database design on MySQL for high load test/high availability scenarios.

It should include the following:

  1. What are the various scenarios/solutions for high availability?

  2. What are the various scenarios for high load and how to cater them based on reliability, response time, throughput etc.

I am particularly interested if someone knows of a practical experience book for both of these cases.

share|improve this question

closed as off-topic by Mark Storey-Smith, ypercubeᵀᴹ, RLF, RolandoMySQLDBA, Paul White Oct 27 '14 at 15:39

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Mark Storey-Smith, ypercubeᵀᴹ, RLF, RolandoMySQLDBA, Paul White
If this question can be reworded to fit the rules in the help center, please edit the question.

I read these:

  1. MySQL High Availability
  2. High Performance MySQL

They are good enough.

share|improve this answer

High Performance MySQL, 3rd edition, is by far the best book out there on performance and other issues. I have a bookshelf of 20+ MySQL books, some of which deal with performance. None are as clear, insightful or full as this book.

You should also note the 3rd edition has just been published a few months ago, and it is very up-to-date with current MySQL development.

Among other issues, it speaks of:

  • Schema design
  • Indexing
  • Performance tuning
  • High availability
  • MySQL on the cloud
  • Benchmarking
  • Profiling

And lots more. Is is very practical and is based on the experience of its authors as employees/founders of Percona, a MySQL consulting company, as consultants and developers of MySQL and popular MySQL tools.

The MySQL High Availability book suggested in another answer, is centralized around MySQL replication. It is a good book, but does not provide with a thorough review & comparison of available HA solutions. It is authored by developers of Replication within Oracle/MySQL and covers replication in great depth.

There's a High Availability MySQL Cookbook, which provides a good overview of available HA solutions (already out-of-date as of Galera's appearance, and the demise of other solutions). I think it shows the basics well, so you can get the general picture.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.