MySQL high availability
By: Bell, Charles A
Title By: Kindahl, Mats | Thalmann, Lars
Material type: BookPublisher: Beijing : O'Reilly, 2010.Edition: 2nd ed.Description: xxvi, 733 p. : ill. ; 24 cm.ISBN: 978-1449339586; 0596807309 (pbk.) :Uniform titles: My SQL high availability : tools for building robust data centers Subject(s): MySQL (Electronic resource) | Database managementDDC classification: 005.7565 Online resources: Location MapItem type | Home library | Call number | Status | Date due | Barcode | Item holds |
---|---|---|---|---|---|---|
REGULAR | University of Wollongong in Dubai Main Collection | 005.7565 BE MY (Browse shelf) | Available | T0051002 |
, Shelving location: Main Collection Close shelf browser
005.7565 AL MI Microsoft Access 2007 data analysis / | 005.7565 BA AC Access 2013 : | 005.7565 BA AL Alison Balter's mastering Microsoft Office Access 2007 development / | 005.7565 BE MY MySQL high availability | 005.7565 DA MY MySQL stored routines : | 005.7565 DU FI FileMaker API for PHP 12 : | 005.7565 FA OR Oracle database problem solving and troubleshooting handbook |
Includes index.
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 Library Handle failing components through redundancy Scale out to manage read-load increases, and use data sharding to handle large databases and write-load increases Store and replicate data on individual nodes with MySQL Cluster Monitor database activity and performance, and major operating system parameters Keep track of masters and slaves, and deal with failures and restarts, corruption, and other incidents Examine tools including MySQL Enterprise Monitor, MySQL Utilities, and GTIDs