High Performance MySQL: Optimization, Backups, Replication, and More

High Performance MySQL: Optimization, Backups, Replication, and More

Paperback

By (author) Baron Schwartz, By (author) Peter Zaitsev, By (author) Vadim Tkachenko

$33.77
List price $55.45
You save $21.68 39% off

Free delivery worldwide
Available
Dispatched in 3 business days
When will my order arrive?

  • Publisher: O'Reilly Media, Inc, USA
  • Format: Paperback | 828 pages
  • Dimensions: 180mm x 234mm x 56mm | 1,270g
  • Publication date: 13 April 2012
  • Publication City/Country: Sebastopol
  • ISBN 10: 1449314287
  • ISBN 13: 9781449314286
  • Edition: 3, Revised
  • Edition statement: 3rd Revised edition
  • Sales rank: 87,689

Product description

High Performance MySQL teaches you advanced techniques in depth so you can bring out MySQL's full power. Learn how to design schemas, indexes, queries, and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, operating system, and hardware to their fullest potential. You'll also learn practical, safe, high-performance ways to scale your applications with replication, load balancing, high availability, and failover. This third edition is completely revised and reflects recent advances in MySQL and InnoDB performance, features, and tools. Major additions include: * Achieving high performance with MySQL in the cloud * Using the new features in MySQL 5.5 * Taking advantage of modern multi-core CPUs and solid-state disks * Improvements in replication, high availability, and new clustering options * New tools for hot online backups The book also includes chapters on benchmarking, profiling, backups, cloud computing, solid-state disks, and tools and techniques to help you measure, monitor, and manage your MySQL installations.

Other people who viewed this bought:

Showing items 1 to 10 of 10

Other books in this category

Showing items 1 to 10 of 10
Categories:

Author information

Baron Schwartz is a software engineer who lives in Charlottesville, Virginia and goes by the online handle of "Xaprb," which is his first name typed in QWERTY on a Dvorak keyboard. When he's not busy solving a fun programming challenge, he relaxes with his wife Lynn and dog Carbon. He blogs about software engineering at http://www.xaprb.com/blog/. A former manager of the High Performace Group at MySQL AB, Peter Zaitsev now runs the mysqlperformanceblog.com site. He specializes in helping administrators fix issues with Web sites handling millions of visitors a day, dealing with terabytes of data using hundreds of servers. He is used to making changes and upgrades both to hardware to software (such as query optimization) in order to find solutions. He also speaks frequently at conferences. Vadim Tkachenko was a Performance Engineer in at MySQL AB. As an expert in multithreaded programming and synchronization, his primary tasks were benchmarks, profiling, and finding bottlenecks. He also worked on a number of features for performance monitoring and tuning, and getting MySQL to scale well on multiple CPUs.

Review quote

"Das Buch liest sich fast wie ein Roman. Man legt es nicht mehr aus der Hand, denn die einzelnen Kapitel erzeugen steile Lern- und Spannungskurven. Ich wünschte, die Schulbücher in meiner Kindheit wären in demselben Stil verfasst worden." - $foo Perl Magazin, 3/2012