MySQL high availability : [tools for building robust data centers

Product 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 About the Author Dr. Charles A Bell is a Senior Software Engineer at Oracle. He is currently the lead developer for backup and a member of the MySQL Backup and Replication team. He lives in a small town in rural Virginia with his loving wife. He received his Doctor of Philosophy in Engineering from Virginia Commonwealth University in 2005. His research interests include database systems, versioning systems, semantic web, and agile software development. Dr. Mats Kindahl is a senior software developer working on the MySQL server. He is the main architect and implementor of MySQL's row-based replication and is responsible for strategic development of replication, reengineering, and the plugin architecture. Before starting at MySQL, he did research in formal methods, program analysis, and distributed systems, the area where he earned his doctoral degree in computer science. He has also spent many years developing C/C++ compilers and knows more programming languages than he has fingers. Dr. Lars Thalmann is the development manager for MySQL replication and backup. He is responsible for the strategy and development of these features and leads the corresponding engineering teams. Thalmann has worked with MySQL development since 2001, when he was a software developer working on MySQL Cluster. More recently, he has driven the creation and development of the MySQL backup feature, has guided the evolution of MySQL replication since 2004, and has been a key player in the development of MySQL Cluster replication. Thalmann holds a doctorate in Computer Science from Uppsala University, Sweden. 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. 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. 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