MySQL High Availability: Tools for Building Robust Data Centers

MySQL High Availability: Tools for Building Robust Data Centers
ISBN-10
0596807309
ISBN-13
9780596807306
Series
MySQL High Availability
Category
Computers
Pages
624
Language
English
Published
2010-07-05
Publisher
O'Reilly Media
Authors
Charles Bell, Mats Kindahl, Lars Thalmann

Description

Server bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. MySQL has several features that can help you protect your system from outages, whether it's running on hardware, virtual machines, or in the cloud. MySQL High Availability explains how to use these replication, cluster, and monitoring features in a wide range of real-life situations. Written by engineers who designed many of the tools covered inside, 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. Explore the binary log, a file for replication that helps in disaster recovery and troubleshooting Get techniques for improving response time and handling large data sets Monitor database activity and performance, as well as major operating system parameters Keep track of what masters and slaves are doing, and deal with failures and restarts, corruption, and other incidents Automate key tasks with code from an open source library written by the authors Learn techniques for using MySQL in virtualized environments, such as Amazon Web Services Use MySQL Cluster to achieve high availability "MySQL replication is widely deployed but has never been adequately explained. This book changes that." -- Mark Callaghan, MySQL contributor and leader of MySQL engineering efforts at a few of the world's largest Internet companies

Get the book

Amazon.com
Amazon.com
Search the book
eBay.com
eBay.com
Search the book

Other editions

Similar books

  • Introducing InnoDB Cluster: Learning the MySQL High Availability Stack
    Introducing InnoDB Cluster: Learning the MySQL High Availability Stack
    By Charles Bell

    Features described in this book are available in the Community Edition of MySQL, beginning with the version 8.0.11 GA release, making this book relevant for any MySQL users in need of redundancy against failure.

  • High Availability MySQL Cookbook
    High Availability MySQL Cookbook
    By Alex Davies

    Over 60 simple but incredibly effective recipes focusing on different methods of achieving high availability for MySQL database.

  • High Performance MySQL
    High Performance MySQL
    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.

  • High Performance MySQL: Optimization, Backups, Replication, Load Balancing & More
    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 ...

  • Expert MySQL
    Expert MySQL
    By Charles Bell

    This book will interest users deploying MySQL in high-traffic environments and in situations requiring minimal resource allocation.

  • High Performance MySQL: Optimization, Backups, Replication, and More
    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.

  • MySQL High Availability
    By Mats Kindahl, Lars Thalmann, Charles Andrew Bell

    This book changes that."-- Mark Callaghan, MySQL contributor and leader of MySQL engineering efforts at a few of the world's largest Internet companies.

  • Effective MySQL Replication Techniques in Depth
    Effective MySQL Replication Techniques in Depth
    By Chris Schneider, Ronald Bradford

    The Essential Guide to Scaling Your Business Solution Written by Oracle ACE Director and MySQL expert Ronald Bradford, with coauthor Chris Schneider, Effective MySQL: Replication Techniques in Depth describes what is needed to understand ...

  • High Performance Drupal: Fast and Scalable Designs
    High Performance Drupal: Fast and Scalable Designs
    By Jeff Sheltren, Narayan Newton, Nathaniel Catchpole

    This comprehensive guide provides best practices, examples, and in-depth explanations for solving several performance and scalability issues.

  • High Performance MySQL: Optimization, Backups, and Replication
    High Performance MySQL: Optimization, Backups, and Replication
    By Baron Schwartz, Peter Zaitsev, Vadim Tkachenko

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