Free Downloads
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. 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

Paperback: 762 pages

Publisher: O'Reilly Media; 2 edition (April 28, 2014)

Language: English

ISBN-10: 1449339581

ISBN-13: 978-1449339586

Product Dimensions: 7 x 1.5 x 9.2 inches

Shipping Weight: 2.7 pounds (View shipping rates and policies)

Average Customer Review: 4.7 out of 5 stars  See all reviews (3 customer reviews)

Best Sellers Rank: #1,064,066 in Books (See Top 100 in Books) #134 in Books > Computers & Technology > Databases & Big Data > MySQL #508 in Books > Computers & Technology > Databases & Big Data > SQL #1091 in Books > Textbooks > Computer Science > Database Storage & Design

Pretty informative and useful. However the book is outdated. Many topics of this book are no more needed with newer software versions.

This books covers HA from beginning to end. If you are putting together a slave or cluster, this book contains valuable information about it.

Great book! Full of very useful information.

MySQL High Availability: Tools for Building Robust Data Centers PHP: MySQL in 8 Hours, For Beginners, Learn PHP MySQL Fast! A Smart Way to Learn PHP MySQL, Plain & Simple, Learn PHP MySQL Programming Language in Easy Steps, A Beginner's Guide, Start Coding Today! MYSQL Programming Professional Made Easy 2nd Edition: Expert MYSQL Programming Language Success in a Day for any Computer User! (MYSQL, Android programming, ... JavaScript, Programming, Computer Software) Data Architecture: A Primer for the Data Scientist: Big Data, Data Warehouse and Data Vault Data Analytics: Practical Data Analysis and Statistical Guide to Transform and Evolve Any Business Leveraging the Power of Data Analytics, Data Science, ... (Hacking Freedom and Data Driven Book 2) Architecting for Scale: High Availability for Your Growing Applications Cassandra 3.x High Availability - Second Edition High Availability and Disaster Recovery: Concepts, Design, Implementation High Availability and Disaster Recovery Big Data For Beginners: Understanding SMART Big Data, Data Mining & Data Analytics For improved Business Performance, Life Decisions & More! The Data Revolution: Big Data, Open Data, Data Infrastructures and Their Consequences Microsoft Excel 2013 Building Data Models with PowerPivot: Building Data Models with PowerPivot (Business Skills) High Blood Pressure Cure: How To Lower Blood Pressure Naturally in 30 Days (Alternative Medicine, Natural Cures, Natural Remedies, High Blood Pressure ... Cures for High Blood Pressure, High Bl) Pokemon Go : The Complete Guide (Strategies For Rare and Legendary Pokemon): Pokemon Go Ultimate Guide : A Robust Tutorial Backed By Over 200 Hours Of Research and Data With Daily Tips (iOs, Android) Learn MySQL in Plain English: A Beginner's Guide to MySQL Learning MySQL and MariaDB: Heading in the Right Direction with MySQL and MariaDB Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5 (Learning Php, Mysql, Javascript, Css & Html5) Introducing Data Science: Big Data, Machine Learning, and more, using Python tools Availability of Credit and Secured Transactions in a Time of Crisis Discovering Knowledge in Data: An Introduction to Data Mining (Wiley Series on Methods and Applications in Data Mining)