Error message

Strict warning: Declaration of views_handler_field_amazon_participant::pre_render() should be compatible with views_handler_field::pre_render(&$values) in require_once() (line 3 of /var/www/mysqlresources-drupal/modules/amazon/includes/views_handler_field_amazon_participant.inc).

High Availability of MySQL

These are books related to performance tuning and maintaining a high availability of MySQL service. This includes MySQL Cluster and Replication books

MySQL Replication

  • author: Russell J.T. Dyer
  • publisher: A Silent Killdeer Publishing
  • list price: $15.00
  • price: $15.00
  • year: 2010
  • pages: 208
  • isbn: 9780983185406
  • overall rating:
  • skill level:
  • technical level:

Replication is an excellent way to protect data and ensure uninterrupted service. For systems administrators who know the basics of MySQL, this book can help them to learn about MySQL Replication and assist them in keeping replication running or to get it running again when it inevitably stops.

High Performance MySQL

  • author: Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
  • edition: 3
  • publisher: O'Reilly Media
  • list price: $54.99
  • price: $32.96
  • year: 2012
  • pages: 826
  • isbn: 9781449314286
  • overall rating:
  • skill level:
  • technical level:

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.

Book Review:

Effective MySQL Replication Techniques in Depth

  • author: Ronald Bradford, Chris Schneider
  • edition: 1
  • publisher: McGraw-Hill Education
  • list price: $27.00
  • price: $26.94
  • year: 2012
  • pages: 296
  • isbn: 9780071791861

This book describes what is needed to understand and implement MySQL replication to build scalable solutions. This book includes detailed syntax examples to demonstrate the features, options, and limitations of native MySQL replication. Providing an evaluation of various new replication features and additional third-party product implementations, this Oracle Press guide helps to ensure your MySQL environment can support the various high-availability needs of your business.

Effective MySQL Backup and Recovery

  • author: Ronald Bradford
  • edition: 1
  • publisher: McGraw-Hill Education
  • list price: $25.00
  • price: $18.29
  • year: 2012
  • pages: 256
  • isbn: 9780071788571

This book covers all the options with detailed descriptions and syntax examples to ensure an appropriate backup and recovery plan can be developed. Featuring a side-by-side evaluation of the various backup strategies and complementary recovery implementations, this Oracle Press book helps you to protect your MySQL data from a wide range of disaster situations.

Effective MySQL Optimizing SQL Statements

  • author: Ronald Bradford
  • edition: 1
  • publisher: McGraw-Hill Education
  • list price: $37.00
  • price: $25.86
  • year: 2011
  • pages: 184
  • isbn: 9780071782791

This book is filled with detailed explanations and practical examples that can be applied immediately to improve database and application performances. Featuring a step-by-step approach to SQL optimization, this Oracle Press book helps you to analyze and tune problematic SQL statements.

High Availability MySQL Cookbook

  • author: Alex Davies
  • publisher: Packt Publishing
  • list price: $44.99
  • year: 2010
  • pages: 276
  • isbn: 9781847199942

This book uses the approach of a cookbook. Each recipe provides the reader with easy step-by-step descriptions of the actions necessary to accomplish a specific task. It is designed to present what often appear as extremely complicated techniques as a series of simple-to-follow recipes, allowing readers to achieve high uptimes on their MySQL servers. This book is targeted at system administrators or database administrators who have basic familiarity with Linux, the shell, and MySQL.

MySQL Clustering

  • author: Alex Davies, Harrison Fisk
  • edition: 1
  • publisher: MySQL Press
  • list price: $44.99
  • price: $44.99
  • year: 2006
  • pages: 216
  • isbn: 9780672328558

Clustering is the final component of MySQL that makes it truly enterprise-level and able to compete fully with proprietary databases such as Oracle and Microsoft SQL Server. The increased number of high-demand, high-productivity corporations and institutions choosing MySQL. This books offers thorough, authoritative instruction on setting up and administering a MySQL Cluster from the developers of the cluster itself. You will learn about everything from installation and configuration to performance and troubleshooting in this authoritative reference guide to MySQL clustering.