Publisher: O'Reilly Media Released: June 2010 Pages: 624
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 |
- Title:
- MySQL High Availability
- By:
- Charles Bell, Mats Kindahl, Lars Thalmann
- Publisher:
- O'Reilly Media
- Formats:
-
- Print
- Ebook
- Safari Books Online
- Print:
- July 2010
- Ebook:
- June 2010
- Pages:
- 624
- Print ISBN:
- 978-0-596-80730-6
- | ISBN 10:
- 0-596-80730-9
- Ebook ISBN:
- 978-0-596-80732-0
- | ISBN 10:
- 0-596-80732-5
|
-
Charles Bell Dr. Charles A Bell is a Senior Software Engineer at Oracle. He iscurrently the lead developer for backup and a member of the MySQLBackup and Replication team. He lives in a small town in ruralVirginia with his loving wife. He received his Doctor of Philosophy inEngineering from Virginia Commonwealth University in 2005. Hisresearch interests include database systems, versioning systems,semantic web, and agile software development. View Charles Bell's full profile page. -
Mats Kindahl Dr. Mats Kindahl is a senior software developer working on the MySQLserver. He is the main architect and implementor of MySQL's row-basedreplication and is responsible for strategic development ofreplication, reengineering, and the plugin architecture. Beforestarting at MySQL, he did research in formal methods, programanalysis, and distributed systems, the area where he earned hisdoctoral degree in computer science. He has also spent many yearsdeveloping C/C++ compilers and knows more programming languages thanhe has fingers. View Mats Kindahl's full profile page. -
Lars Thalmann Dr. Lars Thalmann is the development manager for MySQL replication andbackup. He is responsible for the strategy and development of thesefeatures and leads the corresponding engineering teams. Thalmann hasworked with MySQL development since 2001, when he was a softwaredeveloper working on MySQL Cluster. More recently, he has driven thecreation and development of the MySQL backup feature, has guided theevolution of MySQL replication since 2004, and has been a key playerin the development of MySQL Cluster replication. Thalmann holds adoctorate in Computer Science from Uppsala University, Sweden. View Lars Thalmann's full profile page. |
Colophon The animal on the cover of MySQL High Availability is an American robin (Turdus migratorius). Instantly recognizable by its distinctive appearance—dark head, reddish-orange breast, and brown back—this member of the thrush family is among the most common American birds. (Though it shares its name with the European robin, which also has a reddish breast, the two species are not closely related.) The American robin inhabits a range of six million square miles in North America and is resident year-round through much of the United States. Commonly considered a harbinger of spring, robins are early to sing in the morning and among the last birds singing at night. Their diets consist of invertebrates (often earthworms) and fruit and berries. Robins favor open ground and short grass, so they are frequent backyard visitors, and they are often found in parks, in gardens, and on lawns. |
|
Description
|
Table of Contents
|
Product Details
|
About the Author
|
Colophon
|
 |
|
|
|
|
|
Recommended for You
|
Recently Viewed
|
|
|
By S. E. Slack, Greg Slack
September 2007
Ebook: $19.99
Print & Ebook: $27.49
Print: $24.99
By Shelley Powers
March 2001
|
Customer Reviews
11/24/2010 (2 of 2 customers found this review helpful) 4.0Good coverage of MySQL and replication By sjmudd from Madrid, Spain About Me Database Administrator, Sys Admin - Accurate
- Concise
- Easy to understand
- Helpful examples
- Well-written
|
|
|
