High Performance MySQL

Optimization, Backups, Replication, Load Balancing & More

Nonfiction, Computers, Database Management
Cover of the book High Performance MySQL by Jeremy D. Zawodny, Derek J. Balling, O'Reilly Media
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Jeremy D. Zawodny, Derek J. Balling ISBN: 9780596555160
Publisher: O'Reilly Media Publication: April 8, 2004
Imprint: O'Reilly Media Language: English
Author: Jeremy D. Zawodny, Derek J. Balling
ISBN: 9780596555160
Publisher: O'Reilly Media
Publication: April 8, 2004
Imprint: O'Reilly Media
Language: English

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 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 options
  • Storage engines and table types
  • Benchmarking
  • Indexes
  • Query Optimization
  • Application Design
  • Server Performance
  • Replication
  • Load-balancing
  • Backup and Recovery
  • Security
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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 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:

More books from O'Reilly Media

Cover of the book Getting Started with Impala by Jeremy D. Zawodny, Derek J. Balling
Cover of the book Appcelerator Titanium: Up and Running by Jeremy D. Zawodny, Derek J. Balling
Cover of the book Das Spotify-Buch by Jeremy D. Zawodny, Derek J. Balling
Cover of the book Applied Text Analysis with Python by Jeremy D. Zawodny, Derek J. Balling
Cover of the book You Don't Know JS: this & Object Prototypes by Jeremy D. Zawodny, Derek J. Balling
Cover of the book Just Spring Data Access by Jeremy D. Zawodny, Derek J. Balling
Cover of the book Office 2011 for Macintosh: The Missing Manual by Jeremy D. Zawodny, Derek J. Balling
Cover of the book CSS: The Missing Manual by Jeremy D. Zawodny, Derek J. Balling
Cover of the book Designing Mobile Interfaces by Jeremy D. Zawodny, Derek J. Balling
Cover of the book qmail by Jeremy D. Zawodny, Derek J. Balling
Cover of the book You Don't Know JS: Types & Grammar by Jeremy D. Zawodny, Derek J. Balling
Cover of the book Apache 2 Pocket Reference by Jeremy D. Zawodny, Derek J. Balling
Cover of the book Creating Keynote Slideshows: The Mini Missing Manual by Jeremy D. Zawodny, Derek J. Balling
Cover of the book Microinteractions: Full Color Edition by Jeremy D. Zawodny, Derek J. Balling
Cover of the book JavaScript Patterns by Jeremy D. Zawodny, Derek J. Balling
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy