MySQL High Availability: Tools for Building Robust Data Centers
| Author | : | |
| Rating | : | 4.61 (848 Votes) |
| Asin | : | 1449339581 |
| Format Type | : | paperback |
| Number of Pages | : | 762 Pages |
| Publish Date | : | 2013-04-04 |
| Language | : | English |
DESCRIPTION:
Charles A Bell is a Senior Software Engineer at Oracle. He received his Doctor of Philosophy inEngineering from Virginia Commonwealth University in 2005. He lives in a small town in ruralVirginia with his loving wife. Hisresearch interests include database systems, versioning systems,semantic web, and agile software development.. He iscurrently the lead developer for backup and a member of the MySQLBackup and Replication team. About the AuthorDr
This second edition describes extensive changes to MySQL tools. 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. 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
Dimitri K said Useful but outdated. Pretty informative and useful. However the book is outdated. Many topics of this book are no more needed with newer software versions.. David F. said Great book! Full of very useful information. Great book! Full of very useful information.
He lives in a small town in ruralVirginia with his loving wife. Hisresearch interests include database systems, versioning systems,semantic web, and agile software development.. He received his Doctor of Philosophy inEngineering from Virginia Commonwealth University in 2005. He iscurrently the lead developer for backup and a member of the MySQLBackup and Replication team. Charles A Bell is