High Availability MySQL Cookbook

Alex Davies

ISBN 10: 1847199941 / ISBN 13: 9781847199942

Published by Packt Publishing, Limited, 2010

About this Item

pp. 276.

Seller Inventory # 262096318

Bibliographic Details

• Title: High Availability MySQL Cookbook
• Publisher: Packt Publishing, Limited
• Publication Date: 2010
• Language: English
• ISBN 10: 1847199941
• ISBN 13: 9781847199942
• Binding: Soft cover
• Condition: New

About this title

Synopsis

There's more than one way to achieve high availability for MySQL and this Cookbook covers a range of techniques and tools in over 60 practical recipes. The only book of its kind, you'll be learning the natural, engaging way. Overview Analyze and learn different high availability options, including clustering and replication solutions within MySQL Improve uptime of your MySQL databases with simple recipes showing powerful high availability techniques for MySQL Tune your MySQL database for optimal performance. The only complete, practical, book of MySQL high availability techniques and tools on the market Part of Packt's Cookbook series: Each recipe is a carefully organized sequence of instructions to complete the task as efficiently as possible What you will learn from this book Configure a MySQL Cluster for scaling out MySQL Learn the technique of taking online backups and recovery Achieve high availability with MySQL Replication and various tools such as the open source Multi-Master Replication Manager (MMM) and Flipper projects Configure a MySQL replication design to replicate data from one MySQL database server to one or more other MySQL database servers Master the safety tricks of replication to prevent replication failure Configure a MySQL service to work using a shared storage device to achieve high availability, with and without a clustered filesystem Learn to use the open source Global File System (GFS) to have the same file system on more than one node Achieve high availability using block level replication with Distributed Replicated Block Device (DRBD) Improve your system's performance with the technique of performance tuning Approach This book uses the approach of a cookbook. Each recipe provides the reader with easy step-by-step descriptions of the actions necessary to accomplish a specific task. It is designed to present what often appear as extremely complicated techniques as a series of simple-to

About the Author

Alex Davies

Alex Davies has a wealth of experience working with MySQL, becoming a founding member of the MySQL Guilds before the age of 18. Author of the first book on MySQL Clustering, published in 2006, Alex has significant experience working on MySQL servers, often working on scalability and high availability problems.