MySQL high availability : [tools for building robust data centers

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 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 troubleshootingGet techniques for improving response time and handling large data setsMonitor database activity and performance, as well as major operating system parametersKeep track of what masters and slaves are doing, and deal with failures and restarts, corruption, and other incidentsAutomate key tasks with code from an open source library written by the authorsLearn techniques for using MySQL in virtualized environments, such as Amazon Web ServicesUse 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 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 LibraryHandle failing components through redundancyScale out to manage read-load increases, and use data sharding to handle large databases and write-load increasesStore and replicate data on individual nodes with MySQL ClusterMonitor database activity and performance, and major operating system parametersKeep track of masters and slaves, and deal with failures and restarts, corruption, and other incidentsExamine tools including MySQL Enterprise Monitor, MySQL Utilities, and GTIDs Annotation Server bottlenecks and failures are a fact of life in any database deployment, but they dont 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 its 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 availabilityknowledge thats 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 LibraryHandle failing components through redundancyScale out to manage read-load increases, and use data sharding to handle large databases and write-load increasesStore and replicate data on individual nodes with MySQL ClusterMonitor database activity and performance, and major operating system parametersKeep track of masters and slaves, and deal with failures and restarts, corruption, and other incidentsExamine tools including MySQL Enterprise Monitor, MySQL Utilities, and GTIDs Server bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. To protect your system from outages, MySQL provides several features that work well whether you're running directly on the hardware, on virtual machines, or in the cloud. But to use features such as replication, clusters, and monitoring tools effectively, you need to understand how they work together, and which combination of features will give you the most reliable system for a price you can afford. Written by the people who designed these features, MySQL High Availability covers all aspects of reliability and high availability in MySQL from a practical point of view. You'll learn skills essential to any organization that depends on a MySQL database. Topics include: Replication architecture Tools for replication management Failover strategies Disaster recovery strategies Leveraging the cloud Using the binary log for recovery and troubleshooting Writing replication-friendly SQL Improving response time with memcached Monitoring the server Load balancing Automating common replication tasks MySQL Cluster Diagnostic tools Backup and recovery MySQL and third party backup solutions MySQL Enterprise Provides information on using the replication, cluster, and monitoring features of MySQL to protect a database system from outages.