MySQL Administrator's Bible (Bible (Wiley))

891 Pages·2009·4.5 MB·English

by  Sheeri K. Cabral

MySQL®
Administrator’s
Bible

MySQL®
Administrator’s
Bible
Sheeri Cabral
Keith Murphy
Wiley Publishing, Inc.
®
MySQL Administrator’s Bible
Published by
Wiley Publishing, Inc.
10475 Crosspoint Boulevard
Indianapolis, IN 46256
www.wiley.com
Copyright © 2009 by Wiley Publishing, Inc., Indianapolis, Indiana
Published simultaneously in Canada
ISBN: 978-0-470-41691-4
Manufactured in the United States of America
10 9 8 7 6 5 4 3 2 1
Library of Congress Cataloging-in-Publication Data:
Cabral,Sheeri, 1978-
MySQL administrator’s bible / Sheeri Cabral, Keith Murphy.
p. cm.
Includes index.
ISBN 978-0-470-41691-4 (paper/website)
1. MySQL (Electronic resource) 2. Database management.3. Relational databases. I. Cabral, Sheeri,
1970- II. Title.
QA76.9.D3C3178 2009
005.75(cid:2)65 — dc22
2009005633
No part of this publication may be reproduced, stored in a retrievalsystem or transmitted in any form or
by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permit-
ted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written
permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copy-
right Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, [phone], fax [phone].
Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley
& Sons, Inc., 111 River Street, Hoboken, NJ 07030, [phone], fax [phone], or online at
http://www.wiley.com/go/permissions.
Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties
with respect to the accuracyor completeness of the contents of this work and specifically disclaim all warranties,
including without limitation warrantiesof fitness for a particular purpose. No warrantymay be createdor
extended by sales or promotional materials. The advice and strategies contained herein may not be suitable for
everysituation. This work is sold with the understanding that the publisher is not engagedin rendering legal,
accounting, or other professional services.If professional assistance is required, the servicesof a competent
professional person should be sought. Neither the publisher nor the author shall be liable for damagesarising
herefrom.The factthat an organization or Web site is referredto in this work as a citation and/or a potential
source of further information does not meanthat the author or the publisher endorses the information the
organization or Web site may provide or recommendations it may make.Further, readersshould be awarethat
Internet Web sites listed in this work may have changed or disappeared between whenthis work waswritten
and when it is read.
For generalinformation on our other products and servicesplease contact our Customer Care Department
within the United States at [phone], outside the United States at [phone] or fax [phone].
Trademarks: Wiley and the Wiley logo are trademarksor registeredtrademarksof John Wiley & Sons, Inc.
and/or its affiliates, in the United States and other countries, and may not be used without written permission.
MySQL is a registeredtrademark of MySQL AB Company. All other trademarksare the property of their respec-
tive owners. Wiley Publishing, Inc. is not associated with any product or vendor mentioned in this book.
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be
available in electronic books.
To Mitch Cherniack, who taught me databasesand inspired my
love of them. In memory of Zvi Kramer and Yehoshua
Kritzer — may I be able to echo their strength and
spirit. — Sheeri Cabral
For Rachel, the love of my life. — Keith Murphy

About the Authors
SheeriK. Cabralis a Database Team Lead at the Pythian Group, a remote database administra-
tion solution. She has a master’s degree in computer science specializing in databases from Bran-
deis University and a career background in systems administration.Unstoppableas a volunteer
and activist since she was 14, Sheeri founded and organizes theBoston MySQL User Group.She
also produces OurSQL: TheMySQL Database Podcast for the Community,By the Community
and manyworkshop videos. These resources are freely available at www.technocation.org,
the website of Technocation, Inc. Sheeri is the Treasurer of Technocation, Inc, a not-for-profit
organization providingresources and educational grants for IT professionals. Sheeri currently
lives in the Boston area with her husband TonyCabral and a myriad assortment of Muppets™ .
When she’s not workingor volunteering,she reads, knits, listens to podcasts, and enjoys time
with her nieces and nephews.
Keith Murphy is a MySQL database administratorwho has been using MySQL server
since 1998. A long-time Linux system administrator,he worked with a numberof Internet
companies solving systems issues. More recentlyhe formed Paragon ConsultingServices
(http://www.paragon-cs.com)to provideconsultingservices for companies seeking training
for MySQL and help with MySQL solutionsranging from everyday database administration
tasks to utilizing‘‘cloud’’ computingservices, performancetuning, and scaling. In addition to
informationabout the company, Keith blogs at http://blog.paragon-cs.com,which he
updates as frequentlyas possible with tricks, tips, and general informationabout MySQL server.
In addition he is theeditor of MySQL Magazine (http://www.mysqlzine.net),the MySQL
community’sdigital magazine about all thingsMySQL. It is his pleasure to work with some of
the finest people in the communityin this collaborativeeffort to increase both the amount and
qualityof the available informationon MySQL server.
Readers are invited to contact Keith by email at [email protected].