MySQL High Availability: Tools for Building Robust Data Centers

$49.99 $45.57

Server bottlenecks and failures are a fact of life in any database deployment, but they don’t have to bring everything to a halt. This practical book explains replication, cluster, and

Quantity

Server bottlenecks and failures are a fact of life in any database deployment, but they don’t have to bring everything to a halt. 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.

Written by engineers who designed many of the tools covered, this book reveals undocumented or hard-to-find aspects of MySQL reliability and high availability—knowledge that’s essential for any organization using this database system. This second edition describes extensive changes to MySQL tools. Versions up to 5.5 are covered, along with several 5.6 features.

  • Learn replication fundamentals, including use of the binary log and MySQL Replicant Library
  • Handle failing components through redundancy
  • Scale out to manage read-load increases, and use data sharding to handle large databases and write-load increases
  • Store and replicate data on individual nodes with MySQL Cluster
  • Monitor database activity and performance, and major operating system parameters
  • Keep track of masters and slaves, and deal with failures and restarts, corruption, and other incidents
  • Examine tools including MySQL Enterprise Monitor, MySQL Utilities, and GTIDs

Frequently Bought Together

  • MySQL High Availability: Tools for Building Robust Data Centers
    +
  • High Performance MySQL: Optimization, Backups, and Replication
    +
  • Effective MySql Backup and Recovery (Oracle Press) (Oracle (McGraw-Hill))
    +
  • Effective MySQL Replication Techniques in Depth
  • Price for all: $85.22
Author

Charles Bell, Mats Kindahl, Lars Thalmann

Binding

Paperback

Brand

Brand: O’Reilly Media

EAN

9781449339586

EANList

9781449339586

Edition

Second Edition

ISBN

1449339581

IsEligibleForTradeIn

1

ItemDimensions

156, hundredths-inches, 915, hundredths-inches, 267, hundredths-pounds, 710, hundredths-inches

Label

O’Reilly Media

Languages

English, Unknown, English, Original Language, English, Published

Manufacturer

O’Reilly Media

NumberOfItems

1

NumberOfPages

762

ProductGroup

Book

PublicationDate

2014-04-28

Publisher

O’Reilly Media

Studio

O’Reilly Media

TradeInValue

1447, USD, $14.47