High Performance MySQL: Optimization, Backups, Replication, Load Balancing & More

High Performance MySQL Optimization Backups Replication Load Balancing More As users come to depend on MySQL they find that they have to deal with issues of reliability scalability and performance issues that are not well documented but are critical to a smoothly functioni

  • Title: High Performance MySQL: Optimization, Backups, Replication, Load Balancing & More
  • Author: Jeremy D. Zawodny Derek J. Balling
  • ISBN: 9780596003067
  • Page: 149
  • Format: Paperback
  • As users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance issues that are not well documented but are critical to a smoothly functioning site This book is an insider s guide to these little understood topics.Author Jeremy Zawodny has managed large numbers of MySQL servers for mission critical work at YahooAs users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance issues that are not well documented but are critical to a smoothly functioning site This book is an insider s guide to these little understood topics.Author Jeremy Zawodny has managed large numbers of MySQL servers for mission critical work at Yahoo , maintained years of contacts with the MySQL AB team, and presents regularly at conferences Jeremy and Derek have spent months experimenting, interviewing major users of MySQL, talking to MySQL AB, benchmarking, and writing some of their own tools in order to produce the information in this book.In High Performance MySQL you will learn about MySQL indexing and optimization in depth so you can make better use of these key features You will learn practical replication, backup, and load balancing strategies with information that goes beyond available tools to discuss their effects in real life environments And you ll learn the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs.Topics include A review of configuration and setup optionsStorage engines and table typesBenchmarkingIndexesQuery OptimizationApplication DesignServer PerformanceReplicationLoad balancingBackup and RecoverySecurity

    One thought on “High Performance MySQL: Optimization, Backups, Replication, Load Balancing & More”

    1. A *great* book for anyone who wants to understan mysql better and how to tune it. I particularly liked it because it started at the basics with a conceptual overview, then dived into details. There are probably even more details it didn't go into, so I'll start looking for the next book. But this one was invaluable.

    2. We live in an age where information—or at least something like it—abounds. Relational database theory allows us to abstract information into perfect sets of interlocking truths amenable to mathematical manipulation. Hence we may employ computers to generate rare topologies of meaning from our vast stores of data. Our machines increase in power, but the vast stores of data they shepherd into relevance increases even more; theory becomes practice, practice towers and then scales to collapse, a [...]

    3. Some excellent tips in here, particularly the sections on table types and indexes. More of a reference work that you'll dip into than something to read from cover to cover - e.g. I keep a printed copy of the explanation of EXPLAIN columns on my desk.If you have the electronic version from O'Reilly, make sure you download the latest copy as there was a second release in 2015.

    4. The standard book for everyone who wants to learn more about MySQL performance. The book is written by multiple authors and that shows in that different sections easier or harder to read but the overall level of information is very good. The book does require some basic knowledge about MySQL and relational databases in general.

    5. This a decent book for admins -- well written and easy to read, much more so than the manual. However, it is dated and only covers versions of MySQL up to 4.1 -- too bad as everyone should be using 5.0 nowadays. A good starting point for replication, backups, and optimization. [Read cover-to-cover]

    6. For anyone building a solution based on MySQL whether its getting the most out of a hosted database, or building a multi-tier master slave replication fan-out, this book will offer great insight from people who've probably already done what you're trying to do. I tend to keep it within reach so that I can flip through the index of the book before googling for the answer to a question.

    7. This book is a must read for those working with MySql and concerned with performance. It's not a large book, but it's dense with practical information and if you work with large datasets or complex schemas/queries, it's an invaluable reference.

    8. Just started it but so far it is very informative (if you haven't already taken advanced mysql database courses)

    9. The ultimate book to learn the in and outs of advance MySQL, beyond just writing queries. Made me more eager to learn about database.

    10. A highly educational, if challengingly dry at times, read. I'm only a chapter in, but I can already tell it's going to improve my understanding of MySQL and how to use it.

    11. This book likes wiki for me. Derek has good talent to write in technical description. I love this book. Derek give me many new things about MySQL.

    12. Огромная книга с избыточной подачей материала для простого чтения. Можно прочесть главы по оптимизации запросов, индексам, движкам и тюнингу конфига. Остальное можно дочитывать по мере необходимости.

    13. This book is gold. Everything you wanted to know about MySQL that you can't easily Google, organized in a useful way.

    Leave a Reply

    Your email address will not be published. Required fields are marked *