High Availability MySQL Cookbook.pdf

High Availability MySQL

Cookbook

Over 50 simple but incredibly effective recipes focusing

on different methods of achieving high availability

for MySQL databases

Alex Davies

Copyright © 2010 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or

transmitted in any form or by any means, without the prior written permission of the publisher,

except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the

information presented. However, the information contained in this book is sold without

warranty, either express or implied. Neither the author, Packt Publishing, nor its dealers or

distributors will be held liable for any damages caused or alleged to be caused directly or

indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all the companies

Olton

Birmingham, B27 6PA, UK.

ISBN 978-1-847199-94-2

www.packtpub.com

Cover Image by Vinayak Chittar (vinayak.chittar@gmail.com)

Credits

About the Author

was the first simple guide for MySQL Cluster after working with MySQL for many years and

routinely facing the challenge of high availability. Alex has continued to use MySQL Cluster

and many other high-availability techniques with MySQL. Currently employed as a system and

virtualization architect for a large e-Gaming company, Alex has also had the fortune to work for

companies of all sizes ranging from Google to countless tiny startups.

In writing this book, I owe an enormous debt of gratitude to the developers

enormous amount of his valuable time offering suggestions and correcting

errors in the drafts of this book. The final version is much stronger as a

result and any remaining errors are entirely my own.