High Performance MySQL

Optimization, Backups, and Replication

Nonfiction, Computers, Database Management
Cover of the book High Performance MySQL by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko, O'Reilly Media
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Baron Schwartz, Peter Zaitsev, Vadim Tkachenko ISBN: 9781449332495
Publisher: O'Reilly Media Publication: March 5, 2012
Imprint: O'Reilly Media Language: English
Author: Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
ISBN: 9781449332495
Publisher: O'Reilly Media
Publication: March 5, 2012
Imprint: O'Reilly Media
Language: English

How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.

Updated to reflect recent advances in MySQL and InnoDB performance, features, and tools, this third edition not only offers specific examples of how MySQL works, it also teaches you why this system works as it does, with illustrative stories and case studies that demonstrate MySQL’s principles in action. With this book, you’ll learn how to think in MySQL.

  • Learn the effects of new features in MySQL 5.5, including stored procedures, partitioned databases, triggers, and views
  • Implement improvements in replication, high availability, and clustering
  • Achieve high performance when running MySQL in the cloud
  • Optimize advanced querying features, such as full-text searches
  • Take advantage of modern multi-core CPUs and solid-state disks
  • Explore backup and recovery strategies—including new tools for hot online backups
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.

Updated to reflect recent advances in MySQL and InnoDB performance, features, and tools, this third edition not only offers specific examples of how MySQL works, it also teaches you why this system works as it does, with illustrative stories and case studies that demonstrate MySQL’s principles in action. With this book, you’ll learn how to think in MySQL.

More books from O'Reilly Media

Cover of the book Kindle: The Mini Missing Manual by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
Cover of the book Photoshop Elements 4: The Missing Manual by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
Cover of the book iPod: The Missing Manual by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
Cover of the book The Human Side of Postmortems by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
Cover of the book Building iPhone Apps with HTML, CSS, and JavaScript by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
Cover of the book JUNOS Enterprise Routing by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
Cover of the book Mining the Social Web by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
Cover of the book Knoppix Hacks by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
Cover of the book Designing Data-Intensive Applications by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
Cover of the book Hands-On Sencha Touch 2 by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
Cover of the book Extreme Programming Pocket Guide by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
Cover of the book QuickBooks 2005: The Missing Manual by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
Cover of the book C# Database Basics by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
Cover of the book Active Directory Cookbook by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
Cover of the book Essential SNMP by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
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