High Performance MySQL: Optimization, Backups, and Replication

( 2 )

Overview

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

See more details below
Paperback (Third Edition)
$31.80
BN.com price
(Save 42%)$54.99 List Price
Pick Up In Store

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (19) from $21.33   
  • New (14) from $31.03   
  • Used (5) from $21.33   
High Performance MySQL: Optimization, Backups, and Replication

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$26.99
BN.com price
(Save 42%)$46.99 List Price

More About This Book

Overview

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
Read More Show Less

Product Details

  • ISBN-13: 9781449314286
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 3/30/2012
  • Edition description: Third Edition
  • Edition number: 3
  • Pages: 828
  • Sales rank: 320852
  • Product dimensions: 7.00 (w) x 9.20 (h) x 1.90 (d)

Meet the Author

Baron Schwartz is Chief Performance Architect at Percona. He createstools and techniques to make MySQL easier to use and more dependable,and speaks regularly at conferences worldwide. He lives in Virginia with his family.

Peter managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Master's Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling. He serves as CEO of Percona, while keeping touch with his technical roots by continuing to do consulting for key customers.

Vadim Tkachenko is the CTO and co-founder of Percona, and an authoron the MySQLPerformanceBlog.com and SSDPerformanceBlog.com blogs. Vadim leads Percona's development group, which produces the Percona Server, Percona XtraDB Cluster, and Percona XtraBackup.

Read More Show Less

Table of Contents

Foreword

Preface

Chapter 1: MySQL Architecture and History

Chapter 2: Benchmarking MySQL

Chapter 3: Profiling Server Performance

Chapter 4: Optimizing Schema and Data Types

Chapter 5: Indexing for High Performance

Chapter 6: Query Performance Optimization

Chapter 7: Advanced MySQL Features

Chapter 8: Optimizing Server Settings

Chapter 9: Operating System and Hardware Optimization

Chapter 10: Replication

Chapter 11: Scaling MySQL

Chapter 12: High Availability

Chapter 13: MySQL in the Cloud

Chapter 14: Application-Level Optimization

Chapter 15: Backup and Recovery

Chapter 16: Tools for MySQL Users

Forks and Variants of MySQL

MySQL Server Status

Transferring Large Files

Using EXPLAIN

Debugging Locks

Using Sphinx with MySQL

Colophon

Read More Show Less

Customer Reviews

Average Rating 5
( 2 )
Rating Distribution

5 Star

(2)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
Sort by: Showing all of 2 Customer Reviews

  • Anonymous

    Posted Fri Jul 12 00:00:00 EDT 2013

    Was this review helpful? Yes  NoThank you for your feedback.   Report this reviewThank you, this review has been flagged.

  • Anonymous

    Posted Fri Jul 12 00:00:00 EDT 2013

    Pierce

    You can stay kat. Nm u

    Was this review helpful? Yes  NoThank you for your feedback.   Report this reviewThank you, this review has been flagged.
Sort by: Showing all of 2 Customer Reviews
If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)