High Performance MySQL: Optimization, Backups, and Replication

Description

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

Get the book

Amazon.com

Search the book

eBay.com

Search the book

Other editions

• 

  High Performance MySQL

  • 2021-10-18
  • 389 pages
  • Paperback
  • "O'Reilly Media, Inc."
• 

  High Performance MySQL

  • 2021-10-18
  • 388 pages
  • Ebook
  • "O'Reilly Media, Inc."
• 

  High Performance MySQL: Optimization, Backups, and Replication

  • 2012-03-23
  • 827 pages
  • Paperback
  • "O'Reilly Media, Inc."
• 

  High Performance MySQL: Optimization, Backups, and Replication

  • 2012-03-05
  • 826 pages
  • Ebook
  • "O'Reilly Media, Inc."

Similar books

• 

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

  By Baron Schwartz, Peter Zaitsev, Vadim Tkachenko

  High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL.

• 

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

  By Jeremy D. Zawodny, Derek J. Balling

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

• 

  Efficient MySQL Performance

  By Daniel Nichter

  This practical book bridges the gap by teaching software engineers mid-level MySQL knowledge beyond the fundamentals, but well shy of deep-level internals required by database administrators (DBAs).

• 

  MySQL 8 Query Performance Tuning: A Systematic Method for Improving Execution Speeds

  By Jesper Wisborg Krogh

  This book will help you make query tuning an integral part of your daily routine through a multi-step process that includes monitoring of execution times, identifying candidate queries for optimization, analyzing their current performance, ...

• 

  High Performance MySQL: Optimization, Backups, and Replication

  By Silvia Botros, Jeremy Tinley

  This guide also teaches database administrators safe and practical ways to scale applications through replication, load balancing, high availability, and failover.

• 

  MariaDB High Performance

  By Pierre MAVRO

  This book is aimed at system administrators/architects or DBAs who want to learn more about how to grow their current infrastructure to support larger traffic.

• 

  Advanced MySQL 8: Discover the full potential of MySQL and ensure high performance of your database

  By Eric Vanier, Birju Shah, Tejaswi Malepati

  What you will learnExplore new and exciting features of MySQL 8.0Analyze and optimize large MySQL queriesUnderstand MySQL Server 8.0 settingsMaster the deployment of Group Replication and use it in an InnoDB clusterMonitor large distributed ...

• 

  Learning MySQL

  By Hugh E. Williams, Saied M.M. Tahaghoghi

  Presents instructions on using MySQL, covering such topics as installation, querying, user management, security, and backups and recovery.

• 

  MySQL Stored Procedure Programming: Building High-Performance Web Applications in MySQL

  By Steven Feuerstein, Guy Harrison

  A full tutorial on J2EE database programming is beyond the scope of this book (and probably beyond the expertise of its authors). However, in this section we will take a quick look at how you might use stored programs within a J2EE ...

• 

  MySQL High Availability: Tools for Building Robust Data Centers

  By Charles Bell, Mats Kindahl, Lars Thalmann

  This practical book explains replication, cluster, and monitoring features that can help protect your MySQL system from outages, whether it’s running on hardware, virtual machines, or in the cloud.